This was a great idea. I put it on my main menu as well to show tips for various things like "you need to select a person from the combo box" etc. I also made it into a module so I can write to it from everywhere. One other thing I did was change it into a variant. This tool is most handy for me while I am working on my db. I use it in place of the immediate window. Thank you for the tip Rick.
Great video. One thing I'm stuck on is having a status box value update based on a checkbox on the form. If checked display Y in status box, otherwise display N in status box. It works fine unless the checkbox is updated a second time. (ie: from yes to no).
@@599CD Hi Rick, wondering if you were able to get to this as I couldn't find it. Throwing in my vote for a sequel if you still planning on doing this.
I've been learning lots and lots... I am trying to replicate your StatusBox but for some reason vbNewlIne has no effect on my statusbox. I can see online quite a few people with the same issue, I am running Access2016 if that has any bearing on it? My code lines are: Private Sub Status(S As String) StatusBox = S & vbNewLine & StatusBox DoEvents
End Sub and Private Sub TestBtn_Click() Status "Hello, World!"
End Sub Is there some Access VBA deep magic that I can try? I have been creative and tried popping the "& vbNewLine" command at the end of my TestBtn routine with no effect. I's almost like Access is ignoring the command. Any ideas greatly appreciated! Kind regards, Pete
This was a great idea. I put it on my main menu as well to show tips for various things like "you need to select a person from the combo box" etc. I also made it into a module so I can write to it from everywhere. One other thing I did was change it into a variant. This tool is most handy for me while I am working on my db. I use it in place of the immediate window. Thank you for the tip Rick.
BEST TUTOR ... EVER....
This was a very hard video for me…but still loved it.
Thanks
We really enjoy this video, thanks
Welcome
Great video. One thing I'm stuck on is having a status box value update based on a checkbox on the form. If checked display Y in status box, otherwise display N in status box. It works fine unless the checkbox is updated a second time. (ie: from yes to no).
599cd.com/AfterUpdate event
excellent video. thanks!!!
Glad you liked it!
Sure beats the varReturn = SysCmd(acSysCmdSetStatus, " ") mess too!
Indeed!
More more plz👍
Ks
Can you call this function which is in/on the main form from a subform or a pop-up form?
With a little tweaking, yes. A few people have asked me this. I'm going to show how in a future video. Stay tuned.
@@599CD Hi Rick, wondering if you were able to get to this as I couldn't find it. Throwing in my vote for a sequel if you still planning on doing this.
Would be great if we can see how can update the status box from another function not from the button click event.
I've been learning lots and lots... I am trying to replicate your StatusBox but for some reason vbNewlIne has no effect on my statusbox. I can see online quite a few people with the same issue, I am running Access2016 if that has any bearing on it? My code lines are:
Private Sub Status(S As String)
StatusBox = S & vbNewLine & StatusBox
DoEvents
End Sub
and
Private Sub TestBtn_Click()
Status "Hello, World!"
End Sub
Is there some Access VBA deep magic that I can try? I have been creative and tried popping the "& vbNewLine" command at the end of my TestBtn routine with no effect. I's almost like Access is ignoring the command.
Any ideas greatly appreciated!
Kind regards,
Pete
Mended, I continued watching the video and fund the "" part, I had raced ahead and changed the box type to Rich Text. (Impatient student!)