[AccessD] Autoexec Code?

Jim Dettman jimdettman at earthlink.net
Thu Jul 17 09:45:16 CDT 2003


Greg,

  I see nothing wrong with a bound hidden form opened from the Autoexe, but
if you want to do more work...

  Call a function from the autoexec.  The function should open a reference
to the BE MDB using global variable.

Jim Dettman
President,
Online Computer Services of WNY, Inc.
(315) 699-3443
jimdettman at earthlink.net

  -----Original Message-----
  From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Greg S
  Sent: Thursday, July 17, 2003 10:26 AM
  To: Access Developers discussion and problem solving
  Subject: [AccessD] Autoexec Code?


  Hello Group!

  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...).

  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.

  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.

  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)?

  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...

  Thanks!
  Greg Smith
  Weeden1949 at hotmail.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030717/dc580af8/attachment-0001.html>


More information about the AccessD mailing list