Results 1 to 8 of 8
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Texas, USA
    Posts
    374
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Save As path (2002)

    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.

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Save As path (2002)

    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.
    Charlotte

  3. #3
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Texas, USA
    Posts
    374
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Save As path (2002)

    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.

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Save As path (2002)

    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?
    Charlotte

  5. #5
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Texas, USA
    Posts
    374
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Save As path (2002)

    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.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Save As path (2002)

    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.

  7. #7
    Lounger
    Join Date
    Apr 2001
    Location
    Khon Kaen, Thailand
    Posts
    43
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Save As path (2002)

    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.

  8. #8
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Save As path (2002)

    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.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •