<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1170" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=850364314-17072003><FONT face=Arial color=#0000ff
size=2>Greg,</FONT></SPAN></DIV>
<DIV><SPAN class=850364314-17072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=850364314-17072003><FONT face=Arial color=#0000ff size=2>
I see nothing wrong with a bound hidden form opened from the Autoexe, but if you
want to do more work...</FONT></SPAN></DIV>
<DIV><SPAN class=850364314-17072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=850364314-17072003><FONT face=Arial color=#0000ff size=2>
Call a function from the autoexec. The function should open a reference to
the BE MDB using global variable.</FONT></SPAN></DIV>
<DIV> </DIV>
<P><FONT size=2>Jim Dettman<BR>President,<BR>Online Computer Services of WNY,
Inc.<BR>(315) 699-3443<BR>jimdettman@earthlink.net </FONT></P>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com]<B>On Behalf Of </B>Greg
S<BR><B>Sent:</B> Thursday, July 17, 2003 10:26 AM<BR><B>To:</B> Access
Developers discussion and problem solving<BR><B>Subject:</B> [AccessD]
Autoexec Code?<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>Hello Group!</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I know that part of my question has been
discussed before but I can't seem to find it (too shor a night I
think...). </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>1. I want to open a hidden form on startup
that opens to a table in the BE. The purpose is to keep the BE open
until the last user exits. This "should" speed up some of the timing
issues I've been having at a local client (large network, some fiber
connections, but some older switches and servers). It's a fully secured
app, so I can't directly open the table by the form...it has to be done thru a
query since none of the users have permissions on the tables.
</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>2. Related to that, I could just put the
code in the AUTOEXEC macro that opens the form hidden. But I HATE
macros. They're functional, but that doesn't make me like'em any
better. I have one form that opens via the startup dialog and put the
code in there that opens my hidden form. It works, but doesn't seem like
the best way to do it. </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>3. Is there some way to autoexecute a
MODULE or some of the code (other than the way I'm forcing it with the form
above in #2)? </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Btw, it's Access 97, soon to be changed over to
Access 2002, or .net, or xp or whatever they want to call it this
week...</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Thanks!</FONT></DIV>
<DIV><FONT face=Arial size=2>Greg Smith</FONT></DIV>
<DIV><FONT face=Arial size=2><A
href="mailto:Weeden1949@hotmail.com">Weeden1949@hotmail.com</A></FONT></DIV></BLOCKQUOTE></BODY></HTML>