> Maybe this is going overboard, but it has become habit eveytime I
> add/change
> code, File>save; Debug>compile.
I also do the above....
(I uise the keyboard..and I do this so often, that it is insticnvle now..and
I don't even remember doing this).
The keystrocks I use are
ctrl-s save
alt-d, Enter key (note when you hit alt-d, the debug menu
drops down...and then you whack the enter key.
SNAP, BING, bang!.....I hit the above 3 keystockes one after antoher
ctrl-s, alt-d, whack enter key.
I then often hit alt-f4 to close the wdinow
So, yes, often we devleopers will do a compile after every change. Certanly,
as I done making changes to the code module, I will hiet ctrl-s. This ensure
my code is saved...even if the appcaton where to freezee, or crash...
> And when I am finished working on the db for the day, Tools>Database
> Utilities>Compact and Repair Database.
Yes, again, the above makes sense...and often, this will occur more then
once during the day....
> QUESTION: Is this necessary? Today I notice in MSaccess
> Tools>Options>General there is "Compact on close".Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14056
I don't mind the above....but, often hwen I am in a hurry, or have to close
the appciaton and leave, I don't want it to compact. I think this opten is
better for END USERS that dont' even know to do this. As a intelient
expaonced dvelpoer that you are, then you have your own sense as to when to
do this..
> Also in VBeditor
> Tools>Options>General tab is Compile choices. Are these things happening
> without me manually doing them?
Well, the compile on demand is ok, but it only occurs when you run the code.
Would you not want to find/see syntax errors WHILE you are right there in
the code editor?
Of course, during development, you will hold down the shift key so your
startup settings don't run. You then develop for awhile, and then to test in
"user" mode, you exit..and then re-enter the application without the shift
key bypassed. You will likely do this dance all day long as you run/test as
user mode, and then flip back in to developer mode (shift key used..so you
don't get the main custom menu). So, you can't develop, or really modify
things when you run your application with the startup settings...so you must
shift-by-pass them when you want to work.
And, in fact, I use alt-f4 to exit the application...the mdb file should
still be highlighted in the windows explore..so, then you hit enter key
(and, hold down shift key if you need be). This key stroke sequence and
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14056
exiting and re-entering the application will occur CONSTANTLY all day long
when you are developing.
When you finally have things just right...you create the mde
you plan to distribute...
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com http://www.members.shaw.ca/AlbertKallal