Novice looking for some help. I have a few lines of code that automate a process. The code works fine when I run the code manually. I created an autoexec macro in Access 2000 that runs the code upon opening the Access 2000 database. For some reason the code stops running.

Call Shell("C:\App\Change.exe", 1)
SendKeys "%(u)", True - the code stops here when you open the database that automatically begins running the code

sendkeys "~~", true
SendKeys "{tab}~{tab}{tab}", True
SendKeys "mydate{tab}%(x)", True

Can anyone help me?