From prev Question (http://stackoverflow.com/questions/1372636/adding-new-record-to-only-one-field-or-sync-button) FormA is bounded to multiple tables (a,b,c) from a, I have 1 combo-boxe(1) that displays customers from b, I have a combo-box(2) that displays items from c, (used as shopping basket) displays items the customer adds - com...
I need to create a report not based on a table or query but on a form The form has multiple Fields from table a, b, c and query x, y, z (all relating to what the end-user selects)..All those fields are combo-boxes how do I create a report based on that form. Thanks ...
Good day I have a table(abc) with 2 fields (items = type TEXT) & (Check = type Yes/No) I created a form, in a sub-form Table(abc) displays items, and a checkbox(check) How do I code a query to save only the items checked in another table. plz ...
Good day Created table(Team) with 3 fields namely:(Player_Name, Player_Class, Add_Player) The field (Add_Player) is a YES/NO or check-box field I created a form_A, created a subform_AB to display THE TABLE(Team) When I check the Add_Player, I created a Query to read only those player_names who are checked. AND THEN CREATE A REPORT ON...
I am creating a bill of materials program. There are two main tables named Products and Sub_Products. In the Products table, the fields are (Product_Name, Code). In the Sub_Products table, the fields are (Code, Sub_Name). The tables are linked with code, i.e.: one product is made up of many sub_products, each sub_product is a product ...
Good day, I created A query that takes information from a form ie:product_name and gets the component of that product, created another query to convert the component to a product, then created another query to get components of the new product, BY QUERY IT WORK'S, / Info on tables given in prev Question {http://stackoverflow.com/ques...
Good day I'm creating a report based on 7 Query's the 1st query gets product_name the 2nd query gets sub_product_name the 3rd query gets sub_sub_product_name .... and so on Not all products drop-down 7 levels, Thus only 3 query's are in use, ie(the other query's are blank, 'Which is what it is supposed to do) How do I create a repo...
Good day I am creating a bill of materials program. There are two main tables named Products and Sub_Products. In the Products table, the fields are (Product_Name, Code). In the Sub_Products table, the fields are (Code, Sub_Name). The tables are linked with code, i.e.: one product is made up of many sub_products, each sub_product is ...
Hello, Perhaps this is mere wishful thinking, but is there a simple way (in ASP.NET) to extract (at run-time) the formatting for different columns from a table in an Access 2007 database and apply that formatting to a GridView control? Also, is there a way to get the "Caption" values for columns in a table in the database and use those...
I need help navigating Microsoft Access Reports. I am in the Report Designer, and I need to know the which menu selection will enable me to view the Query that was used in the report. I have never used Access before. ...
Heya guys, Tough question here (for me at least); Here's the sit: I have a form base application in Access 2007 (must). There are a few forms which have exactly two (2) text boxes that allow input. Ideally, I'd like each of the text boxes to be mapped to different input devices, a Magnetic Swipe Card reader and a Barcode/Datamatrix re...
Is it possible to create a Application Level Custom Tab in Access 2007. Something that is not database specific but would appear in any database file opened. Storing Database as an Addin file does not seem to work ...
I have a legacy Access 2003 database file that must remain in that format to preserve its menus and toolbars. I have recently moved to Access 2007 in my build environment and will be deploying the compiled Access 2003 program with the Access 2007 runtime. In Access 2003, I could script the process of creating an MDE with the Access Devel...
hi all, the below mentioned code raises error "SYNTAX ERROR IN INSERT INTO STATEMENT" here i took name and number field has text no as autonumber(primary key) con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:/ppd/db1.mdb;Jet OLEDB:Database Password=techsoft"); da = new OleDbDataAdapter("select * from con...
I would like to set a field to a value selected from a grid in a dialog. I am using Access 2007. In WinForms I would: Create a child form create a grid for the data add a property for the selected item In the parent form add a button to open the form on successful dialog result get the selected item from the property update the ob...
I have a form containing two text boxes for user input. Both text boxes have the Property format set to "Short Date". One is the "start date", and the other is the "end date". I also have several tables, each with a DateTime field ("studystartdatetime"). I would like to be able to query these tables, but restrict the results to rows ...
Please describe the exact steps required to use a compiled Access 2003 mdb with the Access 2007 runtime and retain my custom menus and toolbars so that they look the same as they did with the 2003 runtime. I've tried following the various incomplete instructions around the web, but I either end up with my menus/toolbars on the ribbon's u...
This is my first time building a UI in Access (using Access 2007), and I'm wondering what is the Right Way (TM) of going about this. Essentially, I have several different queries that I'd like to display as pivot charts, pivot tables, tables, and reports. Eventually I'm also going to have to build forms to manipulate the data as well,...