<html><div style='background-color:'><DIV>
<P>Gary,</P>
<P>You have too much time on your hands, or you really have GOT to quit that CD club. </P>
<P>I was admiring the spelling of your last name, is it pronounced Chaos?<BR>_d<BR></P></DIV><BR><BR><BR>"Things are only free to the extent that you don't pay for them".-Don Elliker
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>>From: "Gary Kjos" <GARYKJOS@HOTMAIL.COM>
<DIV></DIV>>Reply-To: Access Developers discussion and problem solving<ACCESSD@DATABASEADVISORS.COM>
<DIV></DIV>>To: accessd@databaseadvisors.com
<DIV></DIV>>Subject: RE: [AccessD] Autoexec Code?
<DIV></DIV>>Date: Fri, 18 Jul 2003 08:34:39 -0500
<DIV></DIV>>
<DIV></DIV>>>>>that awful 70's song where some unknown female singer who had a
<DIV></DIV>>>>>really high screechy voice<<<
<DIV></DIV>>
<DIV></DIV>>I beleive that would be Minnie Riperton.
<DIV></DIV>>
<DIV></DIV>>http://www.minnieriperton.com/
<DIV></DIV>>
<DIV></DIV>>A truely irritating song.
<DIV></DIV>>
<DIV></DIV>>Gary Kjos
<DIV></DIV>>garykjos@hotmail.com
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>>From: "John Bartow" <JOHN@WINHAVEN.NET>
<DIV></DIV>>>Reply-To: Access Developers discussion and problem
<DIV></DIV>>>solving<ACCESSD@DATABASEADVISORS.COM>
<DIV></DIV>>>To: "Access Developers discussion and problem
<DIV></DIV>>>solving"<ACCESSD@DATABASEADVISORS.COM>
<DIV></DIV>>>Subject: RE: [AccessD] Autoexec Code?
<DIV></DIV>>>Date: Thu, 17 Jul 2003 20:02:26 -0500
<DIV></DIV>>>
<DIV></DIV>>>Well now, this certainly turned out to be a wimpy flame war! After
<DIV></DIV>>>that
<DIV></DIV>>>enticing jab at the beginning I thought I'd see blood!
<DIV></DIV>>>
<DIV></DIV>>>Not like Johnny Cash at all - more like that awful 70's song where
<DIV></DIV>>>some
<DIV></DIV>>>unknown female singer who had a really high screechy voice
<DIV></DIV>>>screeched out a
<DIV></DIV>>>love song and just about broke glass doing it. It went something
<DIV></DIV>>>like this:
<DIV></DIV>>>
<DIV></DIV>>>loving you,
<DIV></DIV>>>is easy cause you're beautiful,
<DIV></DIV>>>eieieieieieieieiei!
<DIV></DIV>>>
<DIV></DIV>>>(I can't even fit accessd lyrics into that bit)
<DIV></DIV>>>
<DIV></DIV>>>egad, JC's too busy with spam filtering, William's nowhere to be
<DIV></DIV>>>seen and
<DIV></DIV>>>Drew must be patching a dehumidifier into his network or something!
<DIV></DIV>>>:o)
<DIV></DIV>>>
<DIV></DIV>>> > -----Original Message-----
<DIV></DIV>>> > From: accessd-bounces@databaseadvisors.com
<DIV></DIV>>> > [mailto:accessd-bounces@databaseadvisors.com]On Behalf Of John
<DIV></DIV>>>Bartow
<DIV></DIV>>> > Sent: Thursday, July 17, 2003 11:38 AM
<DIV></DIV>>> > To: Access Developers discussion and problem solving
<DIV></DIV>>> > Subject: RE: [AccessD] Autoexec Code?
<DIV></DIV>>> >
<DIV></DIV>>> >
<DIV></DIV>>> > Oh-oh,
<DIV></DIV>>> >
<DIV></DIV>>> > (to the tune of Johnny Cash)
<DIV></DIV>>> >
<DIV></DIV>>> > I hear the flame a coming...
<DIV></DIV>>> > Its coming down the web,
<DIV></DIV>>> > I think I know who's typing,
<DIV></DIV>>> > just don't know when...
<DIV></DIV>>> >
<DIV></DIV>>> > I'm watching Access flames wars,
<DIV></DIV>>> > heating up again...
<DIV></DIV>>> >
<DIV></DIV>>> > :o)
<DIV></DIV>>> >
<DIV></DIV>>> > > -----Original Message-----
<DIV></DIV>>> > > From: accessd-bounces@databaseadvisors.com
<DIV></DIV>>> > > [mailto:accessd-bounces@databaseadvisors.com]On Behalf Of
<DIV></DIV>>>Heenan,
<DIV></DIV>>> > > Lambert
<DIV></DIV>>> > > Sent: Thursday, July 17, 2003 9:51 AM
<DIV></DIV>>> > > To: 'Access Developers discussion and problem solving'
<DIV></DIV>>> > > Subject: RE: [AccessD] Autoexec Code?
<DIV></DIV>>> > >
<DIV></DIV>>> > >
<DIV></DIV>>> > > What is your problem (and all the others out there who have
<DIV></DIV>>> > hang-ups about
<DIV></DIV>>> > > the "dreaded" macros)? <G>
<DIV></DIV>>> > >
<DIV></DIV>>> > > I use macros for two reasons only myself (to run stuff in
<DIV></DIV>>> > AutoExec and to
<DIV></DIV>>> > > disable/enable certain keystrokes in the AutoKeys macro), but
<DIV></DIV>>>I don't go
<DIV></DIV>>> > > around chastising myself for doing so. They do what I need and
<DIV></DIV>>> > as there is
<DIV></DIV>>> > > no need for error handling I don't miss that ability. I
<DIV></DIV>>>*don't*
<DIV></DIV>>> > use macros
<DIV></DIV>>> > > for anything else because I can do what I need in VBA with
<DIV></DIV>>>more control.
<DIV></DIV>>> > >
<DIV></DIV>>> > > You then say "I have one form that opens via the startup
<DIV></DIV>>>dialog
<DIV></DIV>>> > > and put the
<DIV></DIV>>> > > code in there that opens my hidden form. It works, but
<DIV></DIV>>>doesn't
<DIV></DIV>>> > seem like
<DIV></DIV>>> > > the best way to do it". What makes you think it's not "the
<DIV></DIV>>>best way"?
<DIV></DIV>>> > > Because you have the overhead of opening a form in order to
<DIV></DIV>>>open another
<DIV></DIV>>> > > form? If that's such a big issue (is it???) then put ONE
<DIV></DIV>>> > "RunCode" line in
<DIV></DIV>>> > > AutoExec to call a function in a module - that's the *ONLY*
<DIV></DIV>>>way
<DIV></DIV>>> > > that you can
<DIV></DIV>>> > > "autoexecute a MODULE".
<DIV></DIV>>> > >
<DIV></DIV>>> > > Please, don't stay religious about macros. You might just as
<DIV></DIV>>> > well say that
<DIV></DIV>>> > > using #define in C/C++ is bad because it's not real C/C++
<DIV></DIV>>> > code, but they
<DIV></DIV>>> > > are part of the C/C++ development environment, and everyone
<DIV></DIV>>>uses them.
<DIV></DIV>>> > > Occasionally you need to use macros in Access, but it's no sin
<DIV></DIV>>>to do so.
<DIV></DIV>>> > > <VBG>
<DIV></DIV>>> > >
<DIV></DIV>>> > > Lambert
<DIV></DIV>>> > >
<DIV></DIV>>> > > > -----Original Message-----
<DIV></DIV>>> > > > From: Greg S [SMTP:weeden1949@hotmail.com]
<DIV></DIV>>> > > > Sent: Thursday, July 17, 2003 10:26 AM
<DIV></DIV>>> > > > To: Access Developers discussion and problem solving
<DIV></DIV>>> > > > Subject: [AccessD] Autoexec Code?
<DIV></DIV>>> > > >
<DIV></DIV>>> > > > Hello Group!
<DIV></DIV>>> > > >
<DIV></DIV>>> > > > I know that part of my question has been discussed before
<DIV></DIV>>>but I
<DIV></DIV>>> > > can't seem
<DIV></DIV>>> > > > to find it (too shor a night I think...).
<DIV></DIV>>> > > >
<DIV></DIV>>> > > > 1. I want to open a hidden form on startup that opens to a
<DIV></DIV>>> > table in the
<DIV></DIV>>> > > > BE. The purpose is to keep the BE open until the last user
<DIV></DIV>>> > exits. This
<DIV></DIV>>> > > > "should" speed up some of the timing issues I've been having
<DIV></DIV>>> > at a local
<DIV></DIV>>> > > > client (large network, some fiber connections, but some
<DIV></DIV>>>older
<DIV></DIV>>> > > switches and
<DIV></DIV>>> > > > servers). It's a fully secured app, so I can't directly
<DIV></DIV>>>open
<DIV></DIV>>> > > the table by
<DIV></DIV>>> > > > the form...it has to be done thru a query since none of the
<DIV></DIV>>>users have
<DIV></DIV>>> > > > permissions on the tables.
<DIV></DIV>>> > > >
<DIV></DIV>>> > > > 2. Related to that, I could just put the code in the
<DIV></DIV>>>AUTOEXEC
<DIV></DIV>>> > > macro that
<DIV></DIV>>> > > > opens the form hidden. But I HATE macros. They're
<DIV></DIV>>> > functional, but that
<DIV></DIV>>> > > > doesn't make me like'em any better. I have one form that
<DIV></DIV>>> > opens via the
<DIV></DIV>>> > > > startup dialog and put the code in there that opens my
<DIV></DIV>>>hidden
<DIV></DIV>>> > form. It
<DIV></DIV>>> > > > works, but doesn't seem like the best way to do it.
<DIV></DIV>>> > > >
<DIV></DIV>>> > > > 3. Is there some way to autoexecute a MODULE or some of the
<DIV></DIV>>> > code (other
<DIV></DIV>>> > > > than the way I'm forcing it with the form above in #2)?
<DIV></DIV>>> > > >
<DIV></DIV>>> > > > Btw, it's Access 97, soon to be changed over to Access 2002,
<DIV></DIV>>> > or .net, or
<DIV></DIV>>> > > > xp or whatever they want to call it this week...
<DIV></DIV>>> > > >
<DIV></DIV>>> > > > Thanks!
<DIV></DIV>>> > > > Greg Smith
<DIV></DIV>>> > > > Weeden1949@hotmail.com <mailto:Weeden1949@hotmail.com><<
<DIV></DIV>>>File:
<DIV></DIV>>> > > > ATT10294127.txt >>
<DIV></DIV>>> > > _______________________________________________
<DIV></DIV>>> > > AccessD mailing list
<DIV></DIV>>> > > AccessD@databaseadvisors.com
<DIV></DIV>>> > > http://databaseadvisors.com/mailman/listinfo/accessd
<DIV></DIV>>> > > Website: http://www.databaseadvisors.com
<DIV></DIV>>> > >
<DIV></DIV>>> > >
<DIV></DIV>>> >
<DIV></DIV>>> >
<DIV></DIV>>> > _______________________________________________
<DIV></DIV>>> > AccessD mailing list
<DIV></DIV>>> > AccessD@databaseadvisors.com
<DIV></DIV>>> > http://databaseadvisors.com/mailman/listinfo/accessd
<DIV></DIV>>> > Website: http://www.databaseadvisors.com
<DIV></DIV>>> >
<DIV></DIV>>> >
<DIV></DIV>>>
<DIV></DIV>>>
<DIV></DIV>>>_______________________________________________
<DIV></DIV>>>AccessD mailing list
<DIV></DIV>>>AccessD@databaseadvisors.com
<DIV></DIV>>>http://databaseadvisors.com/mailman/listinfo/accessd
<DIV></DIV>>>Website: http://www.databaseadvisors.com
<DIV></DIV>>
<DIV></DIV>>_________________________________________________________________
<DIV></DIV>>The new MSN 8: smart spam protection and 2 months FREE*
<DIV></DIV>>http://join.msn.com/?page=features/junkmail
<DIV></DIV>>
<DIV></DIV>>_______________________________________________
<DIV></DIV>>AccessD mailing list
<DIV></DIV>>AccessD@databaseadvisors.com
<DIV></DIV>>http://databaseadvisors.com/mailman/listinfo/accessd
<DIV></DIV>>Website: http://www.databaseadvisors.com
<DIV></DIV></mailto:Weeden1949@hotmail.com></div><br clear=all><hr>Protect your PC - <a href="http://g.msn.com/8HMVENUS/2755??PS=">Click here</a> for McAfee.com VirusScan Online </html>