auto pop up to form when you open access

[DARRENRRR]

I am very new to access and new some help please..... have table/form/list/report/ data base writtten and set up now and goes to hundreds of users site wide...........is there a way when user opens link to form it will auto open to the form i want them to see without them having to pick from side menu when they first open??????:banghead:

 

[DARRENRRR]

i know it matters i am running on access 2007

 

[mdlueck]

Is this what you are looking for?

Create a macro that runs when you open a database
http://office.microsoft.com/en-us/a...uns-when-you-open-a-database-HA010336239.aspx

 

[DARRENRRR]

thanks but i need a form in access to auto open not a web site to open like i said i am a newby

 

[mdlueck]

i need a form in access to auto open

Reread more carefully the page I linked to. That is exactly what an Autoexec Macro does... runs when the database is opened. One of the possible macro events is to "OpenForm". You plug that event into a Macro and name the Macro "Autoexec".

 

[pbaldy]

You can also skip the macro and enter the form in:

Office Button/Access Options/Current Database/Display Form

 

[mdlueck]

You can also skip the macro...

However, an Autoexec macro may be quickly renamed out of the way to Autoexec_HOLD for an extended period of time. Saves getting into the database properties screen.

 

[pbaldy]

If that's a concern, I suppose it might be the way to go, but I've never had to do it. I'd rather avoid having the extra object in the db and the extra processing (though both are admittedly minimal). The db is going to check for a startup form in that location anyway.

 

[DARRENRRR]

Reread more carefully the page I linked to. That is exactly what an Autoexec Macro does... runs when the database is opened. One of the possible macro events is to "OpenForm". You plug that event into a Macro and name the Macro "Autoexec".

thank you worked perfect

 

[DARRENRRR]

You can also skip the macro and enter the form in:

Office Button/Access Options/Current Database/Display Form

thank you very much

 

[pbaldy]

No problem.