Search results

I tried this same code on another form only I replaced the combo box ProductID (of which VendorProductNo is in column 1) with a control VendorProductNo. So the syntax is the same except I replaced the field I was retrieving to ProductID and the VendorProductNo = me.VendorProductNo instead of...

OK here goes. I have three tables: Products, Suppliers and ProductSupplierJoin. Products has the following fields among others: ProductID - Key field VendorProductID Indexed No duplicates Suppliers has the following field among others...

If you mean put the requery in the OnClose action of the entry form, that doesn't work either. I still get the error: You must save the current field before you run the requery action. I seem to get this error no matter where I put it.

I have a form [Purchase Orders] and a subform [Purchase Orders Subform]. On the 1st form I have a combo box from which the user can select from a list of suppliers. On the subform there is a combo box from which the user can select from a list of products sold by the supplier chosen above. If...

I just figured it out. I built the query using the wizard and selected the Products table. I then selected the ProductID and SupplierID fields and clicked finish. I then went into design mode and clicked query and made it an append query. I selected the ProductsSupplierJoin table as the table to...

I have two tables Products and ProductsSupplierJoin. Both tables have ProductID and SupplierID. I want to append records to the ProductsSupplierJoin table from the Products table using the ProductID and SupplierID fields. I've set up an append query according to the instructions on the...

Cascading Combo Boxes form and subform Thanks for the info. I found the same thing in a Microsoft article. My syntax was off. Thanks to all the great info I get here I'm learning a quite a lot of what I need to know. Thanks again. From the land of the frozen chosen.

I have two tables Suppliers with SupplierID as the primary key and another table Products with ProductID as the primary key and SupplierID as a foreign key linked to Suppliers. I have a form with a combo box SupplierID and a subform with a ProductID combo box. For the SupplierID combo...

Report with many to many Thanks Pat. I followed your suggestion on using subreports and it worked beautifully once I got past some formatting issues. Thanks so much for all your help!

Report many to many I'm using Access 2002 I can't post it in Access 97. I'll need to take it home where I have 97 and post it from there. I can send you the report. It may give you a little insight into my problem.

Report with many to many I should also mention that when I report Inventory and Software separate with the User info, the reports work fine. The problem comes in when I try to combine the Inventory and Software on the same report with the user info.

Report with many to many I've already tried the sorting and grouping. Sorry I didn't mention that. I have Employee sirst and that works fine. The problem come in with Inventory and Software. When I put Inventory second and software thrid, software repeats. When I reverse that the inventory...

I have 4 tables set up as follows: tblEmployee EmployeeID FullName Department tblInventory EmployeeID IDTag Description SerialNumber tblSoftwareModuleUser (Join table)...

Thanks. That's all I needed. It was the Limit To List option That I missed. I had it set to No, so no matter what I did it wasn't going to check the list for missing entries. Thanks for your help.

I have two tables OperatorMaster and MachineProduction which have a one to many relationship. The tables have the following fields: OperatorMaster MachineProduction OperatorNo OperatorNo OperatorName...

Never mind that last post. I put form instead of forms for retreiving the machine from the master file. Thanks so much for all your help and patience. This forum is a fabulous resource for all us who are new to Access.

I put a text box containing the Machine field from the Machine Master table. Then I put a combo box which had the row source sql statement (SELECT tblProduct.ProductID from tblProduct INNER JOIN tblMachineJoin ON tblProduct.ProductKey=tblMachineJoin.ProductKey WHERE...

Thanks. That will be a big help.

I see discussions which refer to the Northwind database as an example. Could someone tell me where the Northwind Database is and how I get to see the examples everyone is talking about.

I've created the join table containing the primary keys from Machine Master and Product Master. In the join table we have machine numbers 61 and 62 with 204 product keys each 1 thru 204. that accounts for 408 records total. When I click the drop down arrow on the form to select a machine, I get...