Back to lesson
1. In this VBA code, how many line continuations are there?
2. In this code, if vWhere is already set to "CustID = 1" and the ServiceID control has a value of 5, what will be the new value of vWhere?
ServiceID = 5
CustID = 1 AND ServiceID = 5
CustID = 5
3. If this procedure is behind a report and the report has no data, what will happen?
The report will not open and the user will get a message that the report has no data.
An empty report will open.
Access will crash.
4. What does On Error Resume Next mean?
Raise an error
Go to the next statement
If there is an error with subsequent statements, errors will be skipped and no error message will be given to the user.
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement