Message Box to Display Results of a Query
Message Box to Display Results of a Query
(OP)
I would like to create a Message Box that will display the results to two seperate queries. Could someone help me with the syntex? Both Queries are Counts of records based on criteria.
I will be attaching the msgbox to the OnOpen Event of the Switchboard in Access 2000.
msgbox ("Total Items Checked Out: qryResult1 Total Items Late: qryResult2", vbOkOnly, "Late Equipment")
The above is where I am thinking, I just need help on passing the query result into the message box.
Thanks.
Dawn
I will be attaching the msgbox to the OnOpen Event of the Switchboard in Access 2000.
msgbox ("Total Items Checked Out: qryResult1 Total Items Late: qryResult2", vbOkOnly, "Late Equipment")
The above is where I am thinking, I just need help on passing the query result into the message box.
Thanks.
Dawn
RE: Message Box to Display Results of a Query
Dim sTmp As String
sTmp = "Total Items Checked Out: " & qryResult1 & vbcrlf & _
"Total Items Late: " & qryResult2
MsgBox (sTmp, vbOkOnly, "Late Equipment")
DimensionalSolutions@Core.com