[chrisuk2009]

i am working on a new database which so far has 24 record sets in it. I have a hyperlink field and every time time i insert a hyperlink it works ok then i lose the record set link is within. More links i add more record sets i loose. good job i had a back up of my work.
Can anyone please infom me of cause and solution to this problem please ?

[OBP]

chris, welcome to the Forum.
I have never heard of your problem. But you can overcome it by using a plain text field and then using the VBA "Follow Hyperlink Method"

[chrisuk2009]

thank you for responding, i am a beginer to this and i do not know what VBA "Follow Hyperlink Method" is

please tell me more

[chrisuk2009]

i forgot to say, record only vanishes after you close the database and restart it

[OBP]

chris, the VBA code goes in the Form Field's "On Click Event Procedure" for your hyperlink field which should now just be a text field with 255 characters.
The code itself would like this

if Not Isnull(me.hyperlinkfieldname) then Application.FollowHyperlink me.hyperlinkfieldname, , True

Where hyperlinkfieldname is the actual name of the field on the form, the Not Isnull is there to ensure that you don't try to follow a blank hyperlink

[chrisuk2009]

Thank you for your help, this fixes original problem, but now has generated a second problem. I was right clicking the individual files in explorer and then pasting into here before, but won’t let me do this in this text box. I have around 1000 records to generate in here I need to hyperlink, so typing in every one will take me weeks

[OBP]

chris, I didn't realise it was for files, I thought it was for Internet addresses.
You can download all the files in a Folder in one go.
Have a look at this database, I created for Document Management, it has some very good VBA in it, but it does rewuire that you set VBA Editor Library References, so there is also an Excel sheet showing what they should be.
You are quite welcome to use any of it you like and I will talk you trhough how to do it.
It has some built Instructions on how to use the various Forms.

[chrisuk2009]

Thank you for your help and patience, but it seems not my data today. The database will not open, please see my attachment. It is on my desk top so on my computer, I can’t see why it sees this as a threat

[chrisuk2009]

it is a shame this DB would not open, could have saved many hours of work with so many files to link to

[OBP]

Copy the database to your desktop, zip it and then delete the desktop copy.
Unzip the database try it again.
You can also change the Properties of the database to from a Trusted site.

If that doesn't work get back to me and I will post the code that you need.

[chrisuk2009]

cheers , this worked fine it opens OK now

i will now need help on what to do next, i can see how to select a file from my folder at it does show in the box , but how will i get this to link with my database ?

your help is much appreciated, thank you

[OBP]

Chris, you don't, what you need to do is Import the Form and VBA Modules in to your Database. I will then give you Instructions on what to change (File Table name in the VBA, form's record source etc).
You will probably need the File Types table & query as well to make the form work

Or you could import them in to the table in my database and then Copy and Paste them in to your table or Import my table in to your dataabse and then create an Append or Update query to add the data to yout Table.

Or I can do it for you.

[chrisuk2009]

yes please , if you can modify this for me it would i guess be easier, please file zipped

regards chris

[OBP]

Chris, oh boy does that bring back memories for me, if you check my Forum profile you will see that I worked for Ford's for 33 years in the Quality Engineering Department and created a Quality Engineering Database (QED) while I was there.
I can offer a couple of improvements for your Operator Mainform if you like.

What I am going to do is create a "Document" table to hold the Path to your Instuctions, it will have an ID to match up to your current "OI_Document_Number" but it should really be the "IDNumber", but you won't know that until you have created all of the OI_Table's records.
If you run the VBA code to populate that table we can then discuss matching up the data to the OI_Table.
Is the Hyperlink Address on a Local Network Server that you can browse to?
Or can you provide it's designated Drive letter?

[OBP]

Chris, here is the Importing Version, it works Ok on my computer. The VBA code that gets the "OI_Document_Number" from the File name won't work properly if you change the file naming convention from "oi OI_Document_Number etc.