how do i send directly to the print

[miha75]

how do i send directly to the printer a txt file, from microsoft access

 

[GHolden]

One way is to use the ShellExecute function...

'Put this declaration at the top of the module where you want to print

Private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long

'You can then call it from anywhere in the module with

ShellExecute 0&, "print", "C:\Test\Test.txt", vbNullString, vbNullString, vbMinimizedFocus

'You can send the filename as a string variable if you wish

Hope this helps...



There are two ways to write error-free programs; only the third one works.