Hi Dan,
You've got something strange going on, but it is not related to the
OWC10.dll file, since you reported that you code compiles fine without this
library included in the project.
For more information on the Office Web Components library files, you can
check out the Microsoft DLL Help database:
OWC10.dll
http://support.microsoft.com/dllhelp/?dlltype=file&l=55&alpha=owc10.dll&S=1
Version 10.x is suitable for Office XP. Version 11.x should be used with
Microsoft Office Access 2003:
OWC11.dl
http://support.microsoft.com/dllhelp/?dlltype=file&l=55&alpha=owc11.dll&S=1&x=10&y=11
Just a wild guess, but have you tried compacting your database lately (Tools
Database Utilities > Compact and Repair)?
Tom
______________________________________
:
Hi Tom,
I have a form with a date that the user enters on the screen and I open
another form with that date. The date entered does not show on the called
form and I have about 5 fields where I calculate values and round them to 0
decimals. When I take out two of these fields where I calculate a formula
and round it the form displays the data straight away otherwise it says
calculates ..... on the status bar at the bottom of the screen and after a
long time (10 to 15 mins) it finally displays the data. I have 70 records to
display.
It works perfectly on Access 2002 and Access 2000. Its just on 2003 that it
doesn't work. I suppose that I need something from the file OWC10.dll
version 1.1 (I have version 10.x on my machine).
Do I need to download that file? Where can I find it and how to download it
if I need it? I am not a very technical person.
Thanks for your help.
Dan
______________________________________
:
Hi Dan,
When you say your "dates and rounding still don't work", what exactly do you
see? How are you attempting to round your values (please provide example).
Tom
______________________________________
:
Hi Tom,
I removed the Missing reference and compiled again. It compiles correctly
(without errors) but my dates and rounding still don't work.
What must I do?
Thanks for helping me.
________________________________________
:
Hi Dan,
OWC stands for Office Web components. I believe this reference is added
automatically if you create a pivot chart or pivot table.
Anytime you have a reference marked as MISSING, common functions such as
Date, Left, etc. will fail. Here is more information on this subject:
Solving Problems with Library References (Allen Browne)
http://allenbrowne.com/ser-38.html
Access Reference Problems (Doug Steele)
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html
Try unchecking the missing reference. Then click on OK to dismiss the
references dialog box. See if your code will compile without this library
(Debug > Compile ProjectName). If you can compile your code successfully,
then you didn't need this reference checked. Otherwise, go back in and try to
set it.
Tom
______________________________________
:
hello
each time i open a database i get the following message :
Your Microsoft Access Database or project contains a missing or broken
reference to the file OWC10.DLL version 1.1
In the references pane I see
MISSING : Microsoft Office XP Web Components
Functions like date() don't work anymore.
any ideas ?
thanks