Dear All,
Good day,
I want to open folder link from table database, but that link wouldn't open the folder.
first, i store the folder link in FileLocation Fields and i set datatype as Hyperlink. Please see the picture below.
actualy file location will store attachment data/file but i replace with folder link. here i attach my query:
would you to guide me how to make it better?
thank you
Good day,
I want to open folder link from table database, but that link wouldn't open the folder.
first, i store the folder link in FileLocation Fields and i set datatype as Hyperlink. Please see the picture below.
actualy file location will store attachment data/file but i replace with folder link. here i attach my query:
DC = " INSERT INTO [Tb_Asset] ( Sapcode, Flexcode, Namaaset, Serialnumber, Tanggaldep, Qty, LOKASI, FileLocation) " _
& " SELECT [Forms]![frmNew]![txtSap] as Sapcode, [Forms]![frmNew]![txtflex] AS Flexcode, " _
& " [Forms]![frmNew]![txtnama] as Namaaset, [Forms]![frmNew]![txtsn] as Serialnumber, [forms]![frmnew]![txtdate] as Tanggaldep, " _
& " [Forms]![frmNew]![txtqty] as Qty, [Forms]![frmNew]![txtlokasi] as Lokasi, [Forms]![frmNew]![txtfileloc] as FileLocation "
DoCmd.RunSQL DC
MsgBox "Data sudah tersimpan", vbInformation, "INFO"
DoCmd.SetWarnings True
Me.txtFlex = ""
Me.txtsap = ""
Me.txtnama = ""
Me.txtsn = ""
Me.txtdate = ""
Me.txtqty = ""
Me.txtlokasi = ""
Me.txtfileloc = ""
would you to guide me how to make it better?
thank you