VB Forum / VB Syntax / July 2003

this sql gives me "run time error 3065 cannot execute selected query"
what is wrong?
Dim a As String
a = InputBox("give me date")

Dear Sir,
   I 've ploblem about;
      - Cannot open server explorer view
      - Data Tab missing

I need retrieve Time with miliseconds. Somebody know it.

Is there a way to include standard code in a VB Class
I currently cut and past my error handling methods into each of my VB
Classes.  It is the same for all classes so I have to do this everytime I
create a new class.  That by itself is not a big deal, but if I want to

I've set a Windows Media Player ActiveX Control to play
a .asx playlist file.  What i'd like to know is how to
make it shuffle through the songs rather than play them in
the same order each time the program starts.  Thnx

I am using the standard VB Printer object to output the contents of an
MSFlexgrid to the default printer. The problem I am having occurs when there
are many rows to output and the print job runs onto more than one page. The
first page prints fine but then subsequent pages contain ...

   somewhere while searching through the news group mails i had found a
site which had very usefull code snippets,
one of those example was how an application can detect whether it is being
run from IDE or as an exe, now i cannot find it :-(

can we check somehow if a particular form is currently loaded or not ?
the code which we have is
if not (frm_something is nothing) then
   do this....

How do you create a program that will run as a service instead of a program? I have a program that shut down my computers at 7:30 pm
but you have to login the computer before the program starts. I would like to start the program as a service so you don't have to
login. Is this ...

In a Class is it possible to have static member variables?
I have resorted to creating a static member in a method as a work around.
(see code below)  But it requires me to define an unused state in my
enumeration.

Can anyone tell me if it is possible to get a list of all
the constants that are defined in VB6/Script.  What I
really need are the ADODB ones and the File object but a
complete list would be great.  Can only seem to find for

I have created a component (let's call it CBase) and then created another
component (called CObject) that Implements CBase.
I have another component (called CWorker) that has a public property
(oCaller) of type CBase.

 I'm trying to use MAPI to send an e-mail message
from a VB Exe. When I try to send the e-mail,
I receive an Outlook warning message which indicates
that a software is trying to read Outlook Contacts.

Is there any way to change the caption of a menu(ex:"File") at run-time??
Thank you
--
With best regards

thank you in advance.
This code is a hodge podge of code I borrowed/rearranged/wrote.  If you
have suggestions on ways to make it shorter, cleaner, better, please add
your comments.