Stop second import

[voskouee]

I have a form with a button which imports an excel spreadsheet to a table and then runs some macros.

How can i stop the user from clicking the buttong twice and importing the records twice?

can i check if the table is empty?

thank you

 

[FoFa]

Disable the button once clicked until the process is completed, then re-enable the button.

 

[Lister]

Import the data into a temp table. Test the data in the temp with the data in the main table. If its a duplicate, error message, and delete all data in the temp table.
If it's new data, move from Temp table to main table.

I had the same trouble with click happy users. : )
Hope this helps.