Hi, I am new to VBA coding, and I am having a lot of difficulty in getting the public function: FormatToggleButtons (shown in the Extended Cut) to work. I have gone through the code word-for-word and can find no mistakes, and yet I cant get this to work -- even if I cut and paste in the correct code. Im not sure its connected, but one thing I don't understand is why the code is saved as GlobalMod instead of FormatToggleButtons(FormName), especially since it is referred to as FormatToggleButtons(actual FormName) in both the Check Boxes AfterUpdate property and the Forms OnCurrent property. If someone can let me know about my GlobalMod question, I would be most grateful. Thanks, Jim
Scott Axton
@Reply 3 years ago
James -
Last item first. GlobalMod is just a name. It could be FantasticMod if you wanted. The Mod portion (Module) is a naming convention. Like T for Table, Q for Query, etc.
By placing the code in the GlobalMod you are just "storing" the code in a "basket" that can be accessed by Access from any form not just the form you are in. See Scope for more info.
2nd - Because you are speaking about code in the extended cut you could post here: TechHelp Members Only and give us some screen shots of what you have. It is nearly impossible to help you diagnose problems without
seeing what you have. It may just be a typo or it could be something else.
Normally I would suggest you download the example db. That would require you to upgrade to Gold instead of Silver membership however. An extra $4 bucks a month. That won't even get you a Big Mac anymore and it's better for you - LOL. Well worth it in my opinion if you are going to do much in the future with Access. ( Better discount on the courses, 20% currently, AND access to the Code Vault where Richard has posted tons of his code and examples. )
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Large Check Box.
