Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Function MakeData() Dim StrSQL As String Dim db As Database 'Current database. Dim lng As Long 'Loop controller. Dim rs As DAO.Recordset 'Table to append to. Dim lng1 As Long 'Loop controller. Dim rs1 As DAO.Recordset 'Table to append from. Dim ACCOUNT As String Dim YEAR As String Dim USER As String Dim REPEAT As Integer Dim TYPEREC As String 'StrSQL = "Delete * from tblPrint where user =" & fOSUserName() & ";" 'DoCmd.SetWarnings False 'DoCmd.RunSQL StrSQL 'DoCmd.SetWarnings True Set db = DBEngine(0)(0) Set rs1 = db.OpenRecordset("select * from ppPidList2 ;") Set rs = db.OpenRecordset("tblPrint", dbOpenDynaset, dbAppendOnly) Do While Not rs1.EOF ACCOUNT = rs1!ACCOUNT YEAR = rs1!YEAR USER = rs1!USER REPEAT = rs1!REPEAT TYPEREC = rs1!TYPE Set rs = db.OpenRecordset("tblPrint", dbOpenDynaset, dbAppendOnly) With rs For lng = 1 To REPEAT .AddNew !ACCOUNT = ACCOUNT !YEAR = YEAR !USER = USER !TYPE = TYPEREC .Update Next End With rs.Close Loop Set rs = Nothing Set db = Nothing Set rs1 = Nothing Set db = Nothing End Function
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.