I'm so glad someone else thinks it is inefficient too! I think I understand what you are saying about the append query. How will using an append query affect the copies I need to make to the related tables? The main table is related to about 10 other tables and 2 of those 10 tables have 3...
I had the (mis)fortune to inherit a coworker's VBA application for a client, and I'm having a huge problem with the copy function. The function is supposed to copy the records from one database into another. With small amounts of records, the function works fine, but the DB the client wants to...
Thanks for the suggestion. I tried it, and unfortunately the variable is still empty. Argh!! I talked to the original programmer and she told me that for some reason, the value of that variable is sometimes dropped.
I have a standard module that declares the app's global variables, including the logon id of the user. I have no problem using the logon variable in a form, but when I try to use it in a report, the report does not find the variable. Why is this? The variable was declared as a public variable...
I am very new to this, so please bear with me! I have a report that shows who placed the order, address, etc., but the data for this report needs to come from two different tables based on the user's id once they've logged in. I was able to do this successfully for a form, but I'm having...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.