Message Box to Display Results of a Query

dcrosier · Feb 27, 2001

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&quot

The above is where I am thinking, I just need help on passing the query result into the message box.

Thanks.
Dawn

dsi · Feb 27, 2001

Just concatenate a string for the Prompt:

Code:

Dim sTmp As String

sTmp = &quot;Total Items Checked Out: &quot; & qryResult1 & vbcrlf & _
       &quot;Total Items Late: &quot; & qryResult2

MsgBox (sTmp, vbOkOnly, &quot;Late Equipment&quot;)

DimensionalSolutions@Core.com

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Message Box to Display Results of a Query

dcrosier

Instructor

dsi

Programmer

Similar threads

Part and Inventory Search

Sponsor