If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Is there a control for attaching a file to a record?
I am using Access 2003 . I want to browse for a file and attach the file to
the record. For eg. details of a student in the .doc file should be browsed and attached to that perticular student concern.When I click on the button/Image in the form, I want to open a dialog box where i could browse for a file and then the file should be attached to a field in the database. |
#2
|
|||
|
|||
Is there a control for attaching a file to a record?
You could use the ActiveX Common Dialog control, but ActiveX controls are not
worth the trouble they cause. Here is a link to an API alternative that is very easy to use. Also, you should use a Hyperlink type field to store the path and name of the document. "Anand Vaidya" wrote: I am using Access 2003 . I want to browse for a file and attach the file to the record. For eg. details of a student in the .doc file should be browsed and attached to that perticular student concern.When I click on the button/Image in the form, I want to open a dialog box where i could browse for a file and then the file should be attached to a field in the database. |
#3
|
|||
|
|||
Is there a control for attaching a file to a record?
Looks like Klatuu forgot to give you the link, but I'm sure he meant
http://www.mvps.org/access/api/api0001.htm -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Klatuu" wrote in message ... You could use the ActiveX Common Dialog control, but ActiveX controls are not worth the trouble they cause. Here is a link to an API alternative that is very easy to use. Also, you should use a Hyperlink type field to store the path and name of the document. "Anand Vaidya" wrote: I am using Access 2003 . I want to browse for a file and attach the file to the record. For eg. details of a student in the .doc file should be browsed and attached to that perticular student concern.When I click on the button/Image in the form, I want to open a dialog box where i could browse for a file and then the file should be attached to a field in the database. |
#4
|
|||
|
|||
Is there a control for attaching a file to a record?
Thanks, Douglas. I have Copy down pretty good. Obviously I need some work on
the Paste part. "Douglas J. Steele" wrote: Looks like Klatuu forgot to give you the link, but I'm sure he meant http://www.mvps.org/access/api/api0001.htm -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Klatuu" wrote in message ... You could use the ActiveX Common Dialog control, but ActiveX controls are not worth the trouble they cause. Here is a link to an API alternative that is very easy to use. Also, you should use a Hyperlink type field to store the path and name of the document. "Anand Vaidya" wrote: I am using Access 2003 . I want to browse for a file and attach the file to the record. For eg. details of a student in the .doc file should be browsed and attached to that perticular student concern.When I click on the button/Image in the form, I want to open a dialog box where i could browse for a file and then the file should be attached to a field in the database. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
If I buy Microsoft office, will I be able to open my old files on | laurelek | General Discussions | 3 | February 13th, 2009 02:56 PM |
Need Help In Printing Current Record in Specific Report | RNUSZ@OKDPS | Setting Up & Running Reports | 1 | May 16th, 2005 09:06 PM |
.jpg .gif .bmp file associations gone, upgrade from Office XP to 2 | fbartrom | Setup, Installing & Configuration | 13 | February 25th, 2005 01:33 PM |
Access Calendar | lost | General Discussion | 2 | July 7th, 2004 04:58 AM |
Form Doesn't Go To New Record | Steve | New Users | 15 | May 16th, 2004 04:33 PM |