[AccessD] Access 101 question

McGillivray, Don [IT] Donald.A.McGillivray at sprint.com
Mon Feb 18 19:55:22 CST 2008


Darryl,

There are a couple of ways to do this.  One is to use an AutoExec macro.  If your DB has a macro named AutoExec, it will run it automatically when the db opens.  I usually set the macro to RunCode() and point it to some startup routine.  You can also specify a form to load on startup, and place code in that form's OnLoad or OnOpen events, or you can use the /x command line switch when you start Access to specify the name of a macro to run on start up.

Hope this helps . . .

Don

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darryl Collins
Sent: Monday, February 18, 2008 5:45 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Access 101 question


Hey there,

I am sure this is dead easy, but am having brain freeze today.  What is the equivalent in Access of Excel's "Workbook_Open" command?  "Workbook_Open" will automatically run as the workbook opens and I want the same sort of thing for Access.  There are a few things I need to check as Access Opens but I am not sure on the syntax of this.

Cheers
Darryl

This email and any attachments may contain privileged and confidential information and are intended for the named addressee only. If you have received this e-mail in error, please notify the sender and delete this e-mail immediately. Any confidentiality, privilege or copyright is not waived or lost because this e-mail has been sent to you in error. It is your responsibility to check this e-mail and any attachments for viruses.  No warranty is made that this material is free from computer virus or any other defect or error.  Any loss/damage incurred by using this material is not the sender's responsibility.  The sender's entire liability will be limited to resupplying the material.

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com






More information about the AccessD mailing list