Very general question - trying to update skills from A97-2003

  • Thread starter Thread starter JG23
  • Start date Start date
J

JG23

The last time I programmed in Access, I was working on
Access 97. Now I'm trying to pick things back up in
Access 2003, and I'm missing several things I was used
to. The biggest one was the ability to record procedures.
Ok, so it was kind of cheating, but I was used to having
Access lay the ground code, and then I could edit it. Is
that function available at all in 2003? I've forgotten a
little too much to start writing code from scratch, but
from what I can tell, that's what you have to do now.

The other thing I miss is the "?" command. When playing
with variables, I could insert:

? variablename

and a small window would pop up with the current value of
variablename. That doesn't work anymore either.

Talk about feeling obsolete... That's what I get for
taking 5 years off for my kids...

All help would be appreciated! TIA!
 
Hi.
Ok, so it was kind of cheating, but I was used to having
Access lay the ground code, and then I could edit it. Is
that function available at all in 2003?
Click to expand...

Use the Wizards to create forms, reports, and controls on these objects.
Follow through all of the dialog windows of the Wizards, and Access will
produce the code for you automatically in the code module. You'll recognize
the code from these Wizards, because they still use VBA 4.0 from Access 95.
The other thing I miss is the "?" command. When playing
with variables, I could insert:

? variablename

and a small window would pop up with the current value of
variablename.
Click to expand...

While the code is stopped at a breakpoint, press <CTRL><G> to open the
Immediate window and type:

? variableName

.. . . in the Immediate window, then press <ENTER> to see the current value.
Alternatively, you could open the Immediate window by selecting the View
menu -> Immediate Window.
Talk about feeling obsolete... That's what I get for
taking 5 years off for my kids...
Click to expand...

Don't worry, most of the bugs you pulled your hair out while you tried to
workaround them in Access 97 are still hanging around in the more recent
versions, as well as a few more from Jet 4.0!

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
I don't think there was any version of Access that allows "recording Macros"
like Excel or Word.

You may be thinking of using Wizard to create certain codes and there are
more Wizards available than in A97.

The major difference is in A2003, code writing / debugging is done in a
separate window called Visual Basic (integrated development) Environment or
VBE for short. In the "MDI" window, you have the Code window and the
Immediate/Debug window like the separate windows in the A97 MDI. There are
other windows in the VBE such as the Project Explorer, Watch window, etc...
The Immediate/Debug window is where you use the question mark (shorthand
notation for Print.

HTH
Van T. Dinh
MVP (Access)
 
Back
Top