Access 07 Startup Sub Main

[MikeB]

Where is the setting to specify a procedure in a basic module to execute on
startup as in AC 2003?

 

[MikeB]

You can either set a Startup Form.
http://www.btabdevelopment.com/main/QuickTutorials/A2K7HowtoSetaStartupForm/tabid/135/Default.aspx

..or create a macro named AutoExec just as in ac2003.

I understand that, but you used to be able to specify a procedure in a BAS
module. Is that gone?

 

[Dirk Goldgar]

I understand that, but you used to be able to specify a procedure in a
BAS module. Is that gone?

I'm not aware of that ever having been possible. Are you sure you aren't
thinking of using an AutoExec macro to execute a RunCode action?

 

[Dirk Goldgar]

Where is the setting to specify a procedure in a basic module to execute
on startup as in AC 2003?

I'm not aware of any such setting in Access 2003, nor in earlier versions.
You can use an AutoExec macro to execute a RunCode action, or you can use a
startup form with code in its Open or Load event. Are you thinking of one
of those options?

 

[MikeB]

I'm not aware of that ever having been possible. Are you sure you aren't
thinking of using an AutoExec macro to execute a RunCode action?

Aargh! It's VB5/6.... Sorry. Big Brain Fart.
I guess when prototyping/testing in Access, I am used to typing the first
procedure in a BAS module as Sub Main or Sub SubMain and stepping through
the debugger from there and I was working in a project module and wanted to
initialize a class module from there. I got it working by calling the
subMain from the startup form. Thanks and sorry for the bother..