Access 2010 macros to query table
Posted on 2011-05-05
I have been developing on Access 2003 for years but I'm having problems transitioning to Access 2010. I've been reading that we should use macros rather than vb code for security reasons.
I am trying to create a login form where the user enters their username and password then the app queries the user table to validate the data. This would've been so easy for me in 2003 but I'm stumped in 2010!
1. I cannot seem to find macro actions to do this.
2. Since I couldn't find macro actions, I tried to write vb code. When I create a button on a form, I cannot find a way to write/access vb code for the On Click event - something easily done in 2003 (Event Procedure).
3. I tried writing simple macros with the intent to use the Convert macro to vb but I cannot find that command as documented under the Database Tools, Macro tab. The only options I have are Visual Basic and Run Macro.