Save As path (2002)

Topic

New Reply

cmdOpenApp_Click() will start another application from Access. Is there a way to predefine the Save As location(i.e. path) and name of files created in this application when it is started from Access?

I want to start a scanner application from Access and then want this scanner application to save the scanned file to a particular location automatically. The file name is a value from a field of each record.

Reply | Quote

Replies

Unless you are handling the other application through automation, it would be hard to pass that information to it. Settings like that are handled differently by different applications, so you would need to post more information before anyone could actually help you.

Reply | Quote

Charlotte,

What kind extra information may help?

The scanner is a HP 4400cxi.
I want to save the scanned image to PDF which is one of the many Save As formats available on this scanner.
The saved file name is based on the ID number of the record. For example: 1.pdf. The 1is the ID number of record No. 1.
The saved location is D:image.

Reply | Quote

You implied you were working with another application, which isn’t quite the same as trying to control a scanner from Access. I don’t quite understand what Access has to do with this anyhow. Are you wanting to store the filenames in Access, or what? How are you triggering the scan in the first place?

Reply | Quote

I use cmdOpenApp_Click() on a command button to launch the scanner’s application. Here is the codes:

Private Sub cmdOpenApp_Click()
Dim str As String
str = Chr(34) & Me!txtAppPath & Chr(34) & ” ” & Chr(34) & Me!txtFilePath & Chr(34)
Call Shell(str, 1)
End Sub

I saw other database applications could launch the scanner application from it’s button command and store the scanned file, with a unique file name related to a record, to a location automatically. I want to find out if Access can achieve the same procedure.

As I explained before, I want to store the scanned image, in PDF, by Access. Since it is not advisable to store images inside Access, I plan to use the event procedure to start a scanning prosedure that will store the image in a pre-defined location automatically. Then I can use a comand to view PDF image for each record.

Reply | Quote

You would need an API (application program interface) for your scanner. A quick Google doesn’t yield promising results. Perhaps you can contact HP to ask whether they provide such an API, or know of a third party that does this.

Reply | Quote

Check if you can insert the scanner activex in your form. When you are in Design view of your form, go to Insert menu>ActiveX Controls…>look for the scanner activex and insert it in the form. Then view this post out.

Reply | Quote

If you can use an ActiveX to control the scanner, that is definitely the way to do it. Using Shell launches the application but it doesn’t really give you any control over it.

Reply | Quote