[AccessD] New Export As Text (EAT) Form - Need Beta Testers

Dan Waters dwaters at usinternet.com
Thu Feb 18 12:55:35 CST 2010


Hi David,

Aren't line numbers great?

I will make FileSystemObjects a late-binding reference to avoid that issue.
Perhaps then the form will reset itself to Access 2007.

I'll look at the other items - but I don't have Access 2007 right now so
I'll have to come up with some way to test.

Thanks!
Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David McAfee
Sent: Thursday, February 18, 2010 12:31 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] New Export As Text (EAT) Form - Need Beta Testers

In an A2007 adp (well, originally the ADP was created in A20003, I am
now running A2K7) I get an error if I try to start frmEat.

The error is in UpdateDateTime on line
Dim fso As FileSystemObject

The error is: Compile Error: User-defined type not defined.

I added references to Microsoft Scripting Runtime and Microsoft Office
12.0 Object Library, which were missing, and the forms now opens
without errors.

I then saw the notes section of the form telling me to do check the
references. :)

I selected all forms, reports and modules (I tested query, even though
they don't exist in ADPs and it did give me an error)

Anyway, (maybe I am doing this wrong?) I selected all three items in
the right (Ojects selected) list box (FORM! ALL, REPORT! ALL, MODULE!
ALL )
and I get an error in ExportAllToFile. Line 24  Set con =
dbs.Containers("Forms") (also line 29 & 34 for reports & modules)

The error is error 91, Object variable or With block variable not set.

Any idea?

Thanks,
David



On Thu, Feb 18, 2010 at 9:24 AM, Dan Waters <dwaters at usinternet.com> wrote:
> Can you describe what happens?
>
> Dan
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kenneth Ismert
> Sent: Thursday, February 18, 2010 9:41 AM
> To: accessd at databaseadvisors.com
> Subject: Re: [AccessD] New Export As Text (EAT) Form - Need Beta Testers
>
>>
>> Dan Waters:
>>  I have only used this in Access 2003.
>>
>
> It doesn't work with Access 2000 on my work computer.
>
> -Ken
> --
> 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
>

-- 
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