Results 1 to 5 of 5

Thread: Running an VBA module when an Access file is opened

  1. #1

    Thread Starter
    Member
    Join Date
    May 2005
    Posts
    32

    Resolved Running an VBA module when an Access file is opened

    Hi,

    I need a way to run a module that I created in MS Access when I open the database file. I am familiar with the creation of the "Autoexec" macro name, but I don't know how (or if) I can to this macro to run a module.

    Thanks,
    VO
    Last edited by ovlia1286; Jun 27th, 2005 at 10:54 AM.

  2. #2
    PowerPoster
    Join Date
    Dec 2004
    Posts
    25,618

    Re: Running an VBA module when an Access file is opened

    i am not familiar with access, but in both word and excel the code window have some events that automatically run both have document ( / workbook) open events

    look for dropdown boxes at top of code window

    pete

  3. #3

    Thread Starter
    Member
    Join Date
    May 2005
    Posts
    32

    Re: Running an VBA module when an Access file is opened

    I'm not sure if I fully understand, could you please elaborate?

    Thanks,
    VO

  4. #4
    PowerPoster
    Join Date
    Dec 2004
    Posts
    25,618

    Re: Running an VBA module when an Access file is opened

    this is a vba code window from excel, word is almost identical and i would expect access to be similar

    this will not be in the code window for module,
    Attached Images Attached Images  

  5. #5

    Thread Starter
    Member
    Join Date
    May 2005
    Posts
    32

    Re: Running an VBA module when an Access file is opened

    Got it... thanks.


    VO

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