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 » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Validation rule problem



 
 
Thread Tools Display Modes
  #11  
Old August 6th, 2009, 12:58 AM posted to microsoft.public.access.gettingstarted
KenSheridan via AccessMonster.com
external usenet poster
 
Posts: 1,610
Default Validation rule problem

Cathleen:

Sounds like there's a problem either with the file on your system at work, or
with the Access installation at your office.

I don't use Access 2007 myself, but I imagine that it has a facility for
converting a file to an earlier format. Try creating a new copy of your home
file in 2003 format and see if that works on your system at work. You'll
presumably need to convert your office copy up to 2007 first and then back
down again to 2003. If it still doesn’t work at the office then try creating
a new database at work with the simple form and 'OK' message. If you have
problems with that it looks like the Access installation has problem, and a
fresh install of Access may be needed. If not then try creating a new empty
file at work and importing all the objects from your current file.

Ken Sheridan
Stafford, England

Cathleen wrote:
Ken,
Thanks for all of your assistance. I discovered a bit of new information
when I tried to implement the steps you recommended. I am now working on my
home computer, using Access 2007 and the code runs perfectly (same form and
database as earlier).

So, from this I'll infer that the code is just fine. So, I'll need to get
this running on my work computer in Access 2003 - do you still recommend
trying the new form, new database steps you outlined below? Or, is there some
other type of problem that could be occurring?

Thank you again,
Cathleen

To check for a missing or broken reference open the VBA window at any code
and select Tools | References on the VBA menu bar. See if any are marked as

[quoted text clipped - 20 lines]
Ken Sheridan
Stafford, England


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...arted/200908/1

  #12  
Old August 6th, 2009, 06:47 PM posted to microsoft.public.access.gettingstarted
Cathleen
external usenet poster
 
Posts: 15
Default Validation rule problem

I finally got everything working perfectly after importing all of my objects
into a new database in Access 2003. Thanks again for all of your help with
the code for validation and the ensuing problems.

Cathleen

"KenSheridan via AccessMonster.com" wrote:

Cathleen:

Sounds like there's a problem either with the file on your system at work, or
with the Access installation at your office.

I don't use Access 2007 myself, but I imagine that it has a facility for
converting a file to an earlier format. Try creating a new copy of your home
file in 2003 format and see if that works on your system at work. You'll
presumably need to convert your office copy up to 2007 first and then back
down again to 2003. If it still doesn’t work at the office then try creating
a new database at work with the simple form and 'OK' message. If you have
problems with that it looks like the Access installation has problem, and a
fresh install of Access may be needed. If not then try creating a new empty
file at work and importing all the objects from your current file.

Ken Sheridan
Stafford, England

Cathleen wrote:
Ken,
Thanks for all of your assistance. I discovered a bit of new information
when I tried to implement the steps you recommended. I am now working on my
home computer, using Access 2007 and the code runs perfectly (same form and
database as earlier).

So, from this I'll infer that the code is just fine. So, I'll need to get
this running on my work computer in Access 2003 - do you still recommend
trying the new form, new database steps you outlined below? Or, is there some
other type of problem that could be occurring?

Thank you again,
Cathleen

To check for a missing or broken reference open the VBA window at any code
and select Tools | References on the VBA menu bar. See if any are marked as

[quoted text clipped - 20 lines]
Ken Sheridan
Stafford, England


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...arted/200908/1


 




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 11:42 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.