I'm not shy of VBA, my most complicated app has some 200k lines of VBA, but I really love watching your videos, even the beginner level ones. Beside that it's a real joy listening to you I often find a gem of information of which I instantly think "Heck, why didn't I guess that? It's so useful!". So, thanks a lot, and please, carry on!
Richard your videos are so clear, concise, and enjoyably educational. If only you had an Access book out. That would be amazing too! Thank you Richard.
I wrote an Excel book back in 2010: cigexcel.com. While it was definitely a learning experience, it wasn't easy AT ALL. Lots of work. I much prefer recording videos... but I'm not ruling an Access book completely out. As soon as the AI gets good enough at transcribing my audio AND inserting the screen shots, I'm on it. LOL.
Cool video. Until very recently, I never used transparent buttons even though I wanted to, because I kept forgetting to use "Bring to Front." D'oh. Anyway, could you also do this by pulling a dynaset rs in the invisible button's OnClick event, and updating the record that way? Just curious.
I hadn't really thought of this method. What I've tended to do is run an update query to transfer the result of the complex query into a table. You can then build the form based on this table, which will be updatable. Then any changes to the table will also need to be cascaded into the data table with more SQL
Hi your videos are great. one thing i want to know is, i used your code and it's run but there a prompt 'Write Conflict' This record has been changed by another user since you started editing it. how can i disable this prompt. thank you.
When it comes to Access, I am a weekend warrior, but I really enjoy your videos. In this one after wrting down the IIF function, you stop and say "..probably should have put IIF as one of the prerequisite"... How do you do that ?
i used a 2 update querys an in the on clic event i used an "if" for this to work you need the field from the table visible false and were the check box use a clone of this field with other name
@@599CD I know, but I don't think that much advertising is necessary. Or at least you can increase the speed of the video while advertising. Anyways, I love you. I have learned a lot from you. Not only ACCESS, but also database and programming in general.
I'm not shy of VBA, my most complicated app has some 200k lines of VBA, but I really love watching your videos, even the beginner level ones. Beside that it's a real joy listening to you I often find a gem of information of which I instantly think "Heck, why didn't I guess that? It's so useful!". So, thanks a lot, and please, carry on!
Thank you for the kind words I really appreciate that
Richard your videos are so clear, concise, and enjoyably educational. If only you had an Access book out. That would be amazing too! Thank you Richard.
I wrote an Excel book back in 2010: cigexcel.com. While it was definitely a learning experience, it wasn't easy AT ALL. Lots of work. I much prefer recording videos... but I'm not ruling an Access book completely out. As soon as the AI gets good enough at transcribing my audio AND inserting the screen shots, I'm on it. LOL.
I really like and get a lot of knowledge out of watching them.
Nice
Excellent video, Richard!
Thanks
thank you Richard for this lesson
My pleasure!
Thanks, nice way of doing it... 👍
Welcome 😊
Very useful and interesting!
Glad it was helpful!
Cool video. Until very recently, I never used transparent buttons even though I wanted to, because I kept forgetting to use "Bring to Front." D'oh.
Anyway, could you also do this by pulling a dynaset rs in the invisible button's OnClick event, and updating the record that way? Just curious.
Uhm... maybe. Try it.
very good
I used Dsum function in query but after some that query run slowy. please make vedoi on to make query more faster with dsum
Don't use DSum in a query if you can avoid it. Use a join.
DLookup Slow: 599cd.com/DLookupSlow
I enjoy your videos YOU ARE ALWAYS SO HELPFUL! Thank you.
You are very welcome
Thanks!
Thank you very much!
I hadn't really thought of this method. What I've tended to do is run an update query to transfer the result of the complex query into a table. You can then build the form based on this table, which will be updatable. Then any changes to the table will also need to be cascaded into the data table with more SQL
Whatever works for ya! :)
Thanks
Welcome
Hi your videos are great. one thing i want to know is, i used your code and it's run but there a prompt 'Write Conflict' This record has been changed by another user since you started editing it. how can i disable this prompt. thank you.
When it comes to Access, I am a weekend warrior, but I really enjoy your videos. In this one after wrting down the IIF function, you stop and say "..probably should have put IIF as one of the prerequisite"... How do you do that ?
599cd.com/IIF
i used a 2 update querys an in the on clic event i used an "if" for this to work you need the field from the table visible false and were the check box use a clone of this field with other name
Sweet
Your videos are awesome and very helpful, but half of your every video is advertisment.
Well, I've got bills to pay just like everyone else. This is what I do for a living. I don't apologize for trying to sell my lessons.
@@599CD
I know, but I don't think that much advertising is necessary.
Or at least you can increase the speed of the video while advertising.
Anyways, I love you. I have learned a lot from you. Not only ACCESS, but also database and programming in general.