[AccessD] OT Autoexec Code?

PBudge at cbsol.com PBudge at cbsol.com
Fri Jul 18 15:22:24 CDT 2003


Maybe he's just playing games with your head because I've got three posts
from you today, including the day's ONLY joke!


Pamela G. Budge
PBudge at cbsol.com
Creative Business Solutions


                                                                                                                                               
                      "Don Elliker"                                                                                                            
                      <delliker at hotmail.com>           To:       accessd at databaseadvisors.com                                                  
                      Sent by:                         cc:                                                                                     
                      accessd-bounces at databasea        Subject:  RE: [AccessD] OT Autoexec Code?                                               
                      dvisors.com                                                                                                              
                                                                                                                                               
                                                                                                                                               
                      07/18/2003 02:58 PM                                                                                                      
                      Please respond to Access                                                                                                 
                      Developers discussion and                                                                                                
                      problem solving                                                                                                          
                                                                                                                                               
                                                                                                                                               




Veryyyyy cryptic indeed....none of my posts has made it today (7/18) Has
Colby relegated me to the spam paradise???
_d





"Things are only free to the extent that you don't pay for them".-Don
Elliker
>From: PBudge at cbsol.com
>Reply-To: Access Developers discussion and problem solving
>To: Access Developers discussion and problem solving
>Subject: RE: [AccessD] OT Autoexec Code?
>Date: Fri, 18 Jul 2003 10:29:03 -0500
>
>
>Make that seven!
>
>Pamela G. Budge
>PBudge at cbsol.com
>Creative Business Solutions
>
>
>
> "Mark A Matte"
> To: accessd at databaseadvisors.com
> Sent by: cc:
> accessd-bounces at databasea Subject: RE: [AccessD] Autoexec Code?
> dvisors.com
>
>
> 07/18/2003 10:11 AM
> Please respond to Access
> Developers discussion and
> problem solving
>
>
>
>
>
>
>You know...if we could somehow bring bound/unbound into this
>discussion...we
>might be able to get fireworks instead of just flames...lol
>
>Mark
>
>
> >From: "John Bartow"
> >Reply-To: Access Developers discussion and problem
> >solving
> >To: "Access Developers discussion and problem
> >solving"
> >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)?
> > > >
> > > > 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.
> > > >
> > > >
> > > > 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 << File:
> > > > > ATT10294127.txt >>
> > > > _______________________________________________
> > > > AccessD mailing list
> > > > AccessD at databaseadvisors.com
> > > > http://databaseadvisors.com/mailman/listinfo/accessd
> > > > Website: http://www.databaseadvisors.com
> > > >
> > > >
> > >
> > >
> > > _______________________________________________
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > http://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> > >
> > >
> >
> >
> >_______________________________________________
> >AccessD mailing list
> >AccessD at databaseadvisors.com
> >http://databaseadvisors.com/mailman/listinfo/accessd
> >Website: http://www.databaseadvisors.com
>
>_________________________________________________________________
>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
>
>
>
>
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

Add photos to your e-mail with MSN 8. Get 2 months FREE*.
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com







More information about the AccessD mailing list