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?
CustID = 1 AND ServiceID = 5
CustID = 5
ServiceID = 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.
Access will crash.
An empty report will open.
4. What does On Error Resume Next mean?
If there is an error with subsequent statements, errors will be skipped and no error message will be given to the user.
Go to the next statement
Raise an error
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement