If you run Visual Basic code containing the SendObject method in a library database, Microsoft Access looks for the object with this name first in the library database, then in the current database.
To Optional Variant. A string expression that lists the recipients whose names you want to put on the To line in the mail message. Separate the recipient names you specify in this argument and in the cc and bcc arguments with a semicolon ; or with the list separator set on the Number tab of the Regional Settings Properties dialog box in Windows Control Panel.
If the recipient names aren't recognized by the mail application, the message isn't sent and an error occurs. If you leave this argument blank, Microsoft Access prompts you for the recipients.
Cc Optional Variant. A string expression that lists the recipients whose names you want to put on the Cc line in the mail message. If you leave this argument blank, the Cc line in the mail message is blank. Bcc Optional Variant. In this article. An expression that identifies the field whose value you want to return. It can be a string expression identifying a field in a table or query, or it can be an expression that performs a calculation on data in that field.
In expr , you can include the name of a field in a table, a control on a form, a constant, or a function. If expr includes a function, it can be either built-in or user-defined, but not another domain aggregate or SQL aggregate function. A string expression identifying the set of records that constitutes the domain. It can be a table name or a query name for a query that does not require a parameter. An optional string expression used to restrict the range of data on which the DLookup function is performed.
If criteria is omitted, the DLookup function evaluates expr against the entire domain. Any field that is included in criteria must also be a field in domain ; otherwise, the DLookup function returns a Null.
Daossoft Access Password Rescuer. Microsoft Office Primary Interop Assemblies. Harmonized World Soil Database. Classic Menu for Access The Access Workbench. How to Use Microsoft Excel keyboard shortcuts. If you use an asterisk, the DCount function calculates the total number of records, including those that contain Null fields. The following example calculates the number of records in an Orders table.
If domain is a table with a primary key, you can also count the total number of records by setting expr to the primary key field, since there will never be a Null in the primary key field. If you use an ampersand to separate the fields, the DCount function returns the number of records containing data in any of the listed fields. If you use the addition operator, the DCount function returns only the number of records containing data in all of the listed fields.
The following example demonstrates the effects of each operator when used with a field that contains data in all records ShipName and a field that contains no data ShipRegion. Note The ampersand is the preferred operator for performing string concatenation. You should avoid using the addition operator for anything other than numeric addition, unless you specifically wish to propagate Nulls through an expression.
Unsaved changes to records in domain aren't included when you use this function.
0コメント