Automatically Open A Form

[campo88]

Hi

I am relatively new to vba. Can anyone please help on the below questions.

1) Is there a simple vba event I can build to automatically open a form up once the file has been opened.

2) Is there a site or a list that you can recommend to me that will help me understand all the different event procedures that I can build and what they do?

Many Thanks

 

[DCrake]

If you go to Tools > startup you can specify which form to load when the Access application if first loaded.

Microsoft Knowledgebase is a good starting point for Access help.

David

 

[campo88]

Hi Again

This is quite embarrassing for me, however I cannot find tools , startup.

I think this is because i have access 2007. Can you help please?

 

[ajetrumpet]

Hi Again

This is quite embarrassing for me, however I cannot find tools , startup.

I think this is because i have access 2007. Can you help please?

i think this is the route...

OFFICE BUTTON > ACCESS OPTIONS > CURRENT DATABASE > TOP SECTION > STARTUP FORM > SELECT IT FROM THE DROPDOWN!

 

[campo88]

Perfrect - Thanks for your help.

Is there a way of doing this using vba?

 

[boblarson]

Perfrect - Thanks for your help.

Is there a way of doing this using vba?

If you don't use the startup options then you need to use an AutoExec MACRO to do something when the database opens.

You create a MACRO and name it AutoExec and it fires off as the first thing when the database is opened. You can do any macro actions including opening a form or RunCode, etc.

 

[Khalid_Afridi]

AutoExec macro is very basic and the easiest way...