How Do You Convert Access 2007 Macro To Visual Basic?
Microsoft Access 2007 allows you to create macros in one of two ways. The first way requires you to enter macro information in a table format. The second way is by creating Visual Basic code for an object or event. If you’ve already created a macro using the first method, but want more control over the macro, convert the Access 2007 macro to Visual Basic. This adds more functionality to how the macro operates, making the macro much more powerful. Open Microsoft Access 2007 database containing the macro you want to convert. Open the form or report the macro is stored in. This only applies to macros created within a form or report, not those created under the “Macros” screen in the main database window. Click the “View” icon on the toolbar and select “Design View.” Choose the “Tools” menu and select “Macro.” Choose “Convert Form’s Macros to Visual Basic.” Select “Convert Report’s Macros to Visual Basic” if the macro is in a report. Open your Microsoft Access 2007 database and choose “Mac
