If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
SBS 2007 Error?
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. |
#2
|
|||
|
|||
SBS 2007 Error?
On Wed, 14 Apr 2010 14:34:01 -0700, Toller
wrote: 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 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. |
#3
|
|||
|
|||
SBS 2007 Error?
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 -- Maurice Ausum "Toller" wrote: 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. |
Thread Tools | |
Display Modes | |
|
|