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!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

#Name? on 1 Access 2000 computer; ok on another 1

Status
Not open for further replies.
autosol

autosol

Programmer
May 1, 2003
21
US
I have 2 computers running Access 2000; both Win XP. The Access programs on the development computer work fine. On the other computer, there are at least several places where the #Name? errors come up. I'll explain the simplest reference.

There is a control on a form, which is supposed to default to today's date. Placing =Date() in the default property or the control source property yields #Name? Access error on the user machine but works fine on the other computer. There are other fields, some on reports, some on forms that fail similiarly.

Any ideas? Thanks.
 
Sort by date Sort by votes
Just a wild guess: Are both computers using the same Regional Settings (in Control Panel) and the same date formats? Is it happening just for '=Date()'?
I know this might be a stupid question, but you didn't specify if you were using exactly the same database. Are you?
Cheers.
 
Upvote 0 Downvote
Hi

This is a known problem recorded on the microsoft web site, if you have (or have had) two versions of Office on same PC, and the 'old' object libraries (particularly I believe from Outlook). Check your references on the two machines (open any code module in design view, then choose Tools\references from the menu), note and compare the list of references, their order and versions/filenames)

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now - UK
 
Upvote 0 Downvote
Edski

Yes, they are identical databases. The Regional date formats are the same. But, no, it's not just with dates --there are other instances that do not involve dates.

Thanks for your help.

KenReay

I'll check those settings when I get back to the two affected macines but on the machine here at home, which has the same problem, I don't find any references in Access to Miscrosoft Office or Outlook.

I scoured the MS website before resorting to Tek-Tips. I'll go back but is there a specific reference you could provide?

Thanks for your help.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Xavierparkash
  • Locked
  • Question
MS Access Slow Search in Linked Database
Replies
0
Views
158
Xavierparkash
Xavierparkash
breezett93
  • Locked
  • Question
Function that find all controls on a form and puts their tab index in numerical order
Replies
19
Views
396
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Output To fails when name contains forward slash 1
Replies
7
Views
155
TrekBiker
TrekBiker
shenekas
  • Locked
  • Question
Required Field Based on Another Field in Access
Replies
2
Views
116
xweyer
xweyer
JanaLNelson
  • Locked
  • Question
Filter as you type combo box in Access 2
2 3
Replies
54
Views
771
JanaLNelson
JanaLNelson

Part and Inventory Search

Sponsor

Back
Top