VB Forum / Database Access / October 2006

I need my VB6 app be able to write and read the jpeg pictures from the
Access2000 (or later) database by means of ADO. Is it possible?
Or it'd be better to do this by DAO or something else?
Thanks in advance.

I normally write VBA for Access and have done for years but I wanted to make
a simple stand alone application so I have stared on VB 2005.
I can understand it well enough to make simple apps.
My problem is that I cannot get to grips with handling databases.

I'm fairly experienced in general VB development, but this is the first
time I've ever dabbled in databases.  I'm using the DataGrid control in
VB6, to display an ADO database.  The database is very simple - just a
single table, with data in two dimensions.

I'm trying to use VB to insert the values into a table but I got an
error message:
No value given for one or more required paramenteres.
I already set the values for the variables

Suppose i write a clean up routine of ado recordset objects in unload event
then what if the user doesn't close the current form and opens another?

Suppose i instantiate and close a recordset object at command button
(cmdsave) click event and allow the user to save multiple records i.e,
everytime he enters a new record he will click the save button. Is it a good
practice to close the recordset object and then reopen it ...

I am trying to update my database via a query (joins two tables with an
Outer join such that all records from table 1 are visible and details from
table 2 where there is a matching record).
The recordset is filtered such that only one record should be available to

I have a form that's based on a query.  I'm trying to make the form
only accept hours worked if there is a pay rate already entered in
another form.  If not the form will return a message box notifiying the
user that there is no corresponding pay rate for the hours entered,

I have 100s records in a table
i want to print just top 12 records from the table out of 100s records
how can i do this ?
Farooq

The error I get: no value given for one or more required parameters
The variables: table, newfield and text
The lines giving the error: sSQL = "UPDATE " + table + " SET " +
NewField + " = Field7 WHERE Label7 = " + text + ";"

Is there a way to specify database name as app.path at design time in vb6
data environment ?

I presently have the following VB6 code to populate a Combo Box with
all loan numbers from one table.  I now need to restrict these loan
numbers based on whether they satisfy a condition in another table.
How do I do that?

Here's a crazy problem for ya'll!
So I open a recordset using the following:
Set rst = New ADODB.Recordset
rst.Open "SELECT DISTINCT Module From tblLCDData", strConn,

Ok, I have been programming in vb6 for awhile, but now taking a next step to
using Access db.
I have a a db with several tables. I have the datasource and datafields on a
form and bound. I have several fields that I would like to update based on

Does clicking close (X) button on the right side of a form calls unload event?