Mike and Doris Manning
mikedorism at ntelos.net
Tue Mar 11 10:23:00 CST 2003
Virginia, Whenever I am looking for information on a particular topic, I have actually found it more useful to do a generic internet search using Google (www.google.com) than to limit myself to the MS KB. Doris Manning Database Administrator Hargrove Inc. www.hargroveinc.com -----Original Message----- From: accessd-admin at databaseadvisors.com [mailto:accessd-admin at databaseadvisors.com] On Behalf Of Hollis,Virginia Sent: Tuesday, March 11, 2003 10:56 AM To: 'accessd at databaseadvisors.com' Subject: RE: [AccessD] Adding Attachments Can you direct me to where I can find information on how to use the Common Dialog control? I searched help & MS knowledge base, but I could not find anything that tells how to make it work. I have never used any of the ActiveX items under More Controls, for that reason - never know what to do with them. Virginia -----Original Message----- From: Mike and Doris Manning [mailto:mikedorism at ntelos.net] Sent: Tuesday, March 11, 2003 9:25 AM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Adding Attachments Virginia, What I did was use the Common Dialog control (you can also use File Dialog but it won't work in a runtime app) to allow the user to pick the current location of the file. Then I move a copy of it into a designated folder path and store the full pathname (path and file name) in a database string field. Doris Manning Database Administrator Hargrove Inc. www.hargroveinc.com -----Original Message----- From: accessd-admin at databaseadvisors.com [mailto:accessd-admin at databaseadvisors.com] On Behalf Of Hollis,Virginia Sent: Tuesday, March 11, 2003 10:12 AM To: 'accessd at databaseadvisors.com' Subject: RE: [AccessD] Adding Attachments Do you know if there is a way to default the hyperlink to use "relative path to hyperlink"? It always wants to use http:\\ for the hyperlink instead of the path. I set the Base to the directory and folder. I set a field to Hyperlink, I was hoping that all the customer would have to do is type the name of the document into the field (Test Attach.doc) and it would open the hyperlink to the document. Is this correct? What am I missing? ************ The archives only show the past 3 months, how do you get to the previous messages? Virginia -----Original Message----- From: Wortz, Charles [mailto:CWortz at tea.state.tx.us] Sent: Tuesday, March 11, 2003 8:23 AM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Adding Attachments Virginia, Since you are storing the files externally to Access and only storing a link (path name) to the files in Access, it makes no difference to Access what types of files they are. Linking to external files is a frequent subject on this list so you should be able to find a lot of hints in the archives. Some non-obvious search terms that may help are "Image files" and "bloat." 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 08:13 To: 'accessd at databaseadvisors.com' Subject: RE: [AccessD] Adding Attachments 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 -----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 -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030311/696cd374/attachment-0001.html>