<!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><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></BODY></HTML>