Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Recordsets
Try including something like this: ----------------------------------------------------------- 'Set up SQL to query Diagnosis table sDiagSQL = "SELECT Diagnosis.VisitID, Diagnosis.DiagID, Diagnosis.Diag" _ & " FROM Diagnosis, Visits" _ & " WHERE...- ant33
- Post #5
- Forum: Microsoft: Access Modules (VBA Coding)
-
Export to excel issues
Try something like: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8, "Table1", "C:\Temp\Test.xls", True to create the workbook with a worksheet called "Table1", then: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8, "Table2"...- ant33
- Post #2
- Forum: Microsoft: Access Modules (VBA Coding)
-
Autosending Email with Windows NT 4
See thread 'Access and email' of 3Feb03, where answer refers to software to solve your SP2 problem.- ant33
- Post #4
- Forum: Microsoft: Access Modules (VBA Coding)
