Prev: disable esc key on compact and repair
Next: Immunization
From: Zen on 4 Nov 2009 16:10
Thanks Gina, I will go forward trying to use it without that reference
hopefully I don't run into problems. RE not being able to use it in Access
2007. This is on older app we've been using and it is on its last leg. We're
in the process of phasing it out and the recent changes we made were part of
that.

Thanks again.


From: Tony Toews [MVP] on 4 Nov 2009 16:52
"Zen" <r-> wrote:

>First lemme add that the developer insists they used 2002 for the new
>changes.

Sure, who knows how this reference got in there.

>So now bear with me because I don't understand what you mean when you say
>compile my project. The front end is not an executable runtime, outside of
>that what is there to compile?

Once you've removed the reference you can compile the project by going
into the VBA code editor >> Debug >> Compile.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a free, convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/
From: Tony Toews [MVP] on 4 Nov 2009 16:53
"Zen" <r-> wrote:

>But double clicking the module just loads the editor. If I click the run/sub
>user form button on the vb editor nothing seems to happen, same if I to to
>Run>Run Sub/User Form or hitting F5
>
>Sub ViewReferenceDetails()
>
>Dim ref As Reference
>
> For Each ref In Access.References
> Debug.Print ref.Name & " - " & ref.Major & "." & ref.Minor &
>"spaceMINUSspace" & ref.FullPath
> Next ref
>
>End Sub

Ctrl+g then type in

Call ViewReferenceDetails

in the immediate window.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a free, convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/
From: Zen on 4 Nov 2009 17:44
Call ViewReferenceDetails
VBA - 4.0 - C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL
Access - 9.0 - C:\Program Files\Microsoft Office\Office10\msacc.olb
VBIDE - 5.3 - C:\Program Files\Common Files\Microsoft
Shared\VBA\VBA6\VBE6EXT.OLB
DAO - 5.0 - C:\Program Files\Common Files\Microsoft Shared\DAO\dao360.dll
stdole - 2.0 - C:\WINDOWS\system32\stdole2.tlb
MSComDlg - 1.2 - C:\WINDOWS\system32\Comdlg32.ocx
MSXML2 - 6.0 - C:\WINDOWS\system32\msxml6.dll

ERROR WINDOW
Run-time error '-2147319779 (8002801d)':
Your contacts database or project contains a missing or broken reference to
the file 'OWC10.dll' version 1.2

Also, if I remove the reference and then try to compile the window flashes
briefly and nothing happens.

Let me add, that this is a really old project that has been updated and
revised since 1999 originaly with access 97 or 98 then upgraded to 2000 and
then we've been using XP (2002) ever since.

Our core developer last used ver 2003 if I remember and it's likely he put
this reference, not the guys who made these most recent changes.

But I haven't been able to get a hold of him about it.

"Tony Toews [MVP]" <ttoews(a)telusplanet.net> wrote in message
news:jtt3f51ula2u7tnaivvfi4cripifd7json(a)4ax.com...
> "Zen" <r-> wrote:
> >
> Ctrl+g then type in
>
> Call ViewReferenceDetails
>
> in the immediate window.
>


From: John W. Vinson on 4 Nov 2009 18:23
On Wed, 4 Nov 2009 14:44:25 -0800, "Zen" <r-> wrote:

>Your contacts database or project contains a missing or broken reference to
>the file 'OWC10.dll' version 1.2
>
>Also, if I remove the reference and then try to compile the window flashes
>briefly and nothing happens.

That's just what it should do. If there were code calling the DLL you would
get an error. The fact that you don't get an error popup suggests that there
is noplace in your code that actually uses OWC10.dll, so you should be fine to
just uncheck it.
--

John W. Vinson [MVP]
First  |  Prev  |  Next  |  Last
Pages: 1 2 3 4
Prev: disable esc key on compact and repair
Next: Immunization