Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / January 2006

Tip: Looking for answers? Try searching our database.

ActiveX Error; please explain!

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
David Habercom - 24 Jan 2006 17:16 GMT
When a subform loads, it runs a module using the system date.  It has worked
without flaw for several years.  Now it fails.  I discover that one of my
"available references" is missing: "DatePicker ActiveX Control module" in
C:\Novell\Groupwise\GWDPK.OCX!  The university recently switched to a
different email client and got rid of GroupWise.  (And good riddance, it
was...)

1) What on Earth did I do to make my Access database depend on a GroupWise
control?
2) What do I do now to get my system date back?

Please help on this, as I obviously don't understand something fundamental!

Thanks.
Signature

David Habercom
University of Tennessee

Michel Walsh - 24 Jan 2006 18:40 GMT
Hi,

If you don't use that reference, UNCHECK it...

Maybe it is needed by a subroutine (or was needed) which is not used (very
often) anymore. In VBE, Tool | Compile yourDatabase   should tell you, with
an error, if that library is still required, and WHERE (in which line of
code), once you unchecked it. It is up to you how to repair your code, if
that occurs. If not, you can assume the reference was not really required.

Hoping it may help,
Vanderghast, Access MVP

> When a subform loads, it runs a module using the system date.  It has
> worked
[quoted text clipped - 12 lines]
>
> Thanks.
Dirk Goldgar - 24 Jan 2006 19:14 GMT
> When a subform loads, it runs a module using the system date.  It has
> worked without flaw for several years.  Now it fails.  I discover
[quoted text clipped - 5 lines]
> 1) What on Earth did I do to make my Access database depend on a
> GroupWise control?

Can't help you with that one.  Maybe you added that control to a form,
then later removed it.

> 2) What do I do now to get my system date back?
>
> Please help on this, as I obviously don't understand something
> fundamental!

I'm not sure what you mean by "using the system date".  If you meant
that references to the VBA Date() function are failing, it could well be
because of the broken reference to the GroupWise control.  That broken
reference could be interfering with Access's ability to resolve other
references -- VBA always seems to be the first one to take the hit in
these cases.

Try removing the missing reference and then recompiling your database.
If that reference was really needed, you should get an error that
highlights where it was used.  If you don't get an error, maybe your
troubles will be over.

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

David Habercom - 24 Jan 2006 20:08 GMT
Thanks for your feedback.  Yes, by "system date" I did mean the VBA Date()
function.  The fix turned out to be simply un-checking that item in the
reference list.  I guess Access just went to another reference and the code
is now OK.  I'll recompile to be sure.

I still don't know how that reference got in there, but there was a period
when I was attempting to send a bulk-email from an MS Word merge through
GroupWise.  The data for the merge was in this Access dbf, and maybe
something got connected oddly.  I'll blame it on GroupWise, since it behaves
like a stubborn child anyway.

Thanks again.

Signature

David Habercom
University of Tennessee

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.