I built a database for my mother's business. I put in attachment fields because they sounded nice at the time (this was before I found your channel). Now I know why you say DO NOT USE ATTACHMENT FIELDS. It slows everything down. After watching this video I have made nice hyperlinks to folders to take the end user to the documents I previously had in the attachment fields. I am now really enjoying the database I have created. Thank you for making your videos. I wish I could afford to be a member
This is one of those topics that I talk about in a lot of different videos but I don't have one specific video where I cover just that statement. It's on the list somewhere for its own video one of these days.
what should i do if im asked to display a message asking the user if they want to view the query i created in one question :•if they do, the query i created in the Question should run •if they do not, the chart i created in another question should open. this is related to creating a button in a dashboard in the database where i have to use a MsgBox would be grateful if you reply 🙏🙏
I built a database for my mother's business. I put in attachment fields because they sounded nice at the time (this was before I found your channel). Now I know why you say DO NOT USE ATTACHMENT FIELDS. It slows everything down. After watching this video I have made nice hyperlinks to folders to take the end user to the documents I previously had in the attachment fields. I am now really enjoying the database I have created. Thank you for making your videos. I wish I could afford to be a member
Sounds great! Glad you like.
Thanks..!
Excellent Exercise
Welcome. :)
@599cd Do you have any advice/vids on the With statement?
This is one of those topics that I talk about in a lot of different videos but I don't have one specific video where I cover just that statement. It's on the list somewhere for its own video one of these days.
@@599CD I was just wondering your experience with it for declaring recordsets and other temp/one time objects.
what should i do if im asked to display a message asking the user if they want to view the query i created in one question :•if they do, the query i created in the Question should run •if they do not, the chart i created in another question should open.
this is related to creating a button in a dashboard in the database where i have to use a MsgBox
would be grateful if you reply 🙏🙏
I don't understand
Search how to make a clickable yes / no popup box in Access. On Yes open the query you created, on no open the chart you created.
How do we sum by partition in ms access select query?
I don't know what you mean "by partition."
Every time when I open my access file I should use VBA enable option "on" otherwise the file does not run the VBA program.
OK
See Richard's Trusted Location video: ua-cam.com/video/YDu4iqlci30/v-deo.html