<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<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=734593905-19072003><FONT face=Arial color=#0000ff
size=2>LOL!</FONT></SPAN></DIV>
<DIV><SPAN class=734593905-19072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=734593905-19072003><FONT face=Arial color=#0000ff size=2>I can
not believe anyone would remember her name, the song on the other had was truly
memorable - in the same sense as a gruesome car crash when you're the first one
to arrive at it...</FONT></SPAN></DIV>
<DIV><SPAN class=734593905-19072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=734593905-19072003><FONT face=Arial color=#0000ff size=2>I know
its been said before but I just have to restate it: this list is unbelievable in
the wide array of knowledge available from its members!</FONT></SPAN></DIV>
<DIV><SPAN class=734593905-19072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=734593905-19072003><FONT face=Arial color=#0000ff
size=2>:o)</FONT></SPAN></DIV>
<BLOCKQUOTE
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com]<B>On Behalf Of </B>Don
Elliker<BR><B>Sent:</B> Friday, July 18, 2003 1:24 PM<BR><B>To:</B>
accessd@databaseadvisors.com<BR><B>Subject:</B> RE: [AccessD] Autoexec
Code?<BR><BR></FONT></DIV>
<DIV>
<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 </BLOCKQUOTE></BODY></HTML>