Search results

I found out about the trucation. In the feild it assumes any portion of a hyperlink when the file is in the same drive as the database. I'm down to my last line where i reload the new hyperlink into the old field and something isn't working there. Dim db As Database Dim rs As Recordset Dim...

Re: auto storage I'm down to my last line where i reload the new hyperlink into the old field and something isn't working there. Dim db As Database Dim rs As Recordset Dim Doc_Name As String Dim PartNmber As String Dim ChangeRequestNumber As String 'Dim Dte As String Dim Hyper_MOT1 As...

Is there a setting that will stop the truncation of the first portion of a local hyperlink (my own drive)? when adding a hyperlink into my database leading to a file on my own drive it reads.. ..\temp.pdf I need it to read.. C:\temp\temp.pdf

In other words if i can get it to quit truncating my local address as i drop the hyperlink into its field i got it whooped.:)

That part is doing what i want. Ihe person using the database wants to drop a file he has prepared onto the link (from wherever it is usualy his own drive) and the file will recieve a unique name then be saved into a predetermined location (g drive...). It is just giving me a file not found...

When auto filing a hyperlinked document - My code is working from a network drive but not my own. Addresses to seem to be "shortcutting" a portion of the address I need. Of course i would like this to function from both network drives and a persons local. Instead of C:\Temp\temp.pdf My...

Re: auto storage This is how far I've got. Dim Doc_Name As String Dim History_Folder As String History_Folder = "G:\New G Drive\Data\Change_Request_Database\File_storage" Doc_Name = "(Part #) & (Change request #) & (Date) & (MOT1)" FileName = RDB_Create_PDF(History_Folder & "\" & Doc_Name &...

auto storage I have a hyperlink field in my database. When i drag and drop a *.pdf file onto that field. I need code that will additionaly rename the file and place it into a designated directory on my intranet. The leftover hyperlink wants to connect to the new file.