Make control wizard produce VBA code not macro

[suepowell]

HI All,

this is another of those questions about the differences betwen access 2003 and 2007.

I often use the control wizard to put buttons etc on my ofrms, then adjust the code if it is not quite what I want. Saves me time and reduces the chance of typo's.

I have found that when I put a button on a form to duplicate the record it is producing a macro, and I want an event procedure cos I dont' use macro's and want to add to the code anyway.

Does anyone know here the setting is to stop the wizard producing macro's?


thanks

Sue

 

[dapfeifer]

I'm not sure if you can tell the wizard to stop producing macros, but you could always just convert the macro to VBA code through one of the menus. Not sure what version you are actual questions are relating to, but the version I'm using has this ability in the Tools -> Marco -> Convert Macro to Visual Basic. Make sure you have the macro you want to convert selected.

 

[suepowell]

HI

Thanks for that, it's a great help, I've been round and round the menus looking for the answer and just couldn't solve the problem.

Just for extra info to anyone else with the problem.

I am using Access 2007, and to get to the button you click database tools from the ribbon and under the Macro section is a handy button to convert a forms macros to VBA.

Nice but it is an extra step to what I was used to.

thanks again.

Sue

 

[dapfeifer]

Sorry I couldn't help point you exactly where you needed to go, haven't had a chance to work in access '07 yet, but glad you found what you needed!