We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Private Sub Frame85_Click() Select Case Frame85 Case 1 Dim i As Integer Dim sqlfield As String Call Shell("\\jassrv03\jas-fp$\Documents\filename.bat", vbminimize) DoCmd.RunSQL "Delete * from tbl_sdrive_temptable" sqlfield = "INSERT INTO Tbl_SDrive_TempTable ( Field1 )SELECT Tbl_SDrive_FileNames.Field1 FROM Tbl_SDrive_FileNames" DoCmd.SetWarnings False ' this didn't help but I left the code in as a reference >>>>> This is where the error code happens regardless of the method used when referencing the Tbl_SDrive_FieldNames file on the network>>>>> DoCmd.RunSQL sqlfield DoCmd.OpenQuery "Qry_NotAttachedFiles", acViewNormal, acEdit DoCmd.Close acQuery, "Qry_Notattachedfiles", acSaveYes If IsNull(DLookup("[Document on S Drive]", "No Document Date on File Name (Rename before continuing)")) = False Then DoCmd.OpenQuery "No Document Date on File Name (Rename before continuing)", acViewNormal, acReadOnly Else MsgBox "Import was successful." End If