John,
I put the code in the On Open event and only the first query ran. The second query did not run. If I put the code behind a button on the form, both queries run. I added msgbox's to see if it gets past the 1st and second queries but the second msgbox never appears. Below is my code.
Private Sub Form_Open(Cancel As Integer)
' Enable error handler.
On Error GoTo Error_ErrorHandler
DoCmd.SetWarnings False
DoCmd.OpenQuery "qryDeleteAllFromSupervisorTable" 'Deletes all records in the supervisortable
MsgBox "Hi"
DoCmd.OpenQuery "qryAppendSupervisorTable" 'Appends all records from the tblSourcetblSupervisorList table
MsgBox "Hi"
DoCmd.SetWarnings True
Exit_ErrorHandler:
Exit Sub
Error_ErrorHandler:
Resume Exit_ErrorHandler
End Sub
Jim Wagner
On Wednesday, February 5, 2014 8:41 AM, John Viescas <JohnV@msn.com> wrote:
Jim-
AutoExec macro or put code to run the queries in the Load event of the form that you open at startup.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Feb 5, 2014, at 4:00 PM, Jim Wagner <luvmymelody@yahoo.com> wrote:
Hello all,How do I have 2 queries run each time the database is opened. Do I have to use an AutoExec macro or is there another way of programming it?Thank YouJim Wagner
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar