Примери за използване на Recordset на Английски и техните преводи на Български
{-}
-
Colloquial
-
Official
-
Medicine
-
Ecclesiastic
-
Ecclesiastic
-
Computer
Number of fields in a recordset.
The recordset is stored as an array of objects.
Note: Changing the RecordLocks property of an open form orreport causes an automatic recreation of the recordset.
The record in a recordset from which you can modify or retrieve data.
Just drop it on your form select the CursorType, CursorLocation, LockType, andDisconnected status of your Recordset(or leave the defaults).
The record in a recordset from which you can modify or retrieve data.
You can also use this expression in the SQL property of a QueryDef object orwhen creating a Recordset object based on an SQL query.
To use methods with the Recordset object that aren't directly supported on forms.
You can use Avg in a query expression and in the SQL property of a QueryDef object orwhen creating a recordset object based on an SQL query.
The Recordset is the primary means of examining and modifying data in the rows.
The following code helps to determine what type of recordset is returned by the Recordset property under different conditions.
When a Recordset object is created, the Microsoft Access database engine uses the table's field name as the Field object name in the Recordset object.
Tips: You cannot specify field values for multivalued fields by using the filter by form, butyou can specify values for a non-multivalued field in the recordset.
A property of a Recordset object or a form that contains a binary string identifying the current record.
Tips: You cannot specify field values for multivalued fields by using the filter by form, butyou can specify values for a non-multivalued field in the recordset.
When a form is bound to a recordset, an error occurs if you use the Filter by Form command.
You can manipulate the structure of a base table by using the DAO objects or data definition(DDL) SQL statements, andyou can modify data in a base table by using Recordset objects or action queries.
Changing a form's Recordset property may also change the RecordSource, RecordsetType, and RecordLocks properties.
A join is a SQL operation that combines data from two sources into one record in a query recordset based on values in a specified field that the sources have in common.
For example, you can use the Recordset property with the ADO Find or DAO Find methods in a custom dialog for finding a record.
Note: You cannot specify field values for multivalued fields using filter by form, nor for fields with Memo, Hyperlink, Yes/No, or OLE Object data type,although you can specify values for other fields in the recordset.
Returns or sets the ADO Recordset or DAO Recordset object representing the record source for the specified form, report, list box control, or combo box control.
You can use DAO objects, such as Database,TableDef, and Recordset, to represent objects that are used to organize and manipulate data, such as tables and queries, in code.
However, unlike using the RecordsetClone property,changing which record is current in the recordset returned by the form's Recordset property also sets the current record of the form.
The following example opens a form,opens a recordset, and then binds the form to the recordset by setting the form's Recordset property to the newly created Recordset object.
The following example uses the Recordset property to create a new copy of the Recordset object from the current form and then prints the names of the fields in the Debug window.
There can be only one current record in a recordset at any given time, but a recordset may have nocurrent record- for example, after a record has been deleted from a dynaset-type recordset.
The read/write behavior of the Recordset property is determined by the type of recordset(ADO or DAO) and the type of data(Access or SQL) contained in the recordset identified by the property.
There can be only one current record in a recordset at any given time, but a recordset may have no current record- for example, after a record has been deleted from a dynaset-type recordset.