Send Keys in windows folder

[murray83]

Afternoon

i am trying to get send keys to move down to a specific location in a folder onced its been opened from the form in access

but all it seems to do is open many, many windows of the folder

here is my code so far, have seen about wait but dosent pop up when typing

Private Sub cmd_AddPrinter_Click()
'opens up folder so you can easiley add zebra printer

Dim Foldername As String
Foldername = "\\d002win0003"

Shell "C:\WINDOWS\explorer.exe """ & Foldername & "", vbNormalFocus

'SendKeys "Down 6"
'SendKeys "Left 3"

End Sub

 

[Minty]

This sounds highly problematic, what happens if there are unexpected files or folders in the target?

Why can't you specify the file or folder name explicitly?

 

[murray83]

This sounds highly problematic, what happens if there are unexpected files or folders in the target?

Why can't you specify the file or folder name explicitly?

the folder is full of printers and i'm wanting to try and automate connecting to that printer (its not a normal a3 or a4 paper printer) for printing from database as not everybody is savvy on how to do it

so could i just include the printer name in the string ???

 

[Minty]

A report in Access can be saved with a specific printer as part of it's properties.
Provided that printer is available on the end user machine it will be used.

Does that help?

 

[isladogs]

Best to avoid SendKeys altogether.
Code that works in one version of Access may fail in another.

 

[murray83]

A report in Access can be saved with a specific printer as part of it's properties.
Provided that printer is available on the end user machine it will be used.

Does that help?

Yes

would i define it some where or is it in the options in the property sheet

 

[Minty]

It's part of the page setup option in the report. In the dialog box that pops up you can set either
"Default Printer" or
"Use Specific Printer"

Once set it "Stays put" as an option.