[AccessD] Load from test AGAIN

Jim Lawrence accessd at shaw.ca
Wed Oct 18 15:22:54 CDT 2006


Hi Martin:

I concur with Drew on this... place a DoEvent that holds the event from
processing until the LoadFromText has finished processing.

HTH
Jim  

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Martin Reid
Sent: Wednesday, October 18, 2006 11:34 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Load from test AGAIN

No luck
 
Martin
 
its odd becasue if you run a simple application.loadfromtext it will bring
the file in even with the txt extension. 
 
So I cant see why if you use a loop to grab them all it would  fail. 
 
Martin
 
Martin WP Reid
Training and Assessment Unit
Riddle Hall
Belfast
 
tel: 02890 974477
 

________________________________

From: accessd-bounces at databaseadvisors.com on behalf of DWUTKA at marlow.com
Sent: Wed 18/10/2006 19:21
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Load from test AGAIN



Just a thought, have you tried a DoEvents after the LoadFromText in the
loop?  LoadFromText is going to go off and do it's own thing, if it does it
in a different thread (which I have seen some Access processes do), then
your code may be looping before it's ready to handle another one.  DoEvents
might let that process finish before it loops.

Drew

-----Original Message-----
From: Martin Reid [mailto:mwp.reid at qub.ac.uk]
Sent: Wednesday, October 18, 2006 1:11 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Load from test AGAIN

Ok this has me beat

No matter what I try I cant get it to loop through a folder and import the
exported text files. Tried Martys stuff, Drews stuff and my own. Used file
system object to return only the file name without the extension and no
luck.

Any help greatly appreciated.

background

Access database objects exported as text files into C\|Forms

I think need to LoadFromText all the objects in said folder back into
database.

This cannot be as difficult as it seems. One at a time and naming the files
it works. Only when I go to look through all the objects does it fail. This
is almost my last example file I need and its melting my head.


Martin



Martin WP Reid
Training and Assessment Unit
Riddle Hall
Belfast

tel: 02890 974477

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






More information about the AccessD mailing list