Is there anyway to scan documents and save them in an Access table? As of now we scan them and save them to a folder on the network. Then go into Access form to add them into the tables. Would like to automate this process all from Access but have know idea how to go about this. Any suggestions?
Scan documents into table
- Thread starter AnnPhil
- Start date
Rabbie
Super Moderator
- Local time
- Today, 11:54
- Joined
- Jul 10, 2007
- Messages
- 5,906
Can you give us a little more detail please. When you scan the documents are you storing them as images or are you using OCR to store them as text files? Are you wanting to store the data in the Access tables or are you just storing a link to the scan files?
We will be storing them as images
They want to store the images in the Access tables, however i think this will slow down the database so i would like to have a link stored in the tables. Is there a way to make this a one step process? Right now they scan the document in a folder on the network and then they have to open the the database and add the file name to the table. Then i have a form that they can select the pdf file and it runs code to open an view the document stored on the network.
Private Sub cmdOpenPDF_Click()
Dim strAcPath As String
Dim strFName As String
Dim strFilePath As String
If IsNull(Me.cboPDF) = True Then
MsgBox "Please select a PDF from the list", vbCritical, "Selection Error"
cboPDF.SetFocus
Else
strFName = Me.cboPDF.Column(1)
strAcPath = Me.ReaderLocation
strFilePath = Me.PDF_FilePath
Call Shell(strAcPath & " " & [strFilePath] & [strFName] & ".pdf", vbMaximizedFocus)
End If
End Sub
They want to be able to scan the document and save in a table from within Access. Not sure how to do this.
Thanks for any suggestions
They want to store the images in the Access tables, however i think this will slow down the database so i would like to have a link stored in the tables. Is there a way to make this a one step process? Right now they scan the document in a folder on the network and then they have to open the the database and add the file name to the table. Then i have a form that they can select the pdf file and it runs code to open an view the document stored on the network.
Private Sub cmdOpenPDF_Click()
Dim strAcPath As String
Dim strFName As String
Dim strFilePath As String
If IsNull(Me.cboPDF) = True Then
MsgBox "Please select a PDF from the list", vbCritical, "Selection Error"
cboPDF.SetFocus
Else
strFName = Me.cboPDF.Column(1)
strAcPath = Me.ReaderLocation
strFilePath = Me.PDF_FilePath
Call Shell(strAcPath & " " & [strFilePath] & [strFName] & ".pdf", vbMaximizedFocus)
End If
End Sub
They want to be able to scan the document and save in a table from within Access. Not sure how to do this.
Thanks for any suggestions
- Local time
- Today, 05:54
- Joined
- Feb 28, 2001
- Messages
- 30,336
Look up Access Help for "File System Object" - as a way for Access to search the contents of a folder to find a specific file type.
I have a way for my vacation digital photos to be located and linked in a home database. The File System Object makes scanning easy - but you need to be able to use VBA to do it. If you choose to go this route, you will need to read up on the following items:
File System Objects - to find files
Image Controls - to display pictures
Form_Current event - load the image-file specification to the .PICTURE property of the image control when you change images.
I concur with your choice to link rather than directly store a given image.
I have a way for my vacation digital photos to be located and linked in a home database. The File System Object makes scanning easy - but you need to be able to use VBA to do it. If you choose to go this route, you will need to read up on the following items:
File System Objects - to find files
Image Controls - to display pictures
Form_Current event - load the image-file specification to the .PICTURE property of the image control when you change images.
I concur with your choice to link rather than directly store a given image.
