AUTO OPEN code in Access?

[norbert. beliso]

Please.
Is there an AUTO_OPEN code for Access 2000 & 2002
thats similar to Excels AUTO_OPEN.

I just want to write code that executes
when user opens up my Access program.

thank you.

 

[Ricardo]

http://www.espacoaccess.com/Access97/Abertura.zip

 

[Bogdan Zamfir]

There are few ways to accomplish this:

1. Create a macro named Autoexec, and from it add action RunCode which will
call your startup function, created in a module

or

2. Create a form to be startup form, go to menu Tools -> Startup, and select
it in Display form / Page dropdown list

HTH,
Bogdan

 

[Alan]

-----Original Message-----
Please.
Is there an AUTO_OPEN code for Access 2000 & 2002
thats similar to Excels AUTO_OPEN.

I just want to write code that executes
when user opens up my Access program.

thank you.
.
I would put the code in the On Activate event of the

first form that opens. If you go to Tools_Startup you can
select which form opens when the database opens.