VB Forum / General 2 / August 2004

Need help!!
I need to calculate the difference between a start time in either am
or pm, and an ending time in either am or pm.  Does anyone know of a
way to calculate this so that I can have a final product of _hours and

A friend is using DataReports in a project (I realize there are better
reporting options, however it's his program, not mine), and he's
having a problem with data access.
Mainly that in a DataReport, you cannot access modular or global

Thanks to all those who have helped me over the past few years -- Mike,
Frank, Rick, Ivar, Steve, Don and all the others. Self-taught in VB, working
on my own and with only your help,  I have developed some freeware that I am
now distributing from my website. It is a dream come true ...

In order to export records from an Access 97 data table into a MySQL
table on a local PC, where both tables have the same field names, I
have done the following, which is working well.  However, as may be
seen, some of the procedure has to be written out from the DOS prompt

I think that what I'm trying to do is impossible, but before I give up I
thought I'd try and pick a few more knowledgeable brains than my own.
I have any array of user defined type variables.  I need to loop through the
array (doing certain calculations) on a particular member ...

Can anyone help with calculating exactly the birth date with DateDiff ?

I've developed an application in VB6 that uses Crystal Reporting. I'm
getting the error message "unable to load report" when installing the
app on client pc's as well as when coding and testing within VB.
I originally created the crystal reports in 8.0 but have modified them

Oops!  Forgot a line of code!!!!!  Sorry.  This code example should
display my problem properly.
Why does the finally clause in the Test method (below) NOT execute in
my "foo" example, but DOES execute in my "bar" example?

I was following the instructions in Help to  T, I thought, and pasted this
code into a new project.  However, when I hit the command button, I got an
error that said "Invalid use of New keyword."  Interestingly, I have used
very similar code in a SolidWorks macro and it worked fine. ...

All-
I have the following line that I would like to break up into different
sections:
"08/06/2004 15:24:20 Error Message"

I'm attempting to merge code from two different VB projects into one.
The first project was built with VB 5 and the "Components" window
shows it uses "Microsoft Windows Common Controls 5.0 (SP2)". The
second VB project uses "Microsoft Windows Common Controls 6.0 (SP4)".

All parts of this application is written in VB 6.0.  I have a dll on
the server registered through COM+ and have exported it to a msi
that's been installed on the workstation.  Some of the time, the
workstations run just fine.  Then all of a sudden they aren't able to

Does anyone know how to make one executable if my VB 6.0 project needs
to reference 2 different MS Word Object Libraries?
I'm doing mailmerges into Word Labels (via OpenDataSource command
which uses the Object Library), and I'd like the EXE to run on

I'm a new learner to VB 6.0. I creeated a program  on VB run some test
and have the data save into a predesigned data sheet that was created
on MS Word.
After developing, I made an executable file for the program. And

I have two printers connected to my PC, one USB, and one LPT. I am
trying to print from the VB 6.0 code. It works fine when the printers
are connected. However, when printers are disconnected, or off,  the
program does not return any exception - error message it is supposed