Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Query results to message box

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

THANKS!!
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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!!



  #3   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default 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!!



.

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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!!



.



  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 593
Default 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.

--
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Minus Key Results in EXT Message in Status Bar cphalen Excel Discussion (Misc queries) 8 November 19th 08 09:11 PM
Format results in Message Box Jim G Excel Discussion (Misc queries) 3 February 28th 07 12:03 AM
Find across several sheets and put results in a message box cdb Excel Programming 2 July 2nd 04 11:00 AM
Set a PivotCache as the results of a query tod Excel Programming 2 February 16th 04 05:41 PM
Query Results Michael Burkett Excel Programming 1 November 11th 03 07:46 PM


All times are GMT +1. The time now is 11:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"