VB Forum / Database Access / February 2005

VB 6.0 SP5 using access via the jet provider.
I need to develop a strategy for dates. When I set up a new record using a
form (recordset.addnew) all of the date fields are set to null and all of
the text boxes bound to them are blank. This is fine untill somebody puts a

Does anyone know how to write a procedure in VB6 for a barcodescanner. I
cannot automize the reading to processing. PE I can make de reading of the
barcode, but i cannot make a search in a database without a button or
something like that to continue the process. I want to read ...

Error: couldn't find installable ISAM
This occurs when a vb5 app using jet 3.51, trying to use an excel
spreadsheet,  was moved to a new machine.
knowledgebas article 257819 says jet 3.51 doesn't have ISAM drivers, yet the

Getting the error message when updating a record.
         "Error -2147217864 Row cannot be located for Updating. Some values
may have been changed since it was last read."
Doesn't happen all the time, just sometimes. If I update one record and then

I'm struglling to find info on refreshing a datagrid, I'm using Sql server,
the datagrid is based on several tables, when changes have been made to the
data (NOT DONE WITHIN THE DATAGRID ITSELF - only used for viewing and
selecting purposes) I want to be able to refresh the ...

It's possible to terminate a store procedure run by ADO?
Particularly I have run it as:
 cn.execute "xp_cmdshell 'program.exe'", , adAsyncExecute

my  ADO VB.net program is able to populate all types of Data except Image,
any Idea as how Picture are being inserted to a record via Vb.net?  ... thanks

I need some VB or SQL coding to finish up an access database program.  I am
trying to choose selected records from an access table based on certain
criteria.  Example:  2 records needed out of 4 total records and the code
should choose the 2 records with the lowest value amount in ...

We want to put the whole paramarray cellset to an array.
Is this possible in VB. Please correct and advise and
assume the connection and sourcecode is correct.
Something like:

I create a database using  DAO with one table.
After that my app. stores data to this table.
But i need a sorted table to work with. Now i'am using a query, but with
about 4,000,000 records

I am using VB 6, NOT VB NET. Reference: MS DAO 3.6 Object Library
Below is the Sub-Routine. At this point of code, I have the Recordset open
and I am trying to extract the data. The db fields are named
Wk1g1Visitor,WK1g1Home,Wk1g2Visitor,WK1g2Home, Wk1g3Visitor,WK1g3Home, etc.

I'm trying to write an application where a user either modifies an existing
database, or creates a new one - his/her choice.  If the user wants to modify
a database I have him select one using the Open Dialog - but the app writes a
copy to a temp folder. I open a connection to ...

Hello friends, I could not find this with some searching so I thought I
would ask.  I am currently working on an application in vb .net that
displays information from a database and has images included with the
entries.  I am looking for a database solution to fit these needs:

Can I anywhere find new visual basic (full version) for free download. I
would use it for education purpose.
thanks

My VB 6 application needs to print a report in an Access 2002 database.
This was working fine when I used Access 97 but now the application
quits without any errors on the DoCmd.OpenReport line.  I have my VB
application references set to access 10.0.  Without any errors I cannot