Startup Module for Public Function/

[Mel_P]

I can't seem to find or create a startup module. how do I create this please?

 

[pono1]

Typically Access Applications have a start up form object. There is no Main module that runs at start up as there is, say, with C++ and Java.

So your solution might be -- assuming I understand the problem -- to configure the app's start up form. Menu: Tools-Startup...

And then call your main module function from the Open or Load event handler in the startup form's module.

Regards,
Tim

 

[Mel_P]

Basically I want somewhere to declare a public variable and a public function?

Another thread suggested this as a means of using this varaible in several places.

http://www.access-programmers.co.uk/forums/showthread.php?t=144805

Mel

 

[ezfriend]

Create a Macro and must call it "AutoExec"

For Action, use RunCode and under Function name call a function

Main()

In a module, declare a function like this.

Public Function Main()

    'do whatever you want to do here.
    
End Function

NOTE: Don't put anything in the start up

 

[Mel_P]

Thanks
Bit like VB6 - should have remembered. Nothing in Access "Help".

Mel