VB Forum / General / November 2004

We create querydefs in VB programs (i.e. CreateQueryDef). But as illustrated
below, Access regenerates the SQL code we specify -- particularly the WHERE
clause. While the new code is logically equivalent, it often results in MUCH
slower query performance and this has become a big ...

Can anyone point me in the right direction for the word document model?  I'm
interested in accessing the document title (nb not filename) which appears
when you mouse over in a directory.
TIA,

I want to convert a string to date, my statement is
myDate=CDate("11/1/2004") '1-Nov-2004
it returns 11-Jan-04 although the locale setting is English (United States),
short date format is M/d/yyyy.

Does anyone know of a good resource for in-depth
class architecture?
I am looking for detailed information on how to design with:
CApp

Vague subject line, but didn't know how else to lead into my question.

Using VB6, I have created an ActiveX dll to allow scripting languages
to access the VB Printer Object.  This has been working fine for

Are there events in VB that can run before closing a
project to prompt the developer if Constants are not a
given value?
tod

I need an idea of what I can use to develop a coversheet using VB 6.0.  The
coversheet must be attractive and able to be stored in electronic format for
a long period of time on a hard drive.
I have thought of using a Word template.  My boss does not want to use a

What's best practice to right align numbers when printing.??
Is this something that printer object can do or do I have to format each
string before printing?
Is there an easy way to align decimal values to keep decimal placeholder

I am trying to instantiate an office application with the following code:
Dim PPT As PowerPoint.Application
Set PPT = CreateObject("PowerPoint.Application")
The result:

Hi group
I'm looking for a Date conversion code which could tell me for instance
2100-02-02 is which day, can anyone help me?
thanx alot

When I save a new project, VB6 always defaults to
MyDocuments instead of the directory where I always
put projects, causing me to have to go through the same
clicking routines each time to get to where I want the files.

I must create a routine to print a customer sales quote and having problem
with a section where a rather big string must be devided into several lines
and my problem is to calculate how many character from the big line will fit
nicely on one row before I must go to next row.

I want to open a combo box when the user clicks in the box to type
something in.  
I've searched GoogleGroups for this and keep finding people say it's
done using:

How do you run an executable file from vb (eg. say I wanted to run scan disk
from a vb program or I wanted to run a cleanup utility)

hello group, I'm working in a small application using VB6, the user will
input some data, and I want this data to be appended to an existing excel
file, is it possible to do that ?
thanks in advace for your help