<html><div style='background-color:'><DIV>
<P>I think it's actually "Folsom Prison Blues" - but I have been wrong before.</P>
<P>_D<BR><BR>"Things are only free to the extent that you don't pay for them".-Don Elliker </P></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>>From: "Heenan, Lambert" <LAMBERT.HEENAN@AIG.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: Non-flame war over singers - was RE: [AccessD] Autoexec Code?
<DIV></DIV>>Date: Fri, 18 Jul 2003 09:55:13 -0400
<DIV></DIV>>
<DIV></DIV>>Actually I believe it was "Ride This Train". It was Duke Ellington who first
<DIV></DIV>>recorded "Take the A Train", written by Billy Strayhorn in 1941.
<DIV></DIV>>
<DIV></DIV>>Lambert
<DIV></DIV>>
<DIV></DIV>> > -----Original Message-----
<DIV></DIV>> > From: Wortz, Charles [SMTP:CWortz@tea.state.tx.us]
<DIV></DIV>> > Sent: Friday, July 18, 2003 9:47 AM
<DIV></DIV>> > To: Access Developers discussion and problem solving
<DIV></DIV>> > Subject: OT: Non-flame war over singers - was RE: [AccessD] Autoexec
<DIV></DIV>> > Code?
<DIV></DIV>> >
<DIV></DIV>> > However, John B was referring to Johnny Cash's "The A Train."
<DIV></DIV>> >
<DIV></DIV>> > Charles Wortz
<DIV></DIV>> > Software Development Division
<DIV></DIV>> > Texas Education Agency
<DIV></DIV>> > 1701 N. Congress Ave
<DIV></DIV>> > Austin, TX 78701-1494
<DIV></DIV>> > 512-463-9493
<DIV></DIV>> > CWortz@tea.state.tx.us
<DIV></DIV>> >
<DIV></DIV>> >
<DIV></DIV>> >
<DIV></DIV>> > -----Original Message-----
<DIV></DIV>> > From: Gary Kjos [mailto:garykjos@hotmail.com]
<DIV></DIV>> > Sent: Friday 2003 Jul 18 08:35
<DIV></DIV>> > To: accessd@databaseadvisors.com
<DIV></DIV>> > Subject: RE: [AccessD] Autoexec Code?
<DIV></DIV>> > Importance: Low
<DIV></DIV>> >
<DIV></DIV>> >
<DIV></DIV>> > >>>that awful 70's song where some unknown female singer who had a
<DIV></DIV>> > >>>really
<DIV></DIV>> > >>>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 that
<DIV></DIV>> >
<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>> >
<DIV></DIV>> > >unknown female singer who had a really high screechy voice screeched
<DIV></DIV>> > >out a 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 seen
<DIV></DIV>> > >and 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 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
<DIV></DIV>> > > > > don't
<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 code in there that opens my hidden form. It works,
<DIV></DIV>> > > > > but doesn't
<DIV></DIV>> > > > seem like
<DIV></DIV>> > > > > the best way to do it". What makes you think it's not "the best
<DIV></DIV>> > > > > way"? Because you have the overhead of opening a form in order to
<DIV></DIV>> > > > > 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 "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. Occasionally you need to use macros in Access, but it's no
<DIV></DIV>> > > > > 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
<DIV></DIV>> > > > > > 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>> > 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>> > _______________________________________________
<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>>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>MSN 8 helps <a href="http://g.msn.com/8HMVENUS/2743??PS=">ELIMINATE E-MAIL VIRUSES. </a> Get 2 months FREE*.</html>