Using the below code, the ADODB.Recordset object is maintaining a constant state where its RecordCount is -1. I am receiving Invalid Recordset error messages. If I ask whether the returned r...
i have a database and everytime when user tryinig to save a duplicate record , the error mesage should state
you can not save the record, because the record existed
I have :
rs!RecNum=txt...
Using VB6, MS Access 2000, ADO. Used VB Data Form Wizard, Access, linked to the database NE.mdb, used "Single Record" option, ADO Data Control, selected a table called "Students", all records...
Hi folks
I have 2 tables, parent categories and child categories relating to products for an online shop.
Parent Categories Table fields
*Cat_id cat_name
Child Categories Table f...
I wrote the following code for Access 97 where it runs with no problems. However when I brought it into VB5 it didn't like the CDate function in the SQL statement. Giving the error message
...
Hi,
Our user need to send out a well formatted letter via MS Word. Yet, on top of the letter itself, in the middle of the letter to the client, we need to insert a table of data (which is ...
I have an application that uses a MS Access database via Jet 4.0.
1) Which is better to implement, using the AddNew/Delete/Update way or using SQL statements, e.g. INSERT/DELETE/UPDATE to a...
I am just now converting myself to VB.NET from VB6. I am used to querying a database for multiple records and then jumping back and forth through the records using the ADO RecordSet object su...
Question Background
Im developing a POS(Point Of Sales) application. System Design to access several (average 6) POS computers from a BackEnd Computer. Data Including about 40000 products, 15...
I am new to this. My goal is to have an Administor Form where I can changed the Access Datasource of Linked tables. I have a I have an Access Main program that contains a few tables basi...
Hi,
I am using ADO ver 2.0 for connecting to Oracle database in VB. I could open the connection and query the database with this connection. But if the connection lost due to network failur...
I'm fairly new to Access 2007 and VB...I've seen a similar problem on this site, but I believe the accepted solution won't work for me.
As the Title says, I get a Run-time error '3061': T...
Good afternoon!
I have a problem
I have ado control, once again : i know i am not supposed to use it, but !!!!
When I put all info : ConnectionString, CommandType, RecordSource) in ado prop...
Am accessing a crystal report (v8) from a vb6 app. Crystal report querying a sql database. SQL connection criteria set at runtime.
Am able to run the report with no errors from my own PC (vb6...
Visual Basic 6:
I'm using an ADODC to connect to SQL Server and using a
DataGrid to view the recordset. I want to be able to edit the data cells in the grid and can - but only to an extent....
In VB6 using ADO, do you get an error message if you try to close a recordset that is not open?
example:
Dim cn As ADODB.Connection, rs As ADODB.Recordset
Set cn = N...
I have some VB code that is using the CreateParameter method and the Excecute command method to insert records into a MSSQL table. The record inserts okay however a float value is changed. T...
I'm sure I'm over-looking something, but I haven't used SQL Server databases much before. I need to add a record to a table, then get that records AutoIncrement ID. Using ADO and MSAccess, I...
Hello. my question is in regards to the new access database format in 2007. i have a program i wrote and maintain for a local business and it is backended with an access 2000 mdb. i'd like ...
I have a datagrid that is loaded from a SELECT statement in my data environment.
This is loaded at design time, but I want the user to be able to delete a record from the data grid and then...
Hello Experts,
I am trying to pass two parameters to a access query. I am not sure where or how to do this. Para1 & Para2 are the parameters that need to be passed.
Here is the VB code:
...
I want to edit/update any record but it give me error :
Run-time error '2147467259 (80004005)
Insufficient key column information for updating or refreshing.
I have the following code...
I have a table containing e-mail addresses and items. There may be multiple items per person:
Email Item
name1@address.com Item1
name1@addres...
Hello,
I am getting the following: Error 20599, Cannot Open SQL Server. I have a VB6 app with a Crystal Reports control on the main form. Reports are in .rpt files. The data is on a networked...
I'm working in a database where I did not do the coding. I got it from a co-worker who has since left the company. I'm trying to load the data and I am getting a runtime error 94 invalid use...
