Search results

DoCmd.SendObject acSendTable, "tblTicket", acFormatTXT, access_junkie@hotmail.com, , , "tblTicket Records", "Here are the latest tblTicket records." This should send the table in .txt format to one or more recipients. You can change the subject "tblTicket Records", and the body "Here are the...

OK. Then I would add a field to the table called DateEntered (Date/Time data type - default value = Now()) Then... Dim db As DAO.Database Dim rst As DAO.recordset Dim intCount As Integer Set db = CurrentDb Set rst = db.OpenRecordset("SELECT * from tblTicket ORDER BY DateEntered") intCount =...