DWUTKA at marlow.com
DWUTKA at marlow.com
Wed Oct 18 13:43:40 CDT 2006
Still could be a timing issue. About how long does it take for it to do it when you do just one? Put in a simple timer to 'pause' the loop a few seconds longer then it takes to run the process.... Drew -----Original Message----- From: Martin Reid [mailto:mwp.reid at qub.ac.uk] Sent: Wednesday, October 18, 2006 1:34 PM 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/>