Enabling Macro and VBA on start up

[Rob Ross]

Is there a way to enable the macros and VBA coding when the program opens without having to do it manually? My database opens with the application frame hidden so users don't get the message to enable the code. It is a multi user database that is accessed on line.

 

[RainLover]

You can create a Macro that is named "AutoExec".

This will fire on start up.

I trust every user has their own copy of the Front End on their own Drive.

 

[mdlueck]

Sounds like you need this post, Rob:

Trusted Location
http://www.access-programmers.co.uk/forums/showthread.php?t=217954

And FYI: I have found that the keyname is not critical to be following the MS naming standard, so I make it the name of the Company or Application. The OP used "MyApp" for their example.

 

[Rob Ross]

Thanks, would it be better to do this or is there a way to have a pop up come up to let users enable it since I have the application window hidden?

 

[mdlueck]

Unless you list the database as trusted (via that suggested post) then NO CODE will run when your database opens.

You said it has a hidden window too.

I would think it is obvious you must set a trust rule in order to avoid grid lock.