Search results

I have one form with fields from 2 tables. When I add a new record I want it to add a new record to both tables. Each table has a field name called "Groupname". After click on the add record, it clears all fields in the form just like it should. Then I populate the fields with data and when...

I am new at VB, but learning. The following code (part of the code) give gives me an error (Compile Error: Method or data member not found: Dim rst As Recordset Dim rst2 As Recordset Dim dbs As Database Set dbs = CurrentDb dbs.Execute ("DELETE * FROM Groupfile") 'empty table for new data...

I created a query using a varible to select only the months needed. This variable will change based on the report needed next time. The customer has that option. When I go to the report, I do not want to enter the variable again (Query has the correct records already), but the report is...

I am using a query with a variable which select what records I want to use. When I use the query from the query above it ask me for the variables again. I do not want to input the variable again because I have the records I need but must use the 1st query for the secord query to build what I...

Close Query using macro does not work Why does the close macro statement not work with Queries. I need to close the window when I finish the query. I only run the query for input to a report. How do I correct this? The user does not need to see the query, he only needs to see the report...

I have two queries, not tables One has the following data: fac Grp 001 001 111 111 222 222 The other query has following data: fac grp 001 001 444 444 555 555 I need to make one query with all 6 records in the output of the created query. The second query...

I have a table that I want to add a field from another table. table one has a field called grp that I want to add what fac they are from. Table two has the Fac code. How do I add the fac code without ending up with duplicate records in the new table example: table one: grp 1 grp 2 grp 3...

Add Fac code from one table to another I have a table that I want to add a field from another table. table one has a field called grp that I want to add what fac they are from. Table two has the Fac code. How do I add the fac code without ending up with duplicate records in the new table...