Emily has attended:
Access VBA course
VBA
How do you automate actions as soon as you open up the database? For instance - prompting the user as soon as they open the DB to enter their name.
RE: VBA
Hi Emily
Thank you for your question
Apologies for the delay in replying which was caused by a large volume of posts on the forum
The best solution to this problem is to create the function that you want to run. Then create a Macro called autoexec. This macro has a single command RunCode, and you enter the function name as a parameter of that command.
The autoexec macro will automatically run when the database opens
Regards
Stephen