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
|
|||
|
|||
scan a document to insert into access 2003 database field
I have database cards with both text and drawings. In Access 2003 I want to
set up a data base with some fields that I name and enter the data myself, then in another field I want to insert a scan of the manual data cards. Do I scan these and store them as a separate document. In the database field what do I type to create a parth to that document. Ideally when I do a table query I want it to be able to bring up the record and to show the scanned data card relating to the information in the fields I typed. Or do I insert the scanned document direct into the data field and how? Thanks for any help -- compmail always learning |
#2
|
|||
|
|||
scan a document to insert into access 2003 database field
As you described, put the image file into a separate folder, and store the
path and file name in one or two text fields. You'll be viewing the image in forms and reports, not a query. Previous posts have covered the details on how to do this. Hope that helps Fred "compmail" wrote: I have database cards with both text and drawings. In Access 2003 I want to set up a data base with some fields that I name and enter the data myself, then in another field I want to insert a scan of the manual data cards. Do I scan these and store them as a separate document. In the database field what do I type to create a parth to that document. Ideally when I do a table query I want it to be able to bring up the record and to show the scanned data card relating to the information in the fields I typed. Or do I insert the scanned document direct into the data field and how? Thanks for any help -- compmail always learning |
Thread Tools | |
Display Modes | |
|
|