Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » A loop for opening files

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

A loop for opening files

Resolved · Medium Priority · Version 2007

Reply 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

For upcoming training course dates see: Pricing & availability

Reply 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.

Access articles

· Access Database Optimization: First Normal Form
· Microsoft Access Courses
· Microsoft Access Training Unleashes the Power of the Pivot Table
· An Essential Guide To Using The Northwind Database In Access 2010
· Understanding Primary And Foreign Keys In Microsoft Access

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

Access tip:

Closing form after a certain time period

To make a form close automatically after a certain time period, you need to assign the close function to a macro.

Save the macro and ope up the form in design view. open the Properties sheet.

In the TimerInterval property enter the length of time you want the form open for. This should be in milliseconds, so for instance if you want the form open for 5 seconds enter 5000, for an minute enter 60000.

You now need to attach your macro (to execute the Close action) to the OnTimer event property of the form.

View all Access hints and tips