A loop for opening files

Resolved · Medium Priority · Version 2007

Tue 11 May 2010, 17:58 Delegate 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:06 Trainer 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 courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Access tip:

Combo box for finding records

You 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

View all Access hints and tips