Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.
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
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.