Recent content by Andrlimo

Plog, Thank you for the quick reply. However, I now have another issue. I'm sure that this issue is because it is appending one record to the table at a time, but is there a way in VBA to write it so that I don't have to hit okay every time to append a record to the table.

Below is the code I came up with to run the append query. However, I am having an issue with variable y in my Insert into query. Every time it runs through the loop it asks for the value of y. Do I have this written correctly or is there some other way to complete this? Stopher there is the...

I was wondering if that was going to be the case. I think that I should be able to make that work. I just thought there was an easier way than VBA.

I am trying to create an append query where there are three fields. I am able to make two of the fields work. However, I am having trouble creating another field. I will have a form that a user will input the beginning number and the ending number and I want the append query to create that...