VB Forum / Database Access / February 2004

I am trying to select a group of records from a database by setting the
record source of a bound data grid to the following statement.  However, I
am getting a "Too Few Parameters" error, but the line works if I use a date
liteal instead of assigning a variable. I need to assign the ...

I'm using MS ACCESS2000 database in my application written in VB.NET.
I created table AUTOS. There is column "MAKE" in it.
In my app I want to find MAKE starting from 'H'
If I use this code:

Im getting some order number from my database, one order can have diferent
product number and size in each so for that ive create exemple for 2
products :
AAAAAAA-A

I've programmed a few database applications using VB 6. The problem is:
When using Access databases they sometimes gets corrupted. While Access can
fix this, the CompactDatabase method doesn't seem to work. I've tried both
DAO (3.6) and RJO. The users of my applications are usually ...

Dear Sir,
In my Table of SalesOrder I am having following Recordset.
OrderNo    OrderDate    ItemCode    OrderQuantity    PendingQuantity
1                01/01/2003    10001        100                    100

I have a very small knowledge of programming. I like it a lot and do
it as a hobby in small personal projects.
Now i'm developping an application to manage the subscribers database
in a local newspaper that I and three friends own.

H
I have created an application that reference the MS DTSPackage object Library and MS ActiveX Data Object Library 2.6. Which files do I need to include for the MS ActiveX Data Object Library 2.6 when creating a deployment package? Also, when I create a deployment package and run ...

I am trying to acomplish the following from VB6 with a SQL query. The query results return the following:
A|10|X
A|20|Y
B|10|Z

I have a Data Report (drTwilightAlpha) that is to display the contents of a
recordset (rscmdTwilightAlpha) through datasource deSVLG and data member
cmdTwilightAlpha.
When the program is first run, the display of rscmdTwilightAlpha is perfect.

I have logitech mouse driver 9.41 in which there is a command as
"Hyperjump". I have assigned it to the middle button. For those who are not
familiar with it, the details :-  on pressing middle button of my mouse, I
get a small window with 9 boxes. One of these 9 boxes has a cross ...

table1 has field field1 as auto numbe
Using a Vb program We delete all data from table table
Then insert new data
Now field1 should get values from 1 onwards every time we do these

The ListView control gives the user the opportunity to set the forecolor for
every ListItems element in the list. But how about the SubItems? Is there a
way to assign properties like ForeColor or Bold to them too?
Thank you,

Hallo everybody,
I need explicit examples of database connections to access and examples of
querys...
Please, send me these examples...

I have a data grid that is bound to an ADO recordsource.  Data appears fine
in the grid, except for the checkbox that I want to appear.
I found where I THOUGHT you specify a checkbox (I right-click on the data
grid, go to properties, click on the FORMAT tab, select the appropriate

I am facing a real difficulty regarding installing and running Foxpro for Windows 2.6 on Windows XP or Windows 2000 machine. It installs fine but when running the application it gives "Divide by Zero or Overflow Error"
Please anybody help me in this regards. My email address is ...