change the color for DBGrid row; Input Validation code help!!

I am at the ending part of coding for a Library software but I am unable to move forward as I can’t figure out the way to change the color for DBGrid row. I am using MsAccess as the database. I want the color of a particular grid row to change its color to say Color. Red through coding that is. Ac ...

Vb6 Dbgrid

What do I want: a list with filtered data (DBGRID), based on klantnummer (TxtTEST123.text). trying with:sQlTekst = "Select BEZOEKEN.DATUM, BEZOEKEN.UUR, BEZOEKEN.CONTACT, BEZOEKEN.INFO, BEZOEKEN.INFORMATIE From BEZOEKEN WHERE BEZOEKEN.KLANTNUMMER = " & Val(TxtTEST123.Text)when starting ...

Recordset - DBGrid - Row Location

How do I make note of the postion of the rows in a DBGrid? By location, I mean the rows showing in the window after scolling down with the scroll bar.After doing another search I would like to use my programed back button to the same window and information without have to scroll down again to the da ...

DbGrid row

I need to chenge the row of the grid, but don't manage to do it? I also cannot insert, the grid is in unbound mode, and I've experiemcied all, allowaddnew,allowupadate....Can you tell me how to work with this ?THANXS ...

DBGRID issue/misunderstanding

I have been using the dbgrid object by assigning a recordset.eg.datagrid1 = RSThe problem I am having is that I allow null dates on my database, which inturn defaults to "1/01/1900".In my dbgrid this particular date column should appear empty if not specifically set to a date.I tried the R ...

VBMyQl + ADOR + remote connection

Happy holidays all;I'm trying to connect an VB-6.0 application to a remote MysQL DB and am running into difficulty. In particular I get an:'Runtime error 3709': Connection cannot be used to perform operation. It may be closed or invalid in this context.'I'm certain the connection string for opening ...

How to create a new row in a dbgrid through code

Hey, new to Delphi, so go easy...I am getting values from the first line of a comma seperated file, and displaying each value in that first line as the headers of my dbgrid. grid.Columns.Add; grid.Columns.Items[iCount].FieldName := sOutput; this seems to work ok.now what I want to do is add the rema ...

dbgrid add row

is it possible to add a row in a dbgrid without a datasource? Werner ...

Error message due to empty row, (VB6-ADO-ACCESS)

Question TWOI have on and off been using Basic, now VB since “the stone age” long before Microsoft and Windows. However it is only now I enter the issue of using VB6 and a database. I use VB6-ADO-ACCESS plus using DataGrid as the main view to see the database. I use 5 tables with some info in on ...

Including a summation row in DBGrid

I have an application which displays 4 columns in a dbgrid. The first coloumn is a text one the rest are numerical. I now have to display the summation of these columns in the last row. This summation is not in the database. I know how to calculate the summation, but I do not know if or how I can in ...

I need the best free dbgrid control for VB6:)

I need the best free dbgrid control for VB6:)I know VBAccelerator Grid control but it seems not to have Datasource property so I cant use it data-bounded mode.If anybody know a grid control for VB6 with filter, nice graphic styles, ect. which can be used in data-bounded mode, and free:),plz help me ...

Selecting a row ina VB6 DataGrid

Iam a VB Programmer and in a fix right now. I have a datagrid control (VB6.0 using ADO)whose data source is a ADOC control thats bound to a table The problem is, I allow the user to search for a string (an item) in the datagrid and when its found , I need to highlight them the row. I donno how this ...

DBGrid bookmarks for starting row

Hi, I'm a newbie at VB and have a question on how to set a bookmark in a DBgrid so it will start my spreadsheet at a different row that the top. I'm using a excel spreadsheet for my information. I sure it's something simple but I can't seem to figure it out. Any help would be Appreciated! ...

DBGrid, which row highlighted

I know this is a simple question but I haven't found anything on the net that addresses it.If I have a DBGrid attached to an ADODC control in Visual Basic that is querying rows from a table, I've highlighted a row, and I want to retrieve the row that is currently highlighted (meaning I want to retri ...

Changing row colors in DBGrid

I am using a DBGrid in my VB6 app. Is there a way that I can change the background color and/or font for specific rows? ...

sperficially delete row in DBGrid

I hve a DBGrid / DBList connected to data control. I'd like to be able to delete some rows showing in DBGrid but not in the database itself, as I'd like to make changes to the remaining data listed. Something like an adress book, where u can deselect recipients but NOT delete them. Anybody has any i ...

VB6 DataBound DBGrid

Thanks for your timely reply My exact problem is i am using databound dbgrid.In the grid allow addnew,allowupdate,allowdelete properties are set true.In the run time while entering the data in the grid, after entering first row ,when i try to enter data for the second row the first row get disappear ...

Bound DBGrid: How find out Row Selection , and one more problem

In Bound DbGrid, a row can be selected by clicking on the First Column ( where it displays '>' ). Now how do i know that a row has been selected? Say i want to allow "Select" btn only after a row has been selected?I Cannot depend on the underlying record set objects current record, ...

problem updating db table after delete row(s) from dbgrid

I have a dbGrid that has databinding to a table RESULT in mssql db, i have these lines of code for removing selected record from table RESULT:DsCompareResults.Tables("RESULT").Rows(Me.BindingContext(DsCompareResults, "RESULT").Position).Delete()SqlDataAdapterCompareResults.Update ...

get other columns from base on selected row in dbgrid

i have a dbgrid with databinding to mssql db table "RESULTS", the dbgrid displays all results that belong to currrent logged in user. the select sql is:SELECT RESULT.STARTTIME, RESULT.ENDTIME, RESULT.TOTALMARKS, RESULT.GRADEFROM TEST INNER JOIN RESULT ON TEST.TID = RESULT.TID INNER JOIN CY ...

how to add row to DBGRID

all. I am using DBGrid1 DataSourse1 Table1 Query1 components to show in DBGrid information from table from database. I set properties: DBGrid1.DataSourse=DataSourse1;DataSourse1.DataSet=Table1;Table1.DatabaseName=myDatabase;Query1.DataSouse=Datasource1;all components has active=true.But there is no ...

Fine row in vb6

I need to find the values for two columns in my table. The first one is a number and I able to find that one alone. I added the second column and it does not seem to work. It is a check box and all I need the function to return is the value of the text box. The values need to be on the same row beca ...

Adding a row (from a Recordset) to another Recordset [VB6]

Similar to a question posted a few days ago, but this time I want to add a row (from a Recordset) to another Recordset.Specifically, I have a recordset (oRecsParts) that has multiple rows with a lot of data (multiple columns, like 20 of them), I want to add each row from oRecsParts into a Recordset ...

Multiple row selects in DBGrid control

How can i select multiple rows in a DBGrid.I am using the DBGrid to display the results from a access query.Now i want to print the user selected records.How can i accomplish this.Thanx and best wishesGopal ...

ROW-00060 I need some informations please !!

I'm Working with ORACLE 8i, IIS and VB6 with AD0.I'm also using the Oracle ODBC driver to be able to work with blobs !Sometimes I receive the error "ROW-00060 : Internal Error : [dahprepare, 1]". I don't know what generate this problem, where it come from and of course I can't solve it...D ...

query does not return actual row updates

We developed an application using VB6 and MS-SQLServer with an OLEDB connection. A client's site on which this application is running experiences some strange database problems. It looks like MSSQL does not always instantaneously updates the database and returns 'old' data. For example: we perform a ...

MySQL Row Cannot be located for updating. Some values might have changed since it was last updated

I've recently migrated from access to mysql with vb6). Unfortunately, i get the following error whenever the .update is executed on the recordset. "Row Cannot be located for updating. Some values might have changed since it was last updated" The select statement is: Select * from tablename ...

Returning number of tables in SQL Server2000 using ADO in VB6

I'm using a VB6 application to access data from an SQL Server 2000 database. There are a few things I would like to do:1. Get the number of tables in the database2. Automatically begin reading data from each table in the database. Is it possible to write some code that will cause the application to ...

vb6-sql server2000 communication

Hi, i have a database sql server2000 and a vb6 application for witk with db. Currently, my db is used for data storage only and an app. performes all operations . I'm trying to change it: to enclose all operations in db and application will only use them. But i really don't know how to do this: i ha ...

SQL2005 Prb1 -Row cannot be located for updating. Some values may have been changed

I recently moved from SQL 2000 to SQL 2005.The client side is vb6 and using Dcom dll's hosted on the db server.I have a table which has oninsert triggerWhen the recordset is updated in the com class it throws the foll error :"Row cannot be located for updating. Some values may have been changed ...

Help a beginer with mySQL+VB6

Please help me!I need some code to connect to a mySQL database with VB6!I olso need to:- add a new row- search the db for a condition- delete a row!Please add lots of comments so i can understand! ...

Row cannot be located for updating

July 22, 2009Hello anyone out there,The table “tblHeading” has only ONE record which I update now and then.With adoHeading.RecordsetDeyt = "As of " & Format(Date, "mmmm dd, yyyy")!hAsof = Deyt!hPrintedBy = "Printed by: " & User!hCompany = CompanyName!hAddress ...

ROW-00060 We need informations

I'm Working with ORACLE, IIS and VB6.I'm also using the Oracle ODBC driver.Sometimes I receive the error "ROW-00060 : Internal Error : [dahprepare, 1]". I don't know what generate this problem, where it come from and of course I can't solve it...Does somebody know about this ?I send the sa ...

Does somebody know about ROW-00060 ?

I'm Working with ORACLE, IIS and VB6.I'm also using the Oracle ODBC driver.Sometimes I receive the error "ROW-00060 : Internal Error : [dahprepare, 1]". I don't know what generate this problem, where it come from and of course I can't solve it...Does somebody know about this ?I send the sa ...

making an invisible row in data grid visible

i m new to ActiveXcontrols. On my property page, i made a database grid i.e. DBGrid derived from class CMsDgridCtrl. suppose 100 row r there in grid. At a time only 10 rows are visible in a grid ,we can see rows after 10 th row by scrolling the grid. Using a combobox i wanna to select a row in a gri ...

C++ Builder 6 - Getting a value from a DBGrid

How can I do the following?I have a DBGrid and I need to get values that grid. When I click on a cell in the grid, I need to get all values in the selected row.If for example there are 3 columns named ID, name and age.If I click a cell in the grid, the value for the Id is displayed in a textbox, the ...

FlexGrid issue and error "Invalid Row value"....

I have used a Flex Grid control in displaying a set of records from the MS ACCESS database (back end) with the means of VB6 code (front end). In my database i have 9 records and the flex grid control has been deisgned at design time with 7 rows. I have full- compiled my code and seen that NO syntax ...

vb6 datagrid

Can anybody help me with the vb6 datagrid error control code.When I click addnew all textboes are cleared and the datagrid sets focus to an empty row but when I decide to click cancel update, I get a msg that "row cannot be inserted,row must have at least one column value set".this is the ...

Does somebody know about ROW-00060 ?

I'm Working with ORACLE 8i, IIS and VB6.I'm also using the Oracle ODBC driver.Sometimes I receive the error "ROW-00060 : Internal Error : [dahprepare, 1]". I don't know what generate this problem, where it come from and of course I can't solve it...Does somebody know about this ?Some, expl ...

ROW-00060 I need some informations please !!

I'm working with Oracle 8i, VB6 and ASP !!Did somebody get this problem : " ROW-00060..."?And why ? ...

delete a row in a excel file

i have opend an excel file with vb6 an d i want to delete a row in the file by clicking a button in vbbut i have no idee how i must do that.can someone help ???? ...

Does somebody know about ROW-00060 ?

I'm Working with ORACLE 8i, IIS and VB6 with AD0.I'm also using the Oracle ODBC driver.Sometimes I receive the error "ROW-00060 : Internal Error : [dahprepare, 1]". I don't know what generate this problem, where it come from and of course I can't solve it...Does somebody know about this ?S ...

how to manipulate DBGrid

Hi,I am new to VB6 and I have displayed records in a DBGrid from access using Data ctrl.I have displayed name and mailid in the grid Now,wen I click on any one record,the particular record shoul get selected and corresponding mailid and name should be displayed in another form.Ten,I wil send mail to ...

Put data into a DataGrid (ADO, ACCESS, VB6)

Question ONEI have on and off been using Basic, now VB since “the stone age” long before Microsoft and Windows. However it is only now I enter the issue of using VB6 and a database. I use VB6-ADO-ACCESS plus using DataGrid as the main view to see the database. I use 5 tables with some info in on ...

ODBC Row cannot be located for updating.

I am getting this error message in VB6 with MySQL 4.1. when trying to update some rows in my table. Most of the rows update fine but some give the error below. The table has a field called invID that is defined as the primary key and is of the type int(11). -2147217864 Row cannot be located for upda ...

mshflexgrid double click error in vb6

I have an mshflexgrid in a vb6 project. Its data source is an adodc object. I use this app to look at a list of batch jobs for our system. The batch jobs can be cancelled, killed, queued, running, etc. If I double click on an item, I can get details of that job and everything works well (It works gr ...

HELP!! How to create Dbase5 dbf in VB6???

I'm trying to create a one-row dBase5 file in plain VB6. I am using DAO but can use other Microsoft libs (don't want to install 3rd-party libs/controls).I'm creating the TableDef on the fly, adding fields.I believe I am missing something to get the RecordSet (underlying dbf file) created.Can someone ...

VB6 can't update access 2k on the web

I am new in this forum so if I make any mistakes please correct me.I have a huge problem with vb6 and MS Access 2k. I can add a new row i I do it on c:\..., but if I do it on my webpage. I get: "Run-time error -2147467259(80004005)" and I have absolut no idea what that means. The code I us ...

Grids available in VB6

Greetings. I am still using VB5 and am limited by the grid functionality, as far as I know, the dbgrid and flexigrid available in vb5 do not provide an easy way to change data in an unbound grid.Can anyone tell me what Grid functionality is available in VB6 ? In particular, does it have a grid that ...

Populate Unbound data DBGrid with one Combo Question?

I have a Master and Detail Tables I want to click teh combo and populate the DBGRID, here is my code, but it does not populate NothingOption ExplicitDim db As DatabaseDim rs As RecordsetConst MaxCol = 5Const MaxRow = 100Dim MyData(MaxCol, MaxRow) As VariantDim sBase As StringPrivate Sub Combo1_Click ...