SBS 2007 Error?

[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.

 

[Tom van Stiphout]

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

 

[Maurice]

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