Run VBA when Access opens?

[djw]

Is there anyway to get Access to run some code as soon as it is opened
(without using a form)?

Is there an Access equivalent to doing something like the following in
Excel:
Private Sub Workbook_Open ()
'some code that runs when opened
End Sub

Thank you,
David

 

[djw]

Never mind I found it in the group.

All that is required is to create a Macro called AutoExec.

 

[a a r o n . k e m p f]

SQL Server Agent makes it quite easy to launch VB code on a scheduled
basis.

it's free with MSDE, and it's 100 times superior to anything in Jet

 

[Tony Toews [MVP]]

Never mind I found it in the group.

All that is required is to create a Macro called AutoExec.

Correct.

Please ignore Aaron's reply as it is completely irrelevant to your
situation.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[David W. Fenton]

Please ignore Aaron's reply as it is completely irrelevant to your
situation.

This could be more succinctly stated thus:

Please ignore Aaron's reply as it is from Aaron.

(i.e., by definition, non-responsive, and in 99.99% of cases,
factually wrong)

 

[Larry Linson]

Correct.

Please ignore Aaron's reply as it is completely irrelevant to your
situation.

I'm reading this newsgroup at "news.aioe.org" and don't see a reply from
Aaron -- I wonder if someone at that news provider saw right through him and
just blocked his posts?

Larry

 

[a a r o n . k e m p f]

Larry;

Yes, maybe you subscribe to a list that sponsors censorship.

Maybe you should stop playing with Jet and learn a real mans database.

-Aaron

 

[a a r o n . k e m p f]

It's actually not irrelevent.

SQL Server Agent is a ton more powerful than Jet macros, and it is a
flawless migration path.