SBS 2007 Error?

  • Thread starter Thread starter Toller
  • Start date Start date
T

Toller

I'm working my way through Access 2007 Step by Step. I've come to Chapter 5
which is on forms and am stuck on the exercise known as 05_VBA.

I've followed the instructions three times with the same result....nada.
It's supposed to create a block of code that is executed after the user
updates a particular field. In this case, nothing happens.

Has this problem been reported or am I just dense?

Thanks.
 
On Wed, 14 Apr 2010 14:34:01 -0700, Toller

Not everyone has this book. When you say "after the user updates a
particular field" I'm thinking to write some code in the AfterUpdate
event of that control. Start with:
Msgbox "Hello Toller"
Then run the app, update the control, and do you see the messagebox?
If not, make sure your file is in a "Trusted Location" (see help file)

-Tom.
Microsoft Access MVP
 
Toller,

Your macro settings should be disabled and as Tom stated you should set your
location where the database resides to trusted.
When correctly done the following should happen

Enter a first name and a last name. When the last name is entered an ID
constisting of 5 letters will be automatically created for you.

Trusted location:

1. Office button
2. Access options
3. Trust center
4. Trustecenter settings (right side)
5. Trsuted location
6. Add (bottom of screen) - browse to the location where the database resides.

hth
 
Back
Top