Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Image path for 3 computers. How to control?

Image path for 3 computers. How to control?

Image path for 3 computers. How to control?

Our historical society has 3 people who use their home windows notebook. We plan to put the Access file and the Image subdirectory onto a passport flash drive.
Then the 3 people take the passport home and I would have a batch file automatically refresh their harddrive.

The problem will be that we 3 people have a different PATH that links the subdirectory to the access file. Mine is:

The others do not have Glen in their path. It is whatever their computer was setup at the store.
For instance C:\Users\Joe\Documents\Wchs\Image\RedWingBlackbird.jpg

1 - Is there a trick to make the path automatic to all 3 computers who are not in a Lan?

EG maybe a table with each person's path and a checkbox to state which is the preferred one depending on which machine is used.
And then somehow, the Access fields could take the desired path and add the file name. Like a concatenation>

2 - Also, Is there a way to doubleclick on the image to see it bigger?

An example is attached. Thanks. Cimoli.

RE: Image path for 3 computers. How to control?

First I always only save the image name, never a name and a path. That way when you change the path when you move the folder.
I would have a small table for user settings like:
maybeOtherSettings for that user

I would keep this table in a seperate db on the user machine and bring this in as a linked table. So each user will have there own linked table that they keep on their own machine. Similar to making a split database.
Your fullpath is then done by concatenating the imagePath from table Settings with the file name. This can be done in a query used as the recordsource of your form.

However, in truth you should have this database split anyways if you have multiple users on a Lan. So you would then do it in reverse. Then everyone should have their own front end on their local machine (forms, reports, code, queries) and everyone is linking to a backend (tables) on the server. The users at home should be sent the back end and image folder only. They then would have in their front end the settings table, and they would link to the backend tables you send them. The only time users get a new front end is when forms, code, queries, and reports change.
You should never run a shared database over a network without splitting it, makes no sense.

Select ... imageFolder & ImageName as ImagePath
You then bind your image control to the concatenated field ImagePath

To get a big picture make a pop up form with a big image control on it. I would make it acdialog. Double click and open to that image.

RE: Image path for 3 computers. How to control?

Thanks much MajP. Really good.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close