FuzMic
DataBase Tinker
- Local time
- Today, 20:08
- Joined
- Sep 13, 2006
- Messages
- 719
Hi gurus
I use the following coding to BeginTrans > CommitTrans > RollBack to print a report from Tabloid from data in the BackEnd to a LAN printer.
Due to my limited knowledge
Grand Thank You first
Sub DoReport()
Dim ws As DAO.Workspace
DoReport = False
Set ws = DBEngine.Workspaces(0)
ws.BeginTrans
Docmd.openreport "ReportA", acNormal
ws.CommitTrans
DoReport = True
Trans_Exit:
Set ws = Nothing
Exit Sub
RErr:
If Not DoReport Then
ws.Rollback
End If
Resume Trans_Exit
end sub
I use the following coding to BeginTrans > CommitTrans > RollBack to print a report from Tabloid from data in the BackEnd to a LAN printer.
Due to my limited knowledge
- I would like to know the interaction between the Tabloid and the LAN printer
- Is there any point to use this cycle for printing of the data in the Back End mdb.
- How the buffer of the printer come into the process?
- Any views on my codes
Grand Thank You first
Sub DoReport()
Dim ws As DAO.Workspace
DoReport = False
Set ws = DBEngine.Workspaces(0)
ws.BeginTrans
Docmd.openreport "ReportA", acNormal
ws.CommitTrans
DoReport = True
Trans_Exit:
Set ws = Nothing
Exit Sub
RErr:
If Not DoReport Then
ws.Rollback
End If
Resume Trans_Exit
end sub