Results 1 to 2 of 2

Thread: On database open

  1. Mar 13th, 2004, 03:33 PM #1
    stricknyn
    stricknyn is offline

    Thread Starter
    Fanatic Member
    Join Date
    Mar 2004
    Posts
    541

    On database open

    THis sounds simple enough, but I can't figure it out for the life of me. I have a function and a macro in Access which does exactly what it is supposed to do. What I want to do is run the function and macro as soon as the database opens. I don't want to put it in a form load because I want it to check for some things as soon as the database opens. Anyone have any ideas? THanks

    James
    Reply With Quote Reply With Quote
  2. Mar 14th, 2004, 02:20 PM #2
    alex_read
    alex_read is offline
    Evil Genius alex_read's Avatar
    Join Date
    May 2000
    Location
    Espoo, Finland
    Posts
    5,538
    Sounds it, but isn't - took ages for me to find when I needed this !

    Anyway, goto the macros section of access, create a new macro & set the top action to RUNCODE adding the name of your custom function procedure to the bottom of the screen (the "function name" parameter box).

    This is the only way access will run a code procedure upon startup. This macro has to be named AutoExec.

    Please rate this post if it was useful for you!
    Please try to search before creating a new post,
    Please format code using [ code ][ /code ], and
    Post sample code, error details & problem details
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width