PeopleSoft Adoption Made Smooth & Simple!
On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool. Claim Your Free WalkMe Account Now
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.
|Conditional Format if Between Dates||9||46|
|Combo box with two columns question||7||40|
|DateSerial Function. I receive "Data mismatch" when adding "Between Date" criteria Expression||3||41|
|who knows to create a script to stop my tool.exe process when i get a type of error 12 times in a row?||2||35|
Join the community of 500,000 technology professionals and ask your questions.