Keep track of PDF,OneNote files

[Guest]

At this time I am using paper filing for my customer records. I have about
10,000 customers and each has 3 to 5 pages of records. The records are in
text as well as in graphic. I intend to use a database to keep track of my
customer records.
If I am going to create the records in PDF, MS OneNote or MS Word format,
how can I integrate it to the customer database?

Best Regards,

Al

 

[Arvin Meyer]

I would store them in a folder under the customer's name and store the path
to each document as part of the file name. For instance:

tblCustomer
CustID
CustomerName
....

tblCustomerDocs
DocID
CustID
FileName
....

Now you can access a file name Sales.pdf for a form/subform by clicking a
label like this:

Sub lblHyperlink_Click(Cancel As Integer)
Dim strPath As String
If Not IsNull(Me.txtFileName) Then
strPath = "C:\Cumtomers\" & Me.Parent.txtCustomerName & "\" &
Me.txtFileName
Me.lblHyperlink.HyperlinkAddress = strPath
End If

End Sub
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access