Executable?

[Tecora]

is it possible to create and exe like Visual Basic that will call your form instead of clicking on the form itself to run it?

 

[boblarson]

If you want a certain form to open up when you open the Access database, you can set that in the TOOLS / STARTUP menu. You can even uncheck the show database window box and it will not show the window with the forms/tables/queries/macros/modules, etc.

And to answer you about making an .exe from Access - NO that cannot be done. We won't go into the lengthy explanation here, but if you want more info search the archives for exe and you will find a ton of posts on that one.

BL
hth

 

[shacket]

Another way to do it is with an autoexec macro. Simply create a macro (that can do any of 1000 things, such as open a form, give a message box, run a query, etc.) and name it 'autoexec' and Access will run that macro each time the db is opened. To bypass the autoexec macro, you would hold down the shift key (although there are ways to disable the shift key as well).

 

[Megawisdumb]

Do you guys know a way to run a module from within the Database? I have ACCESS2002 and can't seem to find a run code command that will work inside a macro.

 

[Rich]

Unless the've removed it it's simply RunCode in the action section, with your function name in the code section at the bottom of the macro