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

David McAfee davidmcafee at gmail.com
Thu Feb 18 13:36:09 CST 2010


I found a work around.

I selected all but one form, then selected the remaining form. I did
the same for reports and modules.
Everything exported successfully.

I re-imported everything into a new .ADP.  No errors.

Compiled fine. Not sure what to look for from here, but it does work
in A2K7 and with ADPs. :)

My ADP is about 6MB in size.

Does this version of Eat Bloat reset the form's controls life counter?

Thanks,
David


On Thu, Feb 18, 2010 at 10:55 AM, Dan Waters <dwaters at usinternet.com> wrote:
> 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
>
>
> --
> 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