On a table, input one data from a field to another field with a different text type

[damienjude]

From a table I want a text field which has a path to a file to be copied automatically into a another field of the same table with a hyperlink text type

 

[jdraw]

How about a sample showing what you start with, what you do next, and what you want as a result?

 

[damienjude]

Well, I am actually making a photo database, the user keys in the path of the folder he wants to link to the database in a field with a text data type. The field is called "Photo Location". Then I put an unbound image frame and used Photo Location as its control source.

Then I realised the only way for the user to go to the photo is to copy and paste the path to Windows Explorer, which does consume time. So I was thinking of a hyperlink to deliver him to the folder right away. Which lead me to have a field "Photo Link" with a hyperlink data type, but I can't get it to have equal data as Photo Location since having the user to type it twice does sound troublesome.

 

[jdraw]

If you have a photo on your PC, here is a simple proc to display a photo via a hyperlink.
This isn't what you asked, but I don't have a sample of that at the moment.
You could try Google to see if you can fins an example.

Here's a very simple 1 photo approach, that you could build on if you knew the directory where the photos were located. This was looking for something on line for someone a few years ago. I just adjusted a couple of lines to link to photo.

Sub awf2()

Dim myurl As String

myurl = "file:\\c:\pictures\" '<---Your Folder name
Dim n As string
n = "DSCF1387.JPG"   '<------Your file name
Application.FollowHyperlink myurl  & n
End Sub

I will look to see if I have an example somewhere.


PS> I just found this via Google after hitting submit.
http://www.access-programmers.co.uk/forums/showthread.php?t=108698

 

[damienjude]

I've open the database and clicked on browse but nothing happened. should I keep it in a different location?

 

[jdraw]

I just downloaded the database. I hit Browse and selected a folder with some jpgs.
And displayed the photo.

I removed the BMP text from the form.

I'm attaching a sample.