been watching lot of your videos all weekend...youve been helping me with formulating a method of creating Payroll Notices for work. think i have general idea just need to think all the little nuances that come up today and how to address them in the system 👍
Exposure to an entirely new layer in relationships and optionality. Really good one Richard and thank you. Pondering how this can help with a dynamic form, i.e. choosing what goes on a form or a view basis what fields have been "activated" for a given customer. Some form geography considerations would have to accompany that , since we dont know what's going to show based on the selections in each customer case. Just a thought. Maybe a bad one... :) Maybe another video... Thanks again sir!!
I've been debating with myself about whether to do this on one of my tables. I have about 20 yes/no fields and, yes, doing it this way makes a lot of sense. However, I'd like the user (me) to be able to choose the criteria to search for, including the yes/no fields. Eg. Find all the customers who live in Florida and are also Trekkies AND Browncoats and DON'T have a warranty. This would be fairly straightforward if they were all in one table, using the multi-field search, but a lot more complicated when the yes/no fields are separate. Do you have a video that would give advice on this, please? (Hopefully a free one - I'm just a geek learning this for fun, not a company or using it for work) I'm loving your videos!
I'm a Trekkie. I've taken over the term from people who used to pick on Trekkies and call us nerds, which forced some people to coin the term Trekker. Nope. Not me. Trekkie and proud.
always thumbs up to the greatest Access teacher Richard. Thanks Richard
You're welcome
Hi Richard excellent video. Just watched your auto text video which was very informational great. Steve b
@ 4:10, Love the "Firefly" reference!
Shiney
been watching lot of your videos all weekend...youve been helping me with formulating a method of creating Payroll Notices for work. think i have general idea just need to think all the little nuances that come up today and how to address them in the system 👍
Sweet! Glad you like it.
Exposure to an entirely new layer in relationships and optionality. Really good one Richard and thank you. Pondering how this can help with a dynamic form, i.e. choosing what goes on a form or a view basis what fields have been "activated" for a given customer. Some form geography considerations would have to accompany that , since we dont know what's going to show based on the selections in each customer case. Just a thought. Maybe a bad one... :) Maybe another video... Thanks again sir!!
Sounds like just making certain fields visible or not in the OnCurrent event. 599cd.com/OnCurrent
Thank you : )
I've been debating with myself about whether to do this on one of my tables. I have about 20 yes/no fields and, yes, doing it this way makes a lot of sense. However, I'd like the user (me) to be able to choose the criteria to search for, including the yes/no fields. Eg. Find all the customers who live in Florida and are also Trekkies AND Browncoats and DON'T have a warranty. This would be fairly straightforward if they were all in one table, using the multi-field search, but a lot more complicated when the yes/no fields are separate. Do you have a video that would give advice on this, please? (Hopefully a free one - I'm just a geek learning this for fun, not a company or using it for work) I'm loving your videos!
Yeah, but it's fairly complicated. I cover something similar in my 599cd.com/SearchSeminar
Wish I watched this a month ago before I put in 300 records with 20 potential check boxes per record.
Sweet
Hmmm... Is it Not working for me? that's weird because I did all you did on the video but it doesn't update by clientID?
I fix it! now it's all good! thanks for your video! very well explained!
Glad to help. :)
"You've taken something I did as a lark and turned it into a colossal waste of time."
:)
Trekker. Not trekkie.
I'm a Trekkie. I've taken over the term from people who used to pick on Trekkies and call us nerds, which forced some people to coin the term Trekker. Nope. Not me. Trekkie and proud.
@@599CD Good luck with that.
And thanks for the high quality videos on Access!