Improve company productivity with a Business Account.Sign Up

x
?
Solved

Error- Method 'Value' of object 'Field' Failed

Posted on 2006-10-23
2
Medium Priority
?
627 Views
Last Modified: 2011-09-20
Hi all you experts--

Here is some background--
Backend:  SQL Server 2000
Front:      Access 2003 ADP file
Users:     10-15
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!

Normenclature
0
Comment
Question by:normenclature
2 Comments
 
LVL 44

Accepted Solution

by:
Leigh Purvis earned 2000 total points
ID: 17793309
A re-install might help anyway, as it sounds like it could be a references issue.
(Especially the problem with Date function).

Perhaps an exact example of when you've gotten the error message you describe in the subject.
As it would be a control that you determine the value of.

Try re-selecting the references in your project - and re-registering the library files themselves (with RegSvr32).
0
 
LVL 1

Author Comment

by:normenclature
ID: 17797133
Thanks LPurvis--  I'll try that and let you know
0

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Usually, rounding is performed by some power of 10 - to thousands, hundreds, tens, or integer - or to one, two, or more decimals. But rounding can also be done to a power of two, say, 16 or 64, or 1/32 or 1/1024, even for extreme values.
This following write-up describes a different way to copy Lotus Notes Calendar to Outlook. Along with this, we will also learn the reason behind this NSF to PST migration. Users can prefer different procedures as per their convenience.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

584 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question