Very, very important! A real problem we see here, everyday, is that newbies haven't taken the time to even learn the most basic ABCs of Access, and because of this, can't ask for help with intelligent questions! It's nice to see someone who wants to do that!
Something not mentioned so far, and how I originally taught myself, half a lifetime go, was to use reverse engineering! Copy the code for a simple database, run a Form in the database, to see what it does, then go into the code module for the Form to see
how it does it.
And don't be afraid to use Access help! Come across an unfamiliar Command or Function, in the code module? For Functions
Code:
If IsNull(Me.TextboxName) Then MsgBox "TextboxName cannot be Empty!"
Place your cursor in the middle of
IsNull and press
F1.
Do the same for
Msgbox.
For Commands
Code:
DoCmd.OpenForm "YourFormName"
Place your cursor in the middle of
OpenForm and press
F1.
To learn about the parameters needed for the above Command, type in, in the code module
DoCmd.OpenForm
and press the Space Bar and the parameter list will pop up, with the
FormName parameter in Bold; enter a Form's name
"MyFormName
"
(note the Quotes) type a comma and press the Space Bar, again, and and the
ViewForm parameter will pop up, along with a dropdown listing the valid choices, and so forth.
Access Help has a bad rap, frequently earned, but for this kind of thing it's very good.
Be forewarned...this is a very long journey you're embarking on! I've been trekking in AccessLand for almost twenty years, now, and am still learning on a regular basis!
Welcome to AccessForumsNet!
Linq
;0)>