A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

SBS 2007 Error?



 
 
Thread Tools Display Modes
  #1  
Old April 14th, 2010, 10:34 PM posted to microsoft.public.access.forms
Toller[_2_]
external usenet poster
 
Posts: 5
Default 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  
Old April 15th, 2010, 01:34 AM posted to microsoft.public.access.forms
Tom van Stiphout[_2_]
external usenet poster
 
Posts: 1,653
Default 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  
Old April 15th, 2010, 09:01 PM posted to microsoft.public.access.forms
Maurice
external usenet poster
 
Posts: 1,585
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:31 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.