Cindy Fraase
CFraase at officeimagesinc.com
Fri Apr 20 11:40:24 CDT 2007
Hi all,
I'm really mystified as to what is happening. The following line of code
works fine on my machine, but fails with this error on another. Both
machines are running Access 2003 and all of the references match. The
database is in Access 2002-3 format. It's located on the server, so I'm
running exactly the same database as he is.
I've created an Excel sheet via automation and am filling it with data
here.
The line is:
objSheet2.Range("A2").CopyFromRecordset rsSalary
The error message I get is:
430 Class does not support Automation or does not support expected
interface.
Any insights would be greatly appreciated!
Thanks,
Cindy
Cynthia Fraase
Asst. Controller
Direct: 678-325-3251
Cell: 770-318-0628
Fax: 770-641-2656
www.officeimagesinc.com
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darren DICK
Sent: Sunday, February 04, 2007 5:27 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] A2003:Determining Background colour of the
desktop
Stuart
Work of genius - well done and thanks
Darren
------------------
-----Original Message-----
From: Stuart McLachlan [mailto:stuart at lexacorp.com.pg]
Sent: Friday, 2 February 2007 9:16 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] A2003:Determining Background colour of the
desktop
On 2 Feb 2007 at 8:47, Darren DICK wrote:
> Does anyone know how to determine the background colour of the
desktop?
>
> I have a form I want to set its background colour to match
Look up "System Color Constants" in VBA Help (remember to omit the "u"
<g>)
Specifically "vbDesktop 0x80000001 Desktop color "
So set the Detail Backcolor property to &H80000001 or to -2147483647
--
Stuart
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com