Results 1 to 2 of 2

Thread: VBA in Access 2000

  1. #1

    Thread Starter
    Lively Member
    Join Date
    May 2002
    Posts
    107

    VBA in Access 2000

    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?

  2. #2

    Thread Starter
    Lively Member
    Join Date
    May 2002
    Posts
    107
    I added a line SendKeys "{esc}" after the Call Shell line and it worked.

    Thanks for reading my question!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width