Error- Method 'Value' of object 'Field' Failed
Posted on 2006-10-23
Hi all you experts--
Here is some background--
Backend: SQL Server 2000
Front: Access 2003 ADP file
Problem: I have 10-15 people using this same database. I put the same database on a new computer for a new user and when trying to do a simple thing that works FINE on every other computer, I get the error: Method 'Value' of object 'Field' Failed...
narrowed down to: In looking deeper, I noticed that there are some controls in which I have a default value. One is the current date, which works fine on every other machine, but not this one-- and the other is a reference to a label control caption property on another form. Again, it works perfectly fine on another machine, logged in as the same person, but for some reason it's not working on this computer.
Additional background, is that the version of Access 2003 loaded on this machine has not been "verified" by Microsoft-- you know, the pop-up that comes up the first time you use Access on a machine and asks if you want to register via the Internet. Well, I tried doing that, but the number of copies for the key of the version installed was exceeded. So, I haven't been able to get it registered with Microsoft yet. The IT guy tells me they are going to uninstall and reinstall a copy that can be verified and registered, but do you think it has something to do with that?
Let me know-- 500 pts for urgency. THanks!