Commenting for the algorithm. Love the content! I learn every time I watch.
@seanmackenziedataengineering
2 жыл бұрын
Awesome! Thank you!
@rogerio74c
2 жыл бұрын
Wow! Fantastic! Love to know that! Access doesnt stop to surprise me.
@seanmackenziedataengineering
2 жыл бұрын
Glad it helped! Cheers
@ibrahimalrabiah1179
2 жыл бұрын
Nice, but I have figured a problem it works once for me . After a while ( Dim as Form ) stopped working , so I replaced all controls to Full original bath FORMS!Mainform!CboResult , like that and it works again , is there any solution to find what stopped the Dim FORM FROM WORKING , THANKS
@seanmackenziedataengineering
2 жыл бұрын
Interesting! Yes, if you have frm as Form A, referring to another open form B, but that form B is closed (and reopened), the reference in form A will break. This is also true if you refer to forms from a Sub or Function in a module.
@jim27105
Жыл бұрын
I would like to use a subform to display various forms, which the user can run a query from. In other words the subform ‘window’ would just display form 1, form 2, form 3. It seems like it would be easy to do but all the videos i find are for data entry, not navigation. Any suggestions or perhaps a future tutorial?
@seanmackenziedataengineering
Жыл бұрын
Interesting idea. You may be able to change the control source for the subform control in order to switch the subform viewed. As an alternative, you may want to use the tab control, then put different subforms on each tab. You can control which tab is shown, based on some criteria on the parent form.
@jerrydfowler3480
2 жыл бұрын
Sean could this be used to open a form and give it a certain Record Source? I have a form that I could use with multiple queries. One is just for members that have emails and one is for those that don't or rather get item per the mail. So when I choose one button I would like it to open the form and give it the email records, or I choose another button and open the same form but with records without emails or prefer mail. Thanks for you top notch videos
@seanmackenziedataengineering
2 жыл бұрын
Great question. Indeed, you can swap out the Record Source at runtime in order to change the records you are working with. When doing this exercise, you can check out the properties when you type frm. The dot after frm will let you see different properties. One of them is Record Source. Put in an alternate SQL statement and it will switch the view. Alternatively, if the different views are all from the same table, you can set the form filters instead. Like this video: kzitem.info/news/bejne/1qdpyZuXgXhnmZg
@EstoYOtro
Жыл бұрын
Certainly a way to go. IF. If the line 'Set frm = Forms(strForm)' would work (4:20). On all my machines, it produces Error 438, Object doesn't support this property or Method. And yes, I used exactly your code. Any idea?
@seanmackenziedataengineering
Жыл бұрын
In the code, when you go Tools > References, what entries are checked off there?
@EstoYOtro
Жыл бұрын
Sean, thanks for coming back to my problem. I thought about the references as well, but I found the error, and it's absolutely weird: The form I put the code into had a tab-control. Once I deleted that, all was working fine. Go figure...@@seanmackenziedataengineering
@pwestphotography
2 жыл бұрын
Make so much sense when it is well presented - love the videos
Пікірлер: 21