98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » A loop for opening files
A loop for opening files
Resolved · Medium Priority · Version 2007
Tue 11 May 2010, 17:58Delegate Adam said...
Adam has attended:
Access Advanced course
Access Intermediate course
Excel VBA Intro Intermediate course
A loop for opening files
Hi
I have a huge database that needs refreshing on a timely fashion.
As it is linked to many identical files that differ only by part of the name I need help on the following:
I need a loop that will open a file based on the location and file name provided in the relevant set of rows. in other words, for rows 10-100 open the file XXX refresh the links and the close the file. then go to rows 101-175 and do the same.....
I want the code to identify that if there is a change in the file name, it should close the old linked file and open the new relevant file to continie refreshing.
THX
Adam
Mon 17 May 2010, 11:06Trainer Jacob said...
RE: a loop for opening files
Hello Adam
Thanks for your post. We have reviewed this and think we can assist but will need to look at your working files. As this does fall outside the capacity of the forum we are looking at 2-3 hours minimum of work to reach a solution which will be chargeable.
We would notify you of scope of work including durations and costs before proceeding.
If you would like to investigate this option further please let us know.
Kind regards
Jacob
Mon 24 May 2010: Automatically marked as resolved.
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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Combo box for finding recordsYou can use a combo box in a form to look up a record. If you place the comb box in the Form header, by then selcting they a field type from the drop down loist, you will see the record for it |
