Stuart McLachlan
stuart at lexacorp.com.pg
Tue Mar 11 16:51:00 CST 2003
If you have a table with just a single field of the "OLE Object", you can have them insert as many PDFs, Word documents etc as you want into the table. You can even set them up with a simple form containing a file browser and code behind it to save the selected file into the table to make it easier for them. > I really do not know what I am after :-) I am open for any ideas because I > sure can't think of any... > > Make a folder to store the attachments and they would place them in the > directory? Would it matter if they were .pdf or .doc or any type of file? > > Virginia > > -----Original Message----- > From: Wortz, Charles [mailto:CWortz at tea.state.tx.us] > Sent: Tuesday, March 11, 2003 7:59 AM > To: accessd at databaseadvisors.com > Subject: RE: [AccessD] Adding Attachments > > > Virginia, > > You can have a hyperlink field in a table in which the link to the external > document is placed. Is this what you are after? > > Charles Wortz > Software Development Division > Texas Education Agency > 1701 N. Congress Ave > Austin, TX 78701-1494 > 512-463-9493 > CWortz at tea.state.tx.us > > -----Original Message----- > From: Hollis,Virginia [mailto:HollisVJ at pgdp.usec.com] > Sent: Tuesday 2003 Mar 11 07:51 > To: accessd at databaseadvisors.com > Subject: [AccessD] Adding Attachments > > > Is there a way to add a document as an attachment to a database? > > The database is used to request services. The data is entered by a customer > and sometimes the customer needs to add additional documentation to support > their request. The attachment might be a sketch or Word file. > > Does anyone have any idea how this might be done? > > Virginia > > -- Lexacorp Ltd http://www.lexacorp.com.pg Information Technology Consultancy, Software Development,System Support.