Feedback

VBA

You want to count how many records for a given customer based on CustomerID which is of field type short text in table tblCustomer. The customer id we want the count for is 123-AC. We are using the domain aggregate function DCount and assign it to an integer variable intC what is the correct syntax.

intC = DCount("*","tblCustomer","[CustomerID] = " & 123-AC)

intC=DCount("123-AC","tblCustomer","[CustomerID]")

intC = DCount("tblCustomer","*","Me.CustomerID = 123-AC")

intC = DCount ("*","tblCustomer","[CustomerID] = ' & 123-AC & "'")

Syntax is incorrect can't save in an integer variable if you are counting on a field type of short text.

Answer:
intC = DCount ("*","tblCustomer","[CustomerID] = ' & 123-AC & "'")

Note: This Question is unanswered, help us to find answer for this one

Previous

Next

More VBA MCQ Questions

Which is NOT a method of the Workspace object:

What will Format(“A123”, “&&&&&&”) output?

When you have added a new linked table using VBA code and it does not appear in Navigation Pane that displays the list of tables, forms, macros, and queries in the database. Which VBA code would you use to update the list of database objects displayed in the Navigation Pane.

Choose the VBA code that you would use to call a public function named VBAFunction from a form called FormA while passing a variant x1 in the module of FormB form.

The ____________ allow(s) for multiple controls in a user form, to execute the same sub.

When stepping through code as a way to see how the values in variables change, use the:

Which code will allow user to edit a password protected worksheet.

To change the text displayed in a label on a form, choose the VBA code that will allow you to update the property.

Combine into one line: If x > 5 Then y = x - 5 End If

To change a comment in cell A1, which will do the job?