<html><div style='background-color:'><DIV>
<P>I think we should name this Email Minnie Ripperton's Revenge - <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: PBudge@cbsol.com
<DIV></DIV>>Reply-To: Access Developers discussion and problem solving<ACCESSD@DATABASEADVISORS.COM>
<DIV></DIV>>To: Access Developers discussion and problem solving<ACCESSD@DATABASEADVISORS.COM>
<DIV></DIV>>Subject: RE: [AccessD] Autoexec Code?
<DIV></DIV>>Date: Fri, 18 Jul 2003 11:50:05 -0500
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>Ok JC, I'm up to ten copies of this now. . . I'm starting to feel like
<DIV></DIV>>we're caught in some Star Trek time loop. . .maybe it's just a Friday
<DIV></DIV>>thing. . . ;-)
<DIV></DIV>>
<DIV></DIV>>Pamela G. Budge
<DIV></DIV>>PBudge@cbsol.com
<DIV></DIV>>Creative Business Solutions
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>> "Mark A Matte"
<DIV></DIV>> <MARKAMATTE@HOTMAIL.COM>To: accessd@databaseadvisors.com
<DIV></DIV>> Sent by: cc:
<DIV></DIV>> accessd-bounces@databasea Subject: RE: [AccessD] Autoexec Code?
<DIV></DIV>> dvisors.com
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>> 07/18/2003 10:10 AM
<DIV></DIV>> Please respond to Access
<DIV></DIV>> Developers discussion and
<DIV></DIV>> problem solving
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>You know...if we could somehow bring bound/unbound into this
<DIV></DIV>>discussion...we
<DIV></DIV>>might be able to get fireworks instead of just flames...lol
<DIV></DIV>>
<DIV></DIV>>Mark
<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 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 some
<DIV></DIV>> >unknown female singer who had a really high screechy voice screeched out a
<DIV></DIV>> >love song and just about broke glass doing it. It went something like
<DIV></DIV>>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 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 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 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 I don't
<DIV></DIV>>
<DIV></DIV>> >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 *don't*
<DIV></DIV>> > > use macros
<DIV></DIV>> > > > for anything else because I can do what I need in VBA with more
<DIV></DIV>> >control.
<DIV></DIV>> > > >
<DIV></DIV>> > > > You then say "I have one form that opens via the startup dialog
<DIV></DIV>> > > > and put the
<DIV></DIV>> > > > code in there that opens my hidden form. It works, but doesn't
<DIV></DIV>> > > seem like
<DIV></DIV>> > > > the best way to do it". What makes you think it's not "the best way"?
<DIV></DIV>> > > > Because you have the overhead of opening a form in order to open
<DIV></DIV>> >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* 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 uses
<DIV></DIV>>them.
<DIV></DIV>> > > > Occasionally you need to use macros in Access, but it's no sin to do
<DIV></DIV>> >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 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 older
<DIV></DIV>> > > > switches and
<DIV></DIV>> > > > > servers). It's a fully secured app, so I can't directly open
<DIV></DIV>> > > > the table by
<DIV></DIV>> > > > > the form...it has to be done thru a query since none of the users
<DIV></DIV>> >have
<DIV></DIV>> > > > > permissions on the tables.
<DIV></DIV>> > > > >
<DIV></DIV>> > > > > 2. Related to that, I could just put the code in the 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 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><< 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>>Protect your PC - get McAfee.com VirusScan Online
<DIV></DIV>>http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
<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>>_______________________________________________
<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>Add photos to your e-mail with <a href="http://g.msn.com/8HMEENUS/2746??PS=">MSN 8.</a> Get 2 months FREE*.</html>