How to Show or Hide Controls in a Microsoft Access Report Using a Macro (Without VBA)

[@replicaman9215]

This video is new, so I may never get a chance to say this and have it seen otherwise, but I appreciate your videos, Richard. Your style and approach is old-school (which as an 80s/90s kid I appreciate) but simultaneously current, relevant, and ever so applicable. I've fiddled around with Access in various jobs for years, to varying degrees of success, but somehow watching your videos puts all my experience in its proper place, clears up ancient-but-fundamental misunderstandings, and makes me wish I had your videos as a resource years ago. I would've saved myself a lot of banging-head-against-the-wall moments. You truly are an MVP, thank you.

[@599CD]

Thank you very much I really appreciate that

[@7ammoodi1]

Dear Richard, I appreciate your efforts in preparing these helpful videos to make things easier for all ACCESS users. I do have a case which I really need your help with please: I have a form (it is Projects Teams Form) this form's data is stored in a table called Teams data. What I need is to select a pre-defined employee using a combo box displaying all stored employees' records in another table named Human Resources Data. Once I select his ID from my combo box in the current form (Projects Teams Form), the name of this employee should be copied from Human Resources Data table and displayed automatically in the Projects Teams Form name field. I do have many other fields as well, but it is enough to clarify how to get the name value form another table. Thanks a lot for your time.

[@josecandidosorianavalon3339]

Hi, Richard! 25 or more years ago, when I firstly dove into Access, I did not know a word about VBA. I started with Macros... But when I learnt how to transform Macros to VBA, that was my real beginning indeed! Never ever since then I went back to Macros, but it is a kind of beginning for newbies... Do you agree? Best regards and thanks for your videos, useful both for beginners and 'old people' alike...

[@Shadow.Dragon]

Jose, I did the same thing for Excel. I would turn on the macro recorder, do an action(s), and then look at the macro. I would then manually covert it over to VBA (this was before MS put in the auto-convert function.

[@599CD]

Yeah that's a great way to learn in either Word or Excel is to use the macro recorder and see what kinds of commands it writes. Unfortunately there is no macro recorder in Access. Even though you can convert macros over to VBA you can't have it record your steps like you can in Word or Excel. Once again Access is the red-headed stepchild of the family.

[@Jojosmith342]

Another excellent, valuable tutorial. All thumbs up to the most exceptional Access teacher Richard. This is what I have searched for. Thank you so much Richard for your valuable time to educate the world. 🙏

[@599CD]

Glad it was helpful!

[@Tlawat-1]

I have seen the level 1 4 hours what can I learn more

[@599CD]

Huh?

[@Orandivictor]

How can someone disable bypass key when login

[@599CD]

It's possible but it requires a bunch of coding and I cover it in my security seminar: 599cd.com/SecuritySeminar

[@johnwatkins39]

I like using Macros, because i work on a military base and i use databases alot. The military systems dont allow VBA. Samething with Excel. The military uses ALOT of excel.

[@599CD]

Yeah the military and big corporations are pretty tough on locking down VBA

[@zvig1]

is there a way with macro to change form caption?

[@599CD]

599cd.com/ask