Query results to message box
 

Does anyone have guideance on putting query results, by
row, into a message box?

THANKS!!

Query results to message box
 

It sounds like a bad idea. Why not write it to a worksheet or use a useform
and put it in a listbox.

--
Regards,
Tom Ogilvy

"noel" wrote in message
...
Does anyone have guideance on putting query results, by
row, into a message box?

THANKS!!

Query results to message box
 

OK if a UserForm would work better, then how would you gqt
the query results into the form?
-----Original Message-----
It sounds like a bad idea. Why not write it to a
worksheet or use a useform
and put it in a listbox.

--
Regards,
Tom Ogilvy

"noel" wrote in
message
...
Does anyone have guideance on putting query results, by
row, into a message box?

THANKS!!


.

Query results to message box
 

see answer to you next posting.

--
Regards,
Tom Ogilvy

wrote in message
...
OK if a UserForm would work better, then how would you gqt
the query results into the form?
-----Original Message-----
It sounds like a bad idea. Why not write it to a
worksheet or use a useform
and put it in a listbox.

--
Regards,
Tom Ogilvy

"noel" wrote in
message
...
Does anyone have guideance on putting query results, by
row, into a message box?

THANKS!!


.

Query results to message box
 

"Tom Ogilvy" wrote ...

It sounds like a bad idea. Why not write it to a worksheet or use a useform
and put it in a listbox.

Agreed. But if the results set is small and the OP is using an ADO
recordset, the GetString method would do the job nicely.

Jamie.

--