VBA code

[jrsarrat]

Hi there!

I have created a login screen for users, and installed a VBA code to notify them of a successful or unsuccessful login (with the click of a button). From a successful login, I would like Access to default to a specified form to add new records. What code would I use? Do I enter the command in the same VBA box I stored the other command?

 

[jrsarrat]

Awesome! Thank you!
My new conundrum is this - My "Find Record" button on the form is not available now -- "The command or action 'Find' isn't available now."

 

[Joe4]

Yes, that code will open the Form in New Record only mode.
If you want to open the Form so that it shows/lists all current records, but opens up to the new Record option, then try this instead:

    DoCmd.OpenForm "FormName", acNormal, "", "", , acNormal
    DoCmd.GoToRecord , "", acNewRec

 

[jrsarrat]

Wow! This is great!
Question: Perhaps I want to change it back to "New Record only mode, but this time add a query button on the form that will give each user a report of *their own entries. I know it's possible to create that query button, but what code would I use to specify the query selection based on user login?

Thank you for your reply!!!

 

[Joe4]

what code would I use to specify the query selection based on user login?

Take a look here: http://www.databasedev.co.uk/filter_current_user.html

 

[jrsarrat]

Take a look here: http://www.databasedev.co.uk/filter_current_user.html

Thank you Joe4!
I will work on this upon my arrival tomorrow. Thank you so much for assisting me. What a tremendous help!
Question: what source can I use to enhance my ability of implementing codes? I'm also unfamiliar with the purpose of each DataMode Argument.

 

[Joe4]

Question: what source can I use to enhance my ability of implementing codes? I'm also unfamiliar with the purpose of each DataMode Argument.

To be honest, I usually just do Google Searches (like on "Access DoCmd.OpenForm"), and check out a bunch of the articles until I found one I like.