Recent content by CCLINT

No, it's not possible.

You cannot use multiple fields with the Find method. You will need to use the Filter method, best when used with a recordset clone and then setting the bookmark of the original recordset to the bookmark of the cloned recordset.

Well, you haven't opened ADORs yet. Where is the open code for this?

Then you are going to have to post the code which you are using. The code you posted above is NOT the exact code you are using. In addition, you are going to have to answer my question.

>Set Adodc1.Recordset = ADORs This is the correct syntax. But, depending on the DMBS you are using, could it be that that DBMS doesn't support (automatically) the IRowsetIdentity property with a server side cursor, such as with a JET MDB? If not, then you will need to code it to do so...

You can also hover over the string and see the current value, or click into the Immediate/Debug/Immediate window (VIEW|IMMEDIATE WINDOW) and copy the variable name there as: ?s_str and with the cursor at the end of the string name, hit ENTER.

dandough, This is the " Visual Basic(Microsoft) Databases Forum" and not the DBMS Package-Application forum702 for MS ACCESS. Please post your question there.

You can create a recordset clone so that the original recordset doesn't also get filtered: Dim rsClone As ADODB.Recordset Set rsClone = rslimit.Clone rsClone.Filter = "IngredientID = 19"

Is the DataSource for the DataGrid set to rsDelete? Use the DataSource which the DataGrid is bound to: (Replace the below rsData recordset object with the name of the recordset object the grid is bound to, or the name of the Adodc data control's recordset - Adodc1.Recordset) Set...

Easier, and international friendly (different decimal and thousand separators), would be to just use: IsNumeric(Text1.Text & "0") in the change event, and then IsNumeric(Text1.Text) in the validate event...

You can use an API, or use an ocx called KEYSTA32 which was shipped with VS VB6. You will find it under: \Microsoft Visual Studio\Common\Tools\CONTROLS\KEYSTA32.ocx Set a reference to this (PROJECT|COMPONENTS). It will not be listed in the components list, so you need to click the search...

vsa, is this an AutoNumber field? If so, then you cannot just update it.

Two things: 1. Post the Set bd = xxx.OpenDatabase(xxx) code 2. I cannot tell from the code you have posted if rs1 is being used to open 3 different recordsets with-out closing rs1 prior to setting it to nothing.

You are going to have to identify at what times in what situations the db is locking. This may be happening when you are doing some certain db operation such as compacting or reparing in code, changing the table and field properties in code, opening the recordset for pessimistic locking and...

There is a FAQ on this (FlexGrid Edit control) with an example.