PLease any idea how fix this problem with Quickscan in Access

[christ2000]

Hello I am trying to use the application name quickscan.exe from Burrotech. to allow me scan directly several pages in my data base but I cant do that the application take the name of the documents from my vba code. here is the code I use, any idea or some know how figure out this? Thanks in advance

Private Sub Command493_Click()
Dim Filepath As String


Dim CName As String
CName = Forms![ContractorsDBForm]![Text442]
filename = Me.DocumentsName & ".pdf"
Filepath = DLookup("[ContractorPath]", "querysetup") & CName & DLookup("[expr1]", "querysetup")
Shell CurrentProject.Path & "\quickscan.exe resolution 100 pdf showprogress " & Filepath & "filename "
End Sub


when I use the following code, the application scan but put the documents just in the folder predetermined by code

PrivateSub Button27_Click()
Shell CurrentProject.Path &"\quickscan.exe resolution 100 pdf showprogress filename "& CurrentProject.Path &"\scan\ScanN¹""23.pdf "
EndSub

[RuralGuy]

Did you expect this: [\scan\ScanN¹""23.pdf] to place a double quote in the file name?

[christ2000]

Hello, ok that expect is to get the folder destination path from: FILEPATH string and the Document Name from FILENAME string

thanks

[RuralGuy]

This code: Shell CurrentProject.Path & "\quickscan.exe resolution 100 pdf showprogress " & Filepath & "filename "
...has a better chance but it also has problems.
Try:
Shell CurrentProject.Path & "\quickscan.exe resolution 100 pdf showprogress " & Filepath & filename

[christ2000]

thanks but nothing work. Do you know any other thing that allow me scan documents as pdf in ms access?

thanks

[Perceptus]

Change

 Shell CurrentProject.
Path 
&
"\quickscan.exe resolution 100 pdf showprogress filename "
&
 CurrentProject
.
Path 
&
"\scan\ScanN¹"
"23.pdf "

"\quickscan.exe resolution 100 pdf showprogress filename "



to

 Debug.print CurrentProject.Path &
 &
 CurrentProject
.
Path 
&
"\scan\ScanN¹"
"23.pdf

What does output look like?

Do you have a functional command line that you can execute yourself in the command prompt?

[Perceptus]

wow it murdered my code twice... replace Shell with Debug.Print

[christ2000]

Hello, i changed to Debug.Print but noting happened. let me explain if I use the code:

Shell CurrentProject
.
Path 
&
"\quickscan.exe resolution 100 pdf showprogress filename "
&
 CurrentProject
.
Path 
&
"\scan\ScanN¹"
"23.pdf "

the system scan ok, it create on same folder, a folder name scan and name the pdf document as

ScanN¹23.pdf

the problem is when I input the string values, it doesn't recognized the path or default filename

[Perceptus]

Change your

Shell CurrentProject.Path & "\quickscan.exe resolution 100 pdf showprogress filename " & CurrentProject.Path &"\scan\ScanN¹""23.pdf "

to

Debug.print

CurrentProject.Path & "\quickscan.exe resolution 100 pdf showprogress filename " & CurrentProject.Path &"\scan\ScanN¹""23.pdf "

Then in the Immediate Window (Ctrl + G), when you run that code. it should have something that outputs there. what is it?

[christ2000]

Ok show this:

C:\ClientsDB\SBPM\quickscan.exe resolution 100 pdf showprogress filename C:\ClientsDB\SBPM\scan\ScanN?"23.pdf

[Perceptus]

Excellent, Press Windows Key + R

Copy and paste that into it, or try pasting that into a command prompt. does it work? I imagine it breaks on the quote.

[christ2000]

Yes it work. so?

[christ2000]

I think there is another problem, following your recomendation i get the correct path using the STRINGS but the program keep puting the pdf on same folder were the .exe is

no i got my parameters correct using the as strings:

C:\ClientsDB\SBPM\quickscan.exe resolution 100 pdf showprogress filename C:\ClientsDB\SBPM\Alain, Tom\Alain, Tom Car Registration.pdf
C:\ClientsDB\SBPM\quickscan.exe resolution 100 pdf showprogress filename C:\ClientsDB\SBPM\Alain, Tom\Alain, Tom Car Insurance.pdf

[orange]

christ2000,

Is it now working as you want?
If it is outputting the file correctly, but in the wrong folder, you could run as second routine to move or copy the file to the folder you define. It would have to run after the "scan" had finished.

[christ2000]

hello, just work in part, form example file is just save as:

Alain, and not as

Alain, Tom Car Registration.pdf as debug print show
thanks