VB Forum / General / December 2006

hi i need help getting a query i created in a tableadapter to fill a
datagridview. the query is this:
select genre.description, title.title_name, title.pages, title.price, title.
sales, title.pubdate

I have created a whole lot of functions in an activex dll, but when I tried
to use them in an Exel 2000 workbook, i could not seem to access them.
What am I missing?
Thank you

I am writing a generic windows form for the medical application.  The form
only contains some text based questions and and checkboxes.
The questions are outsourced to a group of doctors as it relates to medical
stuff and they are to be loaded dynamically.

Hi Experts
How can I use right mouse button down to make a listview selection?
Thanks.

Command btn and Label both have a click event. However label.click is much
slower and easily miss a beat.
Is that a way to make a label respond faster to mouse click.
Thanks.

Private Sub main()
   Dim xDate As Date
   xDate = "01:00:00 am"
   MsgBox Hour(xDate) = "1"

I have a VB form with a spreadsheet on it, and I would like to know how do I
go about printing it. I want to create a button that says print and when I
click it to print it or show the print preview option. Please help me in any
form possible... Thanks.

yet another weird error (my specialty)

I have this almost working but somehow I've recently introduced a new
wrinkle.

Im using a TDBGrid (from ComponentOne) in my VB6 program. I would like
to retrieve a value that's in one of the cells in a row OTHER THAN the
current row (and I don't want to change the current row).
What I'm trying to do is, when the user selects the first cell in a

I have a report that runs 1500 separate reports. No problems. The header for
the report can however, change..so I have created a Word document, stored it
in a directory with the app so that the user can change the header at will,
and I call it thus:

I am using the code from http://www.freevbcode.com/ShowCode.asp?ID=264
to open anapplication.
I have a statement that opens up, in this case, Distiller:
Call Shell("C:\Program Files\Adobe\Acrobat 6.0\Distillr\acrodist.exe")

I know of all the standard methods such as using On Error, CopyMemory or
GetArrayDims api (not sure of exact wording). But someone here posted a
really simple example that was something like
dim x() as long

I want to play some sound using mutimedia contol in vb 6.0. e.g if user
clicks command button then a sound which I specifed, should be played.
OR any other alternative easy way to play a sound on VB 6.0 forms....

I want to open an MDI child on the perticular area but not in full
screen mode, what code should I use? I have not Idea,, plz guide me for
this. or write me a block of code... thanx

how can I connect to sql server 2000 from vb 6.0, also guide me to read
records from any test table and displaying that on my form. consider
that I have two fields (id, name) in my test table... can anyone send
me some block of code for that thanx.