Chris Mackin
chris at denverdb.com
Thu Mar 6 11:10:01 CST 2003
Susan, I think that's the best approach, have a hidden splash screen if necessary, have it do what it needs to do and then close itself and open the real main form. Much easier to debug/error trap if nothing else. Chris Mackin www.denverdb.com Denver Database Consulting, LLC -----Original Message----- From: accessd-admin at databaseadvisors.com [mailto:accessd-admin at databaseadvisors.com]On Behalf Of Susan Zeller Sent: Thursday, March 06, 2003 8:55 AM To: accessd at databaseadvisors.com Subject: RE: [AccessD] AutoExec Macro Question Chris, I know, I know! I have never used a Macro before, but in this case, my splash screen is also my main menu page and so users return to it over and over. The code that I wanted to call in the Autoexec Marco creates a connetion to my SQL Server using "Application Role" security. The way this works, I can only run this code once during the application. If it's called a second time, it gives an error. I changed the name of the function from Load to basLoad can put basLoad() in the macro. None of that works. So, I'm building a separate splash screen and putting the basLoad on open of that form. Still seems a mystery to me, though. --Susan -----Original Message----- From: Chris Mackin [mailto:chris at denverdb.com] Sent: Wednesday, March 05, 2003 4:41 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] AutoExec Macro Question "What am I doing wrong?" Using a Macro. Assuming you have a startup form selected you can call that code from any of the events of that form, Open, Load or Close seem like 3 obvious choices depending on what you're doing in the code. Chris Mackin Denver Database Consulting, LLC www.denverdb.com -----Original Message----- From: accessd-admin at databaseadvisors.com [mailto:accessd-admin at databaseadvisors.com]On Behalf Of Susan Zeller Sent: Wednesday, March 05, 2003 3:30 PM To: accessd at databaseadvisors.com Subject: [AccessD] AutoExec Macro Question I'm trying to use an AutoExec macro for the first time. I have an Acess XP ADP in Access 2002 format. I want to run a bit of code on start of the application so I created a macro called AutoExec which has one step: RunCode and in it I call a function called LOAD which is public and is in a module. When I start my application, it says it can't find Load. What am I doing wrong? --Susan Susan B. Zeller Office of Information Systems College of Continuing Education University of Minnesota 306 Wesbrook Hall 77 Pleasant Street SE Minneapolis, MN 55455 Phone: 612-626-4785 Fax: 612-625-2568 _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com