![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
When You Really Need It
Apr. 16th, 2016 09:15 amIf you ever really need help with MS Access and would like to have a nice giggle in the process, check out the Access All In One YouTube channel.
James Conway runs these videos. What's great about his tutorials is that not only is he pretty quick and detailed, he's also very human. He has the occasional brain fart. He plays with showing what you can do with colors on a datasheet to the point that even he declares the color scheme he has selected to be "foul, truly foul." And he's constantly throwing in impromptu one-liners, like in this snippet, when he notices that his Access window isn't well-centered.
I find great, simplistic joy in watching his videos.
From his channel, on the right, you will see related channels, and I highly recommend PC Learning Zone with Richard Roth, as well as austin72406 (I think he says his name is Te Wan, but I don't see it in print anywhere, so not sure if it's spelled correctly) who gives some quite excellent videos on various form search options. I tried out Simon Sez It but found most answers were better met via the other three channels or specific Goggle searches for each particular problem I run into (which I seem to be running into them all in alphabetical and numerical, in the case of runtime errors, order).
Most of my errors have something to do with the fact that I'm utilizing all of my wide-screen monitor space and have 4 levels of embedded subforms on my main customer history and invoice processing screen (because I'm actually able to combine them into one screen instead of two), which isn't unheard of, but a little over the top. I'm attempting to resist pop-up entering forms as much as possible, which leads me to such madness (as my blog title declares). Trying to reference a control or field in one subform from a different subform when both are at the bottom 4th level in the hierarchy can be quite interesting. I'm starting to be a little less confused on the references between a form in datasheet mode and a form in continuous form mode (which gave me fits for about a day while I was treating a continuous form made to look like a datasheet AS a datasheet while trying to get Access to select a particular record within the data set), as well as the difference between where the cursor is on a form versus where Access has it's focus, which also affects things like being able to access a control's .Text or .Value properties.
I'm having way too much fun with this.
James Conway runs these videos. What's great about his tutorials is that not only is he pretty quick and detailed, he's also very human. He has the occasional brain fart. He plays with showing what you can do with colors on a datasheet to the point that even he declares the color scheme he has selected to be "foul, truly foul." And he's constantly throwing in impromptu one-liners, like in this snippet, when he notices that his Access window isn't well-centered.
I find great, simplistic joy in watching his videos.
From his channel, on the right, you will see related channels, and I highly recommend PC Learning Zone with Richard Roth, as well as austin72406 (I think he says his name is Te Wan, but I don't see it in print anywhere, so not sure if it's spelled correctly) who gives some quite excellent videos on various form search options. I tried out Simon Sez It but found most answers were better met via the other three channels or specific Goggle searches for each particular problem I run into (which I seem to be running into them all in alphabetical and numerical, in the case of runtime errors, order).
Most of my errors have something to do with the fact that I'm utilizing all of my wide-screen monitor space and have 4 levels of embedded subforms on my main customer history and invoice processing screen (because I'm actually able to combine them into one screen instead of two), which isn't unheard of, but a little over the top. I'm attempting to resist pop-up entering forms as much as possible, which leads me to such madness (as my blog title declares). Trying to reference a control or field in one subform from a different subform when both are at the bottom 4th level in the hierarchy can be quite interesting. I'm starting to be a little less confused on the references between a form in datasheet mode and a form in continuous form mode (which gave me fits for about a day while I was treating a continuous form made to look like a datasheet AS a datasheet while trying to get Access to select a particular record within the data set), as well as the difference between where the cursor is on a form versus where Access has it's focus, which also affects things like being able to access a control's .Text or .Value properties.
I'm having way too much fun with this.
