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. Actually this is to be executed after lapse of a particular date. There can be N number of rows, but I want only that particular row whose date has crossed the dateline turn to red(background color or show a message for that row). Also I am doing input validation check, what would be the best way for
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 the program the DBGRID remains empty. When entering fixed data for example ("1250") the correct data will we displayed.Who can help me to overcome those sleepless nightes?
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 data I was looking at before I did the second search.I do not have unique id's.
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
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 RS update prior to the dbgrid assignment and found all the rows on my table were updated ( does this mean that a rs is bound to a database if it has adlockOptimistic ? )I did not try adlockReadOnly to change the RecordSet without harming the Database?I thought I was on the wrong track?Next I tried to
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 the recordset is the problem, however, i've been unable to configure a string that will connect to the remote server..Below is my code:Private Sub Form_Load() dbGrid.Visible = False Set conn = New MYSQL_CONNECTION conn.OpenConnection "url_to_server", "my_user_name", "my_pass
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 remaining lines of the CSV as data to this dbgrid.So what I need to know how to do, is create a new row.Any help or links would be awsome.
is it possible to add a row in a dbgrid without a datasource? Werner
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 one table to be used in another. Hope it is OK to ask few questions but will put them one by one:2. I have a button that with the code: DataList.Recordset.AddNewBut if I do not want to fill in the info in runtime I get an error message: "Empty row cannot be inserted.Row must have at least one col
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 include this summation information in the dbgrid. Can someone please tell me if this is possible in the first place?
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
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 can be done. Someone, please help.
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!
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 retrieve all the data elements from the Recordset), what do I need to do?Thank you. I'll only ask this once, I promise!- killRoy
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?
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 ideas? I'm using vb6, & DAO . Thx.
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 disappeared . but in the table we can see the first row (it got saved) but it is not visible in the grid. please help me,it is very urgent.
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, because there will be a valid record even if i click on any of the columns. ANd i Dont want to set the mode to select the entire row on click anywhere .2. MSDN Docs say SelStartRow and SelEndRow are defined for DBGrid. But i dont see those properties in a bound DBGrid. Is that because it is bound?3.
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(DsCompareResults, "RESULT")the first line works fine, which means that no problem with deleting a row in the dbgrid, but when the second line of code is executed, which is meant to update the changes to RESULT table in db, it gives sql error. here are the update sql:UPDATE RESULTSET START
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 CYMUSER ON TEST.UID = CYMUSER.UID AND RESULT.UID = CYMUSER.UIDWHERE (TEST.TNAME = @TNAME) AND (CYMUSER.UNAME = @UNAME)RID is the pk of table RESULTS, but not displayed in the dbgrid.i have a button "giveRID", now i select a row in the dbgrid, when i click on the button "giveRID", i
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 records in dbgrid1 when I start my program. P.S. May be it's necessary to tie first column in dbgrid with first column in db table... how?
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 because the checkbox corresponds to the specified value. This is written into access and the database is also located within the program. Thank you for your help.Public Function CheckLetter(InString) As StringDim x, CurrentPath, OCN1, OCN2 As StringDim db As DAO.DatabaseDim rs As DAO.RecordsetSet db = C
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 called oRecs.Currently I was thinking of doing something like thisDo While Not oRecsParts.EOFoRecs.AddNew [List of 20 fields(x)] [list of 20 values from oRecsParts.Fields(x).value]oRecsParts.MoveNextLoopProblem is the .AddNew seems to do FIELDs at a time, so it would be really long/nasty to do it th
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
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...Does somebody know about this ?Thanks, if you know something about this problem !!
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 large update query using ADODB.Command, which is necessary for our next query using a ADODB.Recordset. The second query does not notices all the updates. Note: We use the same ADODB.Connection for both the update and the query.It looks like this problem sometimes also occurs with single row-updates
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, connection,3,3 (have also modified the 3,3, to be adOpenDynamic, adLockOptimistic) I have tried checking the flag To Return Matching Rows, I've added the option = 2 in the connection string, i have a primary key field in the table, and I've also tried re-assigning it to itself. Are there any items
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 start on first table retrieve all the data, then move to next table (similar to moving to next row)?
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 have a form with two grids : when row on one grid selected (a record in table) the other grid selects all corresponding records in other table. For this example what should i do if i don't want to use cursor and queries from vb but to enclose this operations in database?
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 since it was last read."The same code was working with SQL 2000 !!!Any clues.implicit tran are off on the sql 2005 server.
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!
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 = CompanyAddr!hSSSId = CompanySss!hMedId = CompanyMed!hIbgId = CompanyIbg!hTIN = CompanyTin!hTelephone = CompanyTel.UpdateEnd WithIn MS Access, the VB6 code above works very well. But when I converted the table to SQL and run the code, there is error that says:Row cannot be located for updating. S
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 same message for two months, and somebody answer me that it what a microsoft problem, but I don't understand this answer ??
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 same message for two months, and somebody answer me that it what a microsoft problem, but I don't understand this answer ??
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 grid. problem arise when i want to select a row which is not visible at the moment of selection. i.e. if i select 20 th row in the combo selection then as only 10 rows visible in grid at that time, the error comes like "invalid row number". this means grid must be auto scrolled to that partic
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 value for name in another one and also the value for age in another textbox.That is I need to display individual column values for the selected row in a text box for each one.Can anyone help me?
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 errors exist. ISSUE: At runtime, when the grid control retrieves the 9 records from the db, an error is popped up: "Invalid Row Value". I have tested and seen that if there are 7 records in db, then no errors occur. But, at runtime, if the records queried, exceed the no of rows in the grid
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 coce for my cancel button:Private Sub cmdCancel_Click()On Error Resume NextAdodc1.Recordset.CancelUpdateClearTextEnd Sub
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, explain me that it is not an Oracle Error !!
I'm working with Oracle 8i, VB6 and ASP !!Did somebody get this problem : " ROW-00060..."?And why ?
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 ????
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 ?Some, explain me that it is not an Oracle Error !!
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 that person
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 one table to be used in another. Hope it is OK to ask few questions but will put them one by one:1. How do I put new data into the DataGrid using the software? In runtime one can type in data to the DataGrid, but I want to get info from one form and then put it using my software into a given column fo
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 updating. Some values may have been changed since it was last read. I am opening the recordset like this. Selecting the row using the primary key field. dim rs as new ADODB.Recordset rs.CursorLocation = adUseClient rs.open "Select * from inv_inv where invID = p_invID, myCN, adOpenStatic, adLockOpti
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 great when there is data to view). However, if the adodc object has no data for a specific status (for ex: no cancelled jobs) and then I change to look at jobs in a different status (say complete), the double click no longer works propertly. It is off by one row. Does anyone know how to fix this?
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 tell me what I'm missing to actually get the widget.dbf file created?Simple code is:Public myWS As WorkspacePublic mydb As DatabasePublic myTDef As TableDefPublic myRS As RecordsetPublic myFld As FieldSet mydb = OpenDatabase("C:\TESTDIR\", False, 0, "DBase 5.0;")Set myTDef = myd
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 use is:----------------Private Sub AddRecord(Path As String)Dim cn As ADODB.ConnectionDim rs As ADODB.RecordsetDim sql As StringDim connstr As StringDim a As DoubleDim b As VariantDim i As IntegerDim kk As DatabaseDim kkRS As Recordsetconnstr = "provider=microsoft.jet.oledb.4.0;data source=http:/
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 can be used unbound, with columns that can be defined as tick boxes, combo, text boxes etc, and will allow the user to edit the contents?
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()Call OpenGridEnd SubPrivate Sub DBGrid1_UnboundGetRelativeBookmark(StartLocation As Variant, ByVal OffSet As Long, NewLocation As Variant, ApproximatePosition As Long)' DBGrid1 calls this routine each time it' needs to position a row.' StartLocation is a bookmark supplied by the grid to' indicate