create way load files
Request a callback

We'll call during UK business hours

Name:
Number:
0207 987 3777
STL

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

z://mydocuments

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

Jacob


 

Access tip:

How To Display An '&' In A Label In A Form

To have your label display a sentence with an &(ampersand) in it, like Fox & Hound simply type it as:

Fox && Hound

View all Access hints and tips

Training classes
London & UK

Live dates & prices »

On-site training

60-second quote »

E-Learning

From £99 · Call us »

Mailing list

Sign up for latest offers »

 

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.



Excel training
Course rating
4.7 stars - based on 24911 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

info@microsofttraining.net

Resources