John Bartow
john at winhaven.net
Sat Jul 19 00:46:24 CDT 2003
Ding, ding, ding... That's the one that popped into my mind. > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Gary Kjos > Sent: Friday, July 18, 2003 12:52 PM > To: accessd at databaseadvisors.com > Subject: RE: Non-flame war over singers - was RE: [AccessD] Autoexec > Code? > > > Are you sure it's not "Folsom Prison Blues"? > > ------------------- > > FOLSOM PRISON BLUES > (J.R. Cash) > JOHNNY CASH (Sun 232, 1956) > > I hear that train a-commin', it's rollin' around the bend > And I ain't seen the sunshine since I don't know when > I'm stuck in Folsom prison and time keeps draggin' on > But that train keeps a-rollin' on down to San Antone > When I was just a baby, my mama told me, son > Always be a good boy, don't ever play with guns > But I shot a man in Reno, just to watch him die > When I hear that whistle blowin', I hang my head and cry > > ----------------------- > > > > Gary Kjos > garykjos at hotmail.com > > >From: "Heenan, Lambert" <Lambert.Heenan at AIG.com> > >Reply-To: Access Developers discussion and problem > >solving<accessd at databaseadvisors.com> > >To: "'Access Developers discussion and problem solving'" > ><accessd at databaseadvisors.com> > >Subject: RE: Non-flame war over singers - was RE: [AccessD] > Autoexec Code? > >Date: Fri, 18 Jul 2003 09:55:13 -0400 > > > >Actually I believe it was "Ride This Train". It was Duke Ellington who > >first > >recorded "Take the A Train", written by Billy Strayhorn in 1941. > > > >Lambert > > > > > -----Original Message----- > > > From: Wortz, Charles [SMTP:CWortz at tea.state.tx.us] > > > Sent: Friday, July 18, 2003 9:47 AM > > > To: Access Developers discussion and problem solving > > > Subject: OT: Non-flame war over singers - was RE: [AccessD] Autoexec > > > Code? > > > > > > However, John B was referring to Johnny Cash's "The A Train." > > > > > > Charles Wortz > > > Software Development Division > > > Texas Education Agency > > > 1701 N. Congress Ave > > > Austin, TX 78701-1494 > > > 512-463-9493 > > > CWortz at tea.state.tx.us > > > > > > > > > > > > -----Original Message----- > > > From: Gary Kjos [mailto:garykjos at hotmail.com] > > > Sent: Friday 2003 Jul 18 08:35 > > > To: accessd at databaseadvisors.com > > > Subject: RE: [AccessD] Autoexec Code? > > > Importance: Low > > > > > > > > > >>>that awful 70's song where some unknown female singer who had a > > > >>>really > > > >>>high screechy voice<<< > > > > > > I beleive that would be Minnie Riperton. > > > > > > http://www.minnieriperton.com/ > > > > > > A truely irritating song. > > > > > > Gary Kjos > > > garykjos at hotmail.com > > > > > > > > > > > > > > > > > > >From: "John Bartow" <john at winhaven.net> > > > >Reply-To: Access Developers discussion and problem > > > >solving<accessd at databaseadvisors.com> > > > >To: "Access Developers discussion and problem > > > >solving"<accessd at databaseadvisors.com> > > > >Subject: RE: [AccessD] Autoexec Code? > > > >Date: Thu, 17 Jul 2003 20:02:26 -0500 > > > > > > > >Well now, this certainly turned out to be a wimpy flame war! > After that > > > > > > >enticing jab at the beginning I thought I'd see blood! > > > > > > > >Not like Johnny Cash at all - more like that awful 70's song > where some > > > > > > >unknown female singer who had a really high screechy voice screeched > > > >out a love song and just about broke glass doing it. It went > something > > > >like this: > > > > > > > >loving you, > > > >is easy cause you're beautiful, > > > >eieieieieieieieiei! > > > > > > > >(I can't even fit accessd lyrics into that bit) > > > > > > > >egad, JC's too busy with spam filtering, William's nowhere to be seen > > > >and Drew must be patching a dehumidifier into his network or > something! > > > >:o) > > > > > > > > > -----Original Message----- > > > > > From: accessd-bounces at databaseadvisors.com > > > > > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of John > > > > > Bartow > > > > > Sent: Thursday, July 17, 2003 11:38 AM > > > > > To: Access Developers discussion and problem solving > > > > > Subject: RE: [AccessD] Autoexec Code? > > > > > > > > > > > > > > > Oh-oh, > > > > > > > > > > (to the tune of Johnny Cash) > > > > > > > > > > I hear the flame a coming... > > > > > Its coming down the web, > > > > > I think I know who's typing, > > > > > just don't know when... > > > > > > > > > > I'm watching Access flames wars, > > > > > heating up again... > > > > > > > > > > :o) > > > > > > > > > > > -----Original Message----- > > > > > > From: accessd-bounces at databaseadvisors.com > > > > > > [mailto:accessd-bounces at databaseadvisors.com]On Behalf > Of Heenan, > > > > > > Lambert > > > > > > Sent: Thursday, July 17, 2003 9:51 AM > > > > > > To: 'Access Developers discussion and problem solving' > > > > > > Subject: RE: [AccessD] Autoexec Code? > > > > > > > > > > > > > > > > > > What is your problem (and all the others out there who have > > > > > hang-ups about > > > > > > the "dreaded" macros)? <g> > > > > > > > > > > > > I use macros for two reasons only myself (to run stuff in > > > > > AutoExec and to > > > > > > disable/enable certain keystrokes in the AutoKeys macro), but I > > > > > > don't > > > >go > > > > > > around chastising myself for doing so. They do what I need and > > > > > as there is > > > > > > no need for error handling I don't miss that ability. I *don't* > > > > > use macros > > > > > > for anything else because I can do what I need in VBA with more > > > >control. > > > > > > > > > > > > You then say "I have one form that opens via the startup dialog > > > > > > and put the code in there that opens my hidden form. It works, > > > > > > but doesn't > > > > > seem like > > > > > > the best way to do it". What makes you think it's not "the best > > > > > > way"? Because you have the overhead of opening a form > in order to > > > > > > open > > > >another > > > > > > form? If that's such a big issue (is it???) then put ONE > > > > > "RunCode" line in > > > > > > AutoExec to call a function in a module - that's the *ONLY* way > > > > > > that you can "autoexecute a MODULE". > > > > > > > > > > > > Please, don't stay religious about macros. You might just as > > > > > well say that > > > > > > using #define in C/C++ is bad because it's not real C/C++ > > > > > code, but they > > > > > > are part of the C/C++ development environment, and everyone uses > > > > > > them. Occasionally you need to use macros in Access, but it's no > > > > > > sin to do > > > >so. > > > > > > <vbg> > > > > > > > > > > > > Lambert > > > > > > > > > > > > > -----Original Message----- > > > > > > > From: Greg S [SMTP:weeden1949 at hotmail.com] > > > > > > > Sent: Thursday, July 17, 2003 10:26 AM > > > > > > > To: Access Developers discussion and problem solving > > > > > > > Subject: [AccessD] Autoexec Code? > > > > > > > > > > > > > > Hello Group! > > > > > > > > > > > > > > I know that part of my question has been discussed > before but I > > > > > > can't seem > > > > > > > to find it (too shor a night I think...). > > > > > > > > > > > > > > 1. I want to open a hidden form on startup that opens to a > > > > > table in the > > > > > > > BE. The purpose is to keep the BE open until the last user > > > > > exits. This > > > > > > > "should" speed up some of the timing issues I've been having > > > > > at a local > > > > > > > client (large network, some fiber connections, but some older > > > > > > switches and > > > > > > > servers). It's a fully secured app, so I can't directly open > > > > > > the table by > > > > > > > the form...it has to be done thru a query since none of the > > > > > > > users > > > >have > > > > > > > permissions on the tables. > > > > > > > > > > > > > > 2. Related to that, I could just put the code in the AUTOEXEC > > > > > > macro that > > > > > > > opens the form hidden. But I HATE macros. They're > > > > > functional, but that > > > > > > > doesn't make me like'em any better. I have one form that > > > > > opens via the > > > > > > > startup dialog and put the code in there that opens my hidden > > > > > form. It > > > > > > > works, but doesn't seem like the best way to do it. > > > > > > > > > > > > > > 3. Is there some way to autoexecute a MODULE or some of the > > > > > code (other > > > > > > > than the way I'm forcing it with the form above in #2)? > > > > > > > > > > > > > > Btw, it's Access 97, soon to be changed over to Access 2002, > > > > > or .net, or > > > > > > > xp or whatever they want to call it this week... > > > > > > > > > > > > > > Thanks! > > > > > > > Greg Smith > > > > > > > Weeden1949 at hotmail.com > <mailto:Weeden1949 at hotmail.com> << File: > > > > > > > ATT10294127.txt >> > > _________________________________________________________________ > Tired of spam? Get advanced junk mail protection with MSN 8. > http://join.msn.com/?page=features/junkmail > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > >