Solved Attaching documents to each record (1 Viewer)

georg0307

Registered User.
Local time
Today, 07:45
Joined
Sep 11, 2014
Messages
91
Dear All,

could you please help me with the following matter?

I'd like to attach several custom documents (*.pdf and other) to each record of my Database. Is it possible do it avoiding it becoming too heavy?

Thanks oin advance,
 

Attachments

  • PICK_SHIP.accdb
    512 KB · Views: 239

Ranman256

Well-known member
Local time
Today, 02:45
Joined
Apr 9, 2015
Messages
4,336
I advise against it. Your db will fill up quick.
instead, save the path to the documents.
 

boerbende

Ben
Local time
Today, 07:45
Joined
Feb 10, 2013
Messages
339
Agree wit Ranman.
My solution is also to keep the documents stored on the network and to save the whole path to the document in a text field
To open the document I use one line of code in for example a doubleclick event on the document name in a form

Shell "C:\WINDOWS\explorer.exe """ & YourPath & "", vbNormalFocus
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 23:45
Joined
Oct 29, 2018
Messages
21,322
Is it possible do it avoiding it becoming too heavy?
It's possible to add documents, but it won't be possible to avoid making it heavy. Follow what the others said and don't add actual documents.
 

Users who are viewing this thread

Top Bottom