Hello,
I have 2 Tables.
tblOrder
tblAttachment
In tblAttachment i have 5 Fields.
ID
AttFile - Attachment field
AttFilePath - A Short text field which stores the path on my C Drive
AttType - The type of attachment .PDF .JPEG etc.
AttName - The name of the Raw file as saved on the C Drive
I have a folder on my C Drive that i store all my attachments then i manually input all the data into the table for that attachment.
I have a form based on tblOrder that has a button (cmdAtt) that i would like to open a specific attachment saved in tblAttachment when i click once on it.
How do i enable the button to run a specific path or open a specific attachment (FreightMatrix.PDF)? The tables are on the back end if that means anything.
Thanks.
I have 2 Tables.
tblOrder
tblAttachment
In tblAttachment i have 5 Fields.
ID
AttFile - Attachment field
AttFilePath - A Short text field which stores the path on my C Drive
AttType - The type of attachment .PDF .JPEG etc.
AttName - The name of the Raw file as saved on the C Drive
I have a folder on my C Drive that i store all my attachments then i manually input all the data into the table for that attachment.
I have a form based on tblOrder that has a button (cmdAtt) that i would like to open a specific attachment saved in tblAttachment when i click once on it.
How do i enable the button to run a specific path or open a specific attachment (FreightMatrix.PDF)? The tables are on the back end if that means anything.
Thanks.