STORING MS EXCEL, MS WORD, and PDF FILES in MS ACCESS NOTES FIELD

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database set up with Construction Equipment for a large construction
fleet. Each piece of equipment is assigned an equipment number and that is
how it is stored in MS ACCESS. If you want to know something about a piece
of equipment you pull it up by equipment number. I have alot of MS WORD
Documents, MS EXCEL, and PDF files that have information about each piece of
machinery and I would like to store them under the equipment number. For
each piece of equipment we have a"NOTES FIELD", I have tried copying and
pasting the documents to the "NOTES FIELD" however it will not allow me to
paste the documents in that field. Is there a way to store these documents
under the equipment # set-up we have in MS ACCESS? What type of field do we
need to have?
 
Hi, Eddie; you brought back some memories. I developed an application for a
fleet of construction equipment also, for a Sales department. Rather than
try to stuff all that info in your database, I suggest you use hyperlinks in
a subform, based on a new table that has the fields,

Key Primary Key
EquipmentNumber Foreign Key to Your Main Table
Link Hyperlink

Use a consistent file-naming convention. Then you can display all the
linking info in a subform, and click on it to launch the Word or Excel app to
display it. Then you let each program do what IT does best, rather than
trying to stuff it all in Access.

HTH
Kevin Sprinkel
 
Hey do you have some help available for me I want to hyperlink a test script
I have created in excel to the manual in PDF any ideas Please email me a
(e-mail address removed) if you do thank you and I selected you because you
sounded like you have some good background so I hope you can help
 
Back
Top