Populating the new vb table

Would anyone be able to advise how to populate the new table created by vb ..
I have the vb for creating a table which worked great.. now I need to populate them as below :

I need vb to create a few tables.. one is to extract the following fields from the existing table : User, Message but with the additional field Question Mark ..

I either just need it to extract all the messages that contain a question mark or put a yes or no in the question mark field along side the particular message..

The other one I need.. is for a new table to be created by VB and for it to count from the existing table how many users send a message, so the new VB table needs to be populated with user and then the number of messages sent.

I have a query that does that.. can that be connected to the vb ? .. once the vb table has that data I need it to extract the person who sent the maximam messages.

The query is :

SELECT User, count(*) AS [No of messages]
FROM [Message Table]
GROUP BY User;

Can anyone advise on any of the above?

Many thanks
-x-

This depends on where "the vb" is. Based on another post by you, I'm guessing you are trying to create yourself an administrative utility in MS Access for managing your forum posts. If your vb is in Access you can create Append queries, Delete queries, Update queries, and/or Create Table queries and then execute them with docmd in vb.

To create these types of queries in Access, use the wizard or go to the design view of any query and right-mouse-click, look for query type ...

If "the vb" is embeded ASP code on a web page or in a Visual Basic module, you will need to understand how to open and use a recordset object. VB all by itself does not have an autmatic way of getting data from one place to another, you have to write the code to do it. Usually in a recordset loop, one record at a time.

set myrs=(myconnection).openrecordset("SELECT * FROM table")

While not myrs.eof
(insert record into new table)
myrs.movenext
wend

eof means "end of file"

so this statement is saying "while my recordset is not at the end of the file, do something"