When I Designed a form, I made one of the fields a default value of Date(). This works fine on my computer but I have multiple users and when they bring up the form on their PC the field shows up a ##Name. Can anyone explain why this is and any solution to this problem would be greatly appreciated.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Date() Function in Access 97
- Thread starter Ammodog
- Start date
This happens to me sometimes, including other functions (especially text-handling functions like "Trim" or "Left"
. I've only had it happen on the older databases that are not split. The functions always work on my computer, but not on a few others - although the identical functions will work on those computers in another database.
As nearly as I can tell, it's caused by the database being corrupted. This is a good reason to split your database into a front end / back end. Then you can keep a fresh copy of your front end available, and just copy it over as needed.
You can try to repair your database, but sometimes that doesn't work. I usually just create a new one and import all the objects into it - that will usually fix it.
If somebody else knows what's happening here and can help fix it, I'd love to know. I've ended up changing code so it doesn't rely on the offending function, but that's not very satisfactory.
. I've only had it happen on the older databases that are not split. The functions always work on my computer, but not on a few others - although the identical functions will work on those computers in another database.As nearly as I can tell, it's caused by the database being corrupted. This is a good reason to split your database into a front end / back end. Then you can keep a fresh copy of your front end available, and just copy it over as needed.
You can try to repair your database, but sometimes that doesn't work. I usually just create a new one and import all the objects into it - that will usually fix it.
If somebody else knows what's happening here and can help fix it, I'd love to know. I've ended up changing code so it doesn't rely on the offending function, but that's not very satisfactory.
Check the references on each PC to see if they are the same. You can check by opening the database, going to the Module tab on the database window, clicking on New, then selecting Tools->References... on the toolbar. Click any that are unchecked on the other PC(s).
- Status
Similar threads
- Locked
- Question
- Locked
- Question