VB Forum / VB Syntax / March 2005

Is there an API call that will make a given window the focus rather than my
app loading but being on the status bar at the bottom of the screen?

I have a little app that is triggered from a third party program.  All it
does is display some data.
If the user doesn't close this app and moves on to another record and then
calls the app again how can I close the first instance?

I'm trying to open a PDF file inside a form but it doesn't seem to work
properly(the application stops responding)... I have registered the ActiveX
which came with Adobe Acrobat Reader 7 and added a control to my form.
Here is the code i used ...

Any idea how to make a combobox case - sensitive in VB.
Let us assume i have a range object in Excel with 2 strings which are
the same but the case is different. Eg: ABC  and abc.
Now i set the row source of the combo to this range object.

Below is the code I have currently:
       Dim SmtpProp As New System.Net.Mail.SmtpClient
       Dim fr, rec, mn, bd As String
       fr = "john@abc.net"

Hi everyone, I'm designing an application which requires me to have a combo
box drop down list that has in it a list of previous 100 years, from 1900 to
2000. Now although I could just manually type them in, I would like the
application to automatically update itself as the years ...

Hi, I want connect the PC serial and paralel I/O to my Microcontroller
who can explain me how is the instruction by VB to do that?
Thank
Paulus Wijaya

Forgive me if this is the wrong group, but I'm not sure which is the correct
group!
I am updating a spreadsheet via VB6 by pasting in the values in a number of
textboxes.  The function is shown below.  I have tried everything I can

I have a project that is connected to a sql server 2K database.  Inside the
db I have udf's that I would like to access from within my vb6 application.  
The udf's work just fine using sql query analyzer but, I can't seem to get
the correct syntax to use them in vb6.  For instance ...

I am using the following syntax to populate a datagrid with the contents of
a recordset
Set dbgSalesAnalysisPC.DataSource = rsSalesAnalysisPC
Problem is nothing is appearing - there is definately data in the recordset

I known VB6 has a SQR function, but is there a function to get an
arbitrary (including fractional) root of a number? Thanks!
Danny
(You guessed it! Remove NOSPAMFOR before emailing.)

Hello Experts,
My application needs me to create a word file from the form itself and store
the same instantly in a SQL Server Database. I am using ADO (Without
Datacontrol)

I sure hope an MS VIP is available for this one!
I am not sure if this belongs in the VB group or if the problem is related
to XP.
I have a VB program (VB6 SP6) distributed to 30 customers. Within the

This is a simple question. I have a label on my form that displays data from
a database field. No problem.
What I want to do is to split this label up, with a first half of the text
in black and a second half...if there is one, in red. The label will be used

I am a C++ developer who wrote a DLL that some VBers are now tryin to use.
Since they are having problems I am tryin to write a VB bas file for them
that declares all the functions and (many) callbacks.
So my question is: how to access the pointer variables in the DLL to assign