VB Forum / General / October 2005

how can i export the data which is returned in aquery intto an excel
sheet.
Raja

I'm trying to move a VB 6.0 app from the machine it was developed on to
other machines.  The app uses ActiveX controls like DBGrids and progress
bars.  When I try to run it on other machines, I often get the dreaded error
429.  Even more perplexing, I copy the controls onto the ...

Some programmer here made some changes to some dlls (then went on vacation)!
Anyway, what I am seeing is very weird. I got all the code out of source
safe, and compiled a dll. Fine. I compiled a dll that the first dll
referenced. Fine. I went back into the first dll to compile ...

I would like to ask on how to create a pattern file package on spyware.
Using Visual Basic language. Thank you
beginner

This is a followup to my previous post entitled 'Designing an Expert
System'. The purpose is to parse a line of text and determine which is the
best match from a list. In this case I need to parse ingredient lines.
The routine below performs the following tasks:

in my database there is a coulm called snippetlog which contains data
like asdaf/qrrqr/asgjg.txt i want to fetch the last one ( asgjg.txt) how
its possible to fetch that in a column pls reply
raja

I am trying to assign the enter key to work like the tab function on a visual
basic form. In other words, when the user hits the enter key they move from
one control to the next according to the tab order.

I have an ADODB connection to an Access Database. I have the following
command:
SQL = "SELECT * from <table> WHERE ((myfield1 like '%red&') or (myfield2
like '%red&') or (myfield3 like '%red&') or (myfield4 like '%red&') or

Is there a handy way to convert a decimal value to it's equivalent BCD
representation in VB?? I need to send some data to a controller that
expects date data in BCD. For example the month of October (decimal 10)
would be sent as "16" (BCD equivalent of 10).

We have a small shop of 15 users.
I have written a bunch of Visual Basic 6 programs for which we run
Inventory, Order Entry etc.
There are numerous .exe's and some are updated on regular basis.

I am creating an array from multiple recordsets and use the array to
populate an activex control. I need to take that array and populate a
recordset (I don't care how many steps there are from array to recordset) so
I can persist the contents of the recordset to a RDBMS. I have ...

I am writing an app which will use the shell cmd to run a client program on a
mapped drive. This 3rd party program is just a startup program for the actual
application. I need to know when that application has been exited. When the
app start up program ends the shell instance ...

One of the CommandButtons in a VB6 application is used to get the
square of a number. Now what I find is if this button is clicked
repeatedly, after sometime, VB generates the "Overflow" error. How do I
avoid this error? This is what I have done:

   After I execute  a query I obtain more than 60.000 records. I have to
paginate these records: 100 records/page. When I go to my next page I have
to query again so I have to wait again to count these 60.000 records and
then go at the next page. This operation takes me a lot of ...

I have a program that manages a database. It responds to user actions
that affect individual record in the database. One of the functions
involves a bunch of calculations that results in new values to several
fields in that database (straight average, rolling average, weighted