[AccessD] AutoExec Macro Question

John Ruff papparuff at attbi.com
Thu Mar 6 10:53:37 CST 2003


What does your basLoad function do?

John V. Ruff - The Eternal Optimist :-)

"Commit to the Lord whatever you do,
	and your plans will succeed." Proverbs 16:3



-----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:34 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] AutoExec Macro Question


Yup, it's a public function.

-----Original Message-----
From: Seth Galitzer [mailto:sgsax at ksu.edu] 
Sent: Thursday, March 06, 2003 10:14 AM
To: accessd
Subject: RE: [AccessD] AutoExec Macro Question


Susan,

One more thing to check.  Are you sure basLoad is a function and not a sub?
IIRC, the RunCode macro directive will only call public functions and not
subs.  Another way to test is to open any module and try to run the function
from the Immediate Window.  Just type
	?basLoad
anywhere in the window.  If it is a function and it is public, it should
run.  If it doesn't run, then chances are one of those two things is not
true.

Seth

On Thu, 2003-03-06 at 09:55, Susan Zeller wrote:
> 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
> 

-- 
Seth Galitzer			sgsax at ksu.edu
Computing Specialist		http://puma.agron.ksu.edu/~sgsax
Dept. of Plant Pathology
Kansas State University

_______________________________________________
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





More information about the AccessD mailing list