VB Forum / VB Syntax / June 2005

SEE CODE BELOW
THE SQL STATEMENT BELOW IS NOT WORKING. I'M CONNECTING TO A MS ACCESS
DATABASE. I HAVE SET CHECK1 AS MY SEARCH TEXT, BUT THE SQL STATEMENT WILL NOT
RECOGNIZE IT. ANY IDEAS ON THE CORRECT SYNTAX OF THAT 3RD LINE?

   I'm using VB6 and Access 2002. I've been unsuccessful in creatinf a new
Access database from code. Can someone point the way for me?
Thanks alot in advance.
J

My form contains some activeX objects (xy-graph written in VC++) , when I use
form.PrintForm method it prints everything but those activeX objects. Is
there any way to print them. In VC++  device content is used for printing, VB
form has hDC property, can I use it to get complete ...

can anyone tell me how much the visual source safe cost?
thank you!

I have got a problem. I have got two excel file. I have written the
following code in one file.
Sub Product_Development()
   Set wBook = Workbooks("Internal_funnel_jun27.xls")

   I'm using VB6 and Access 2000. I need to create a text file that I could
open and execute from my app at run-time. Could someone point me in the
right direction?
Thanks

My problem is that I am filling a listbox from data in a textfile.  I put
the data from the text file into a multidimensional array.
Then I take the first element and put it into the listbox by AddItem.
I have set Sort to True on the listbox.

http://support.microsoft.com/?id=896559
FIX: The Windows Common Controls Mscomctl.ocx or Comctl32.ocx may cause your
application or the Visual Basic 6 IDE to unexpectedly quit, or you may
receive a "Divide By Zero" error message.

hi there,
i am trying to Execute some command Bar Button i can change if there
Visible, Enabled and Caption of them but i can't Execute them and i don;t
know why is it becuase i am using VB.net and the COM add-in dll uses VB 6??

i am new to Visual Basic and I am trying to make some macros for automated
dictionary reversing. What I must do is find all ranges between characters
"=" and "\" , and then clear them including ending sign "\". I tried few
methods and it always turns out wrong.

Dear Experts,
I have logged in a user and now i would like to check the period of
inactivity so that i can log him out. Could you please suggest the best
method - the following is my plan but i am not sure:

how to make word wrap property to rich text box

Dear Experts
i have populated a treeview control using do while loop from database. All
the Nodes Major and Minor Contracted. Please can you tell how can i expand
the nodes? Would much appreciate your help

I am exporting data from SQL to a Excel Spreadsheet through a VB
Application.  This code works well.  I need to format the columns.  I found
this piece of code that appears to be the correct VB syntax:
CType(.Cells(1, "A"),

I am making a program in VB6 and I want to know, how do I play a sound...
otehr than the Beep. Could someone please hemlp me with this, as I would
greatly appreciate it.