VB Forum / VB Syntax / August 2003

Hi
I'd like to know if there's a way to know which form is on
the screen.  I have an MDIform with 5 child forms. I want
to know which one has the focus.  I've used

The program that is being used for now works with ado code
with the same data connections and paths. I can see this
is gonna be a very painful process for me! No default
driver installed? is what I get when executing this code.

I'm using an MS Access form for staff to input employee applicant
information.  I then have Access open Word to pass on the values into
bookmarks in the Word docs that make up the employee application.  All that
works fine.  But when I try and get the Word doc to print and then ...

I need to run a batch file in another directory from VB,
I use the Shell function : Shell(C:\abc.bat,
vbNormalFocus) to do this, but the next line of code
after the Shell function call get execute immediately. Is

I have code that renames some files. Here it is:
Dim strPath As String
Dim objFSO As New Scripting.FileSystemObject
Dim objFolder

I think I should just start from the beginning. I
presently have ado code with a loop searching 1 field from
1 table comparing the record's value and storing the
highest value. Adding 1 to it and displaying it in a

I would like to 'roll up' my splash screen (by making its Height
progressively shorter) and thus allow the next form to become progressively
visible as this happens. To make it work the next form needs to be open and
visible beneath the splash screen before the process begins.

Dim DbQD As New ADODB.Connection
Dim RsQD As New ADODB.Recordset    '*(NO OBJECT USED ON
FORM)*
Dim Dastring As String

Hi i have a CSV file that I want to open in and EXCEl format so I can access
particular cells and ranges:
Dim wkbObj As Workbooks ' Declare an object variable.
Private Sub Command1_Click()

I just had taken a 2 day crash course in sql in hope of
eliminating all my loops with ado code to query records
with sql to an access database back end and a vb6 front
end. If I'm getting a max value of one record I thought

How can I put the max value into a variable or test box in
vb6 after I find it with this sql statement?            
Set RsQD = DbQD.OpenRecordset("SELECT " & "Max(Qe_Number)
as [NewQe], " & "max(Qe_Number)  FROM Extensions ")

I am using code like below to save a binary file to an
image column on Sql Server. The problem is that I am
unable to determine the size of the file before reading
it and now have to process it a byte at a time. Is there

Is there any function that can do the following...
I want to convet an integer to string with 2 digits
precision. For instance i want to convert the number 2 to
the string "02"

I'm able to print out my rich text box using the SelPrint method, but can't
seem to work with the format.  I can't find what properties set the margins,
add title line or any extra lines, find where my document hits the end of
the page (i.e. I'm losing lines of text when it switches ...

hi NG,
i have been trying to use this api to get the correct position of a picture box but with no sucees :-(, i dont think iam doing something right,
below is the code
 With pic_design