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 / SQL Server / ADP / November 2005

Tip: Looking for answers? Try searching our database.

Run-time error on Calendar click

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jeff - 15 Jul 2005 22:03 GMT
Strange thing just happend. My Calendar form was working fine and all of a
sudden I'm getting a run-time error:

"Method 'Value' of object '_CustomControl' failed.

My code is crashing on:

Forms!Calendar!Calendar.Value = Date

Any ideas?
Jeff - 15 Jul 2005 22:20 GMT
Strange thing. I just tried running the database from home through terminal
services and it runs fine. Could something have been changed with my Access
settings on my system at work? Such as corrupt dll file? I'll have to run
some further testing on Monday.

>Strange thing just happend. My Calendar form was working fine and all of a
>sudden I'm getting a run-time error:
[quoted text clipped - 6 lines]
>
>Any ideas?
Sylvain Lafontaine - 15 Jul 2005 22:33 GMT
Did you copy this database beetween two different versions of Windows?

Check your references and make sure that they are OK.  If necessary,
decompile/recompile the database, particularly when you want to move it to
another system.  The slightest change in version, for exemple in one of the
service pack, may give you this problem if you don't force a recompilation
of the whole thing.

(For decompiling, you can use the /decompile switch from a link.  You can
also do it without using this switch by adding a dummy reference in the VBA
application, closing the dialog window to make sure that Access take notice
of the change, then reopens it and remove the reference previously changed.)

Signature

Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC

> Strange thing. I just tried running the database from home through
> terminal
[quoted text clipped - 13 lines]
>>
>>Any ideas?
Philipp Stiefel - 17 Jul 2005 15:58 GMT
> (For decompiling, you can use the /decompile switch from a link.  You can
> also do it without using this switch by adding a dummy reference in the VBA
> application, closing the dialog window to make sure that Access take notice
> of the change, then reopens it and remove the reference previously changed.)

I ran into some issues with adding/removing library-references
in a large Access-App with lots of references, which indicate
that it will not force Access to decompile the whole code in
every case, especially if there already are issues with some
parts of the compiled code.
Hence I recommend just using the decompile-switch for complete
decompilation!

Cheers
Phil


Jeff - 18 Jul 2005 20:42 GMT
Turns out the corruption issues was only on my local system. I was able to
narrow down the cause as a recent installation of an HR application that I
have been testing. Appears the installation re-mapped some dll files.

>> (For decompiling, you can use the /decompile switch from a link.  You can
>> also do it without using this switch by adding a dummy reference in the VBA
[quoted text clipped - 11 lines]
>Cheers
>Phil
Joanie Anderson - 01 Nov 2005 20:18 GMT
I'm having the same problem "method 'value' of object '_CustomControl'
failed".  
I've tried compiling the code but no luck.  Still having the same problem.
Can anyone offer
further assistance please?
Thank you.

>> (For decompiling, you can use the /decompile switch from a link.  You can
>> also do it without using this switch by adding a dummy reference in the VBA
[quoted text clipped - 11 lines]
>Cheers
>Phil
 
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.