Sir,
During data entry through VB programming using loop. every time MS Access ask do you want to append the record?
How to add the record 15-20 times automatically without getting the POP UP window related to record?
Beginner
Windows 10 
Access 2016
Do you want to append the record in the table?
Sir,
During data entry through VB programming using loop. every time MS Access ask do you want to append the record?
How to add the record 15-20 times automatically without getting the POP UP window related to record?
Virtually Inert Person
Windows 7 32bit Access 2007
Either turn off warnings before the loop then back on again after it, or use the Execute method of the Database object, which does not prompt. If you use the former, you should ensure that they do not get turned off permanently, otherwise bad things can happen without the user's knowledge. I seldom turn off warnings anymore, but if I do, the procedure has an error handling routine that ensures they are turned back on.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
VBA Coding Append new record in one table and copy data from another table to new record
Append Query to append to a table in different database
Posting Permissions
Reply With Quote