create way load files
Request a callback

We'll call during UK business hours

0207 987 3777

Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Create a way to load files from a collection of references

Create a way to load files from a collection of references

resolvedResolved · Low Priority · Version 2007

Wed 14 Mar 2012, 16:22 replyReply Delegate Tushil said...

Tushil has attended:
Access VBA course

Create a way to load files from a collection of references

I have a a form which collects a path, this is taken into a table and duplicated for each row but also in addition it concats a string which is hard coded with a counrer

so a user enters


the table with VBA then loops through all the folders in mydocuments and logs these with the hard coded string called "/source" + intcounter

so we get z:/mydocuments/source1, z:/mydocuments/source2 and so on, this works perfact and is fine.

The second part will pick up a file from each folder then run procedures to load the files from all the folders to the database via other routines. However this is fine when it happens to be the first folder by it doesnt do this for the second record in the log of all the folders. I feel in the loop something needs to be initialized before it can go back and run the sub routines on the second record and so forth.
Where am i going wrong?
there is a view loops which do this loadng and its this which i feel is not working correctly.

Can i send you the code to show this?

For upcoming training course dates see: Pricing & availability

Tue 20 Mar 2012, 16:34 replyReply Trainer Jacob said...

RE: Create a way to load files from a collection of references

Hi Tushil

Thanks for your post and sorry for the delay in getting back to you.

We can certainly have a look at your working code for you but it is worth clarifying that this sort of query takes us beyond the scope of the forum.

In these cases we look at your work and if we can identify a solution we will let you know scope, duration and associated costs.

If you would like to look into this further please do contact our enquiries team.

Kind regards



Please browse our web site to find out more about
microsoft access training uk and other Microsoft training courses.

Access tip:

Duplicating an Entry

To duplicate the entry press CTRL+' (apostrophe)this will copy the contents of the previous entry in the same field.
(Table view, line above) note this also works in Excel.

View all Access hints and tips

Excel training
Course rating
4.7 stars - based on 24710 reviews
Microsoft Certified Partner Institute of Leadership and Management - Certified Courses Learning and Performance Institute - Accredited Training Provider Security Seal verified by visa, mastercard securecard

Connect with us: Google+ · Facebook · Twitter · LinkedIn · Pinterest

2nd Floor, CA House, 1 Northey Street
Limehouse Basin, London, E14 8BT
United Kingdom