Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails
Function PrintDigSafePackage() Dim cFile As String Dim RetVal As Long Dim cAction Dim cPrinterName cAction = "printto" cPrinterName = "DPW_MGT - Ricoh MP6000" ' Get files to print Dim rs As DAO.Recordset Set rs = CurrentDb.OpenRecordset("select * from DigSafePackagePrint order by Address, Sort") 'Print Files Do While rs.EOF = False If Len(Dir(rs("FilePath"))) Then cFile = rs!FilePath RetVal = ShellExecute(0, cAction, cFile, cPrinterName, "", 1) End If cFile = "" rs.MoveNext Loop rs.close Set rs = Nothing End Function
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
16 Experts available now in Live!