<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1170" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=819135517-18072003><FONT face="Comic Sans MS" color=#0000ff
size=2>Folsom Prison Blues it correct. Take the A Train was a swing
number.</FONT></SPAN></DIV>
<DIV><SPAN class=819135517-18072003><FONT face="Comic Sans MS" color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=819135517-18072003><FONT face="Comic Sans MS" color=#0000ff
size=2>Charlotte Foust</FONT></SPAN></DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Don Elliker
[mailto:delliker@hotmail.com] <BR><B>Sent:</B> Friday, July 18, 2003 9:51
AM<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B> RE: Non-flame
war over singers - was RE: [AccessD] Autoexec Code?<BR><BR></FONT></DIV>
<DIV>
<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*. </BLOCKQUOTE></BODY></HTML>