DiffDate Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm using a DiffDate on a form to calculate student's age. It works fine on
my screen, but when another employee pulled up the same form, they got an
?name error. We're both using Access 2002. When she clicks on the error
field, she's gotten two different errors. One refers to an "on click"
expression of which that field has no "on click" expression entered. And the
2nd error refers to a missing OWC10.DLL file. With us using the same
version, can anyone shed light on how she's getting an error when I'm not.
Thanks, Dj
 
There is a reference missing on her computer.
Open your VB editor, select Tools, References and see what reference that is.
Do the same on her's. You may find a references that says "Missing". You
will need to establish that reference.
 
My first 5 references are checked and so are her first 5. All the rest of
them (and there are a bunch) all are unchecked. Does that help or mean
anything?
 
Are the 5 that are checked exactly the same references? That means they must
be the same file name in the same path. It has nothing to do with the
Operating System version, it has to do with the version of Access and in
cases where you are refering to external objects like Excel, it has to do
with the version of the external app installed.

Here is a link you should investigate:

http://support.microsoft.com/default.aspx?scid=kb;en-us;283115
 
While you may both have 5 references checked, are they the same 5
references, are they in the same order, and is the word "MISSING: " in front
of any of the checked ones?
 
Ok, now we're getting somewhere. I'm sorry I didn't check that more
thoroughly the first time you told me to. Her reference to Microsoft Office
XP Web Components says "missing". She is working off a PC that has Windows
XP. Is it a simple fix to find or load that missing .dll file. Once I'm
done developing the database, there will be multiple users and I'm hoping the
rest of them don't have the same missing reference.
 
You may not need the Microsoft Office XP Web Components at all.

Simple uncheck this Reference and recompile the code and see if any Compile
error appear.

If you do need OWC, it is likely that she has the file but it is in a
different location.
Search her PC for this file and point the Reference to the correct location.

On my PC, the file is in

"C:\Program Files\Common Files\Microsoft Shared\Web Components\10\"

but I hsve seen it in other locations also.
 
Back
Top