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 |
#11
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|