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.
Dim db As Database Dim db2 As DAO.Database Dim fd As FileDialog, SelectFolderOrFile Dim rstMemberRunningNotes As DAO.Recordset Dim rstTempFieldNotesImport As DAO.Recordset Dim strIHMGNotesID As String Dim strMemberID As String Dim strRunningNote As String Dim strSQL As String ' Dim NewTesttxtFile As String Set db = CurrentDb Set db2 = CurrentDb If MsgBox("This function will update the selected record in the IHMG Notes table. Do you want to continue?", vbYesNo + vbQuestion + vbDefaultButton2) = vbYes Then 'This query deletes any existing records in tblTempFieldNotesImport db.Execute "delqryDeleteRecordFromtblTempFieldNotesImport" 'This query deletes any existing records in tblTEMPORARY db.Execute "delqryDeleteRecordFromTEMPORARYtbl" 'This code imports the selected Excel file into tblTempFieldNotesImport if the file name is different every time Set fd = Application.FileDialog(msoFileDialogFilePicker) With fd .InitialFileName = Environ("userprofile") & "\Documents\" If .Show Then 'This line of code is for an Excel formatted file... DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tblTempFieldNotesImport", .SelectedItems(1), False, "A1:B66"
Join the community of 500,000 technology professionals and ask your questions.