[AccessD] VBA Runtime Error

JWColby jwcolby at colbyconsulting.com
Wed Aug 16 14:59:54 CDT 2006


Boy howdy, I second THAT one.  Option explicit is a requirement in my book. 


John W. Colby
Colby Consulting
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of MartyConnelly
Sent: Wednesday, August 16, 2006 2:54 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] VBA Runtime Error

You might want to put statement Option Explicit in all your modules to force
variable declaration and recompile

Kaup, Chester wrote:

>This is a single database thus front end back end. It stops in the same 
>place every time. I think I may have solved the problem. I did not dim 
>a date variable - just let access do it. I dimmed it and code is now 
>running.
>
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of JWColby
>Sent: Wednesday, August 16, 2006 10:40 AM
>To: 'Access Developers discussion and problem solving'
>Subject: Re: [AccessD] VBA Runtime Error
>
>Is it consistent?  Perhaps a corrupt FE or BE.  Is it intermittent or 
>one time?  Perhaps a bad NIC or other network problem.
>
>
>John W. Colby
>Colby Consulting
>www.ColbyConsulting.com
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, 
>Chester
>Sent: Wednesday, August 16, 2006 11:18 AM
>To: Access Developers discussion and problem solving
>Subject: [AccessD] VBA Runtime Error
>
>Had the following error come up when running VBA code in a module. Line 
>it stopped on set a variable to a table field in a native table. What 
>does it mean?
>
> 
>
>Run-time error '-2147417848(80010108)'
>
> 
>
>Automation error
>
>The object invoked has disconnected from its clients.
>
> 
>
>Chester Kaup
>
>Engineering Technician
>
>Kinder Morgan CO2 Company, LLP
>
>Office (432) 688-3797
>
>FAX (432) 688-3799
>
> 
>
> 
>
>No trees were killed in the sending of this message. However a large 
>number of electrons were terribly inconvenienced.
>
> 
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>  
>

--
Marty Connelly
Victoria, B.C.
Canada

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list