Recent content by Don White

I have 2 tables and when I add a record to one table I want the second table updated also with the same control (groupname in my sample). Duplicate field is only the prime key. This in my mind is very common. If the groupname is 1111 the second table I want the prime key to be 1111. So when...

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...

variable No I can not hard code the variable. Read the message again to understand my message. Thanks, :confused:

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...

query using variable 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...

record time elapse I need to display the time the report ran. I have over 600,000 records. I need to display the time it takes to run in minutes. The example below will not display the time correctly. How do I display the time in minutes? Thanks, example: dim start1 as date dim end1 as...

Print only selected on report, but final total of all records I need to select only certain records to print on a report, but I need a final total of all records. How do I do this? Thanks

union query and regular query error I have one union query made by SQL language in microsoft access and the other query made by query by microsoft access. I sum the union SQL on a field and get 2008 I sum on the other query and get 2007. The two queries have 24 records each and I have added...

Close macro I still need to close a query using the close macro. The close macro does not close my query. Why??? How can I close a query using the close macro?

close query with macro does not work, why I need to close a querywith the close macro command. It will not close the query. I do not want the user to close it. Why does the close query not work?? Thanks, Don

Variable use with Query and report I use a variable to select records in a query. I enter the variable when the query runs and also have to enter the variable when I use that query results for a report. I want to enter the variable only once when I run the query and not at the report time...

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...