MS Access 2003: Convert Close macro to VBA code
This MSAccess tutorial explains how to convert a Close macro to VBA code in Access 2003 (with screenshots and step-by-step instructions).
Question: In Microsoft Access 2003/XP/2000/97, how can I convert a Close macro to VBA code?
Answer:Below is a macro in Access that is performing a Close. We want to convert this macro to VBA code.
In VBA, there is a command called DoCmd.Close that will perform the same function as the macro version.
To convert the macro above to VBA code, you would use the following command:
DoCmd.Close acForm, "Engineering", acSaveYes
This command would close the form called Engineering and save any changes.
Advertisements