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!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Put Results From Qry into MsgBox

Status
Not open for further replies.
fazm

fazm

MIS
Jun 25, 2003
11
US
Platform: Access 2000
Qry: SQL query within VBA

I want to write a select qry and have the results displayed in a msgbox. Is this possible? Also, can the result be used in another qry. I am gathering that I may need to do this with via recordset, but I dont know how to set that up.

Any help or examples would be great.
 
Status
Not open for further replies.

Similar threads

remeng
  • Locked
  • Question
Getting results from a dynamic dimension array
Replies
2
Views
272
Andrzejek
Andrzejek
remeng
  • Locked
  • Solved
Combine two working macros into one for MS Word 1
Replies
7
Views
507
strongm
strongm
remeng
  • Locked
  • Question
CTRL + BREAK from second macro button
Replies
5
Views
334
strongm
strongm
kris gersbach
  • Locked
  • Question
I’m importing a csv into a vfp curs
Replies
1
Views
135
Andrzejek
Andrzejek
remeng
  • Locked
  • Solved
Run-time error '429': ActiveX component can't create object From Excel to Word
Replies
9
Views
564
remeng
remeng

Part and Inventory Search

Sponsor

Back
Top