How do we populate automatically several columns at the same time without typing when selecting or typing a value in another column. Example if I dismiss a client on the Dismissal column as Yes or a dismissal date, then other other columns Start Treatment column as Yes, Eligible to Treatment as Yes, Accepted Treatment as Yes. Because when the client is dismissed or completed treatment the other columns should be Yes obviously. So it would avoid a lot repetitive typing and wasting time. Thank you for your generous education.
You can indeed do this using After Update. You just need to add an If statement. Something like this: If Me!Dismissal = "Yes" or IsNull(Me!DismissalDate) = False Then Me!StartTreatment = "Yes" Me!EligibleToTreatment = "Yes" Me!AcceptedTreatment = "Yes" End If If you have checkboxes then you might put -1 instead of "Yes" Good luck!
@@seanmackenziedataengineering I will work on it and tell you the outcome. Employees are breaking their hands because of unnecessary typing on semi bad design database that were created by somebody else.
If your form has 2 fields, short text and attachment types. How do you load a jpg on the attachment field based on the input of the text field? Assume text input is the jpg file name.
That's a great question! Generally, with Access databases it is better to put attachments into a file directory and only save the file path in a field in the Access database. This is because file storage is typically inefficient in comparison. You can store the path, then when a user wants to view the file, you can use Application.Followhyperlink or a few other methods to open the file from Access. That being said, if you really DO want to load files into attachments, you can use the .LoadFromFile syntax in VBA. I have not done a video on that so for this suggestion, I thank you! I will add it to my list.
Sean these are amazing. Thank you so much. One day, could you a do a video on single and double quotes and how to use with SQL statements and domain aggregate queries?
@@seanmackenziedataengineering OMG thank you so much!! Truly getting a good understanding of quotes and why they're always ruining my SQL statements (particularly with variables and stuff like DMAX criteria which needs to be wrapped in quotes) has been the bane of my existence, and the fact that Microsoft is basically nowhere to be found on this topic is crazy!
How do we populate automatically several columns at the same time without typing when selecting or typing a value in another column. Example if I dismiss a client on the Dismissal column as Yes or a dismissal date, then other other columns Start Treatment column as Yes, Eligible to Treatment as Yes, Accepted Treatment as Yes. Because when the client is dismissed or completed treatment the other columns should be Yes obviously. So it would avoid a lot repetitive typing and wasting time. Thank you for your generous education.
You can indeed do this using After Update. You just need to add an If statement. Something like this:
If Me!Dismissal = "Yes" or IsNull(Me!DismissalDate) = False Then
Me!StartTreatment = "Yes"
Me!EligibleToTreatment = "Yes"
Me!AcceptedTreatment = "Yes"
End If
If you have checkboxes then you might put -1 instead of "Yes" Good luck!
@@seanmackenziedataengineering I will work on it and tell you the outcome. Employees are breaking their hands because of unnecessary typing on semi bad design database that were created by somebody else.
Hi and thanks. is it possible to make the automatic generating timetable of exam and teaching for students and professors in access database?
Yes, you can do this in Access! It is a good tool for this use case.
If your form has 2 fields, short text and attachment types. How do you load a jpg on the attachment field based on the input of the text field? Assume text input is the jpg file name.
That's a great question! Generally, with Access databases it is better to put attachments into a file directory and only save the file path in a field in the Access database. This is because file storage is typically inefficient in comparison. You can store the path, then when a user wants to view the file, you can use Application.Followhyperlink or a few other methods to open the file from Access.
That being said, if you really DO want to load files into attachments, you can use the .LoadFromFile syntax in VBA. I have not done a video on that so for this suggestion, I thank you! I will add it to my list.
@@seanmackenziedataengineering ope you do it soon!
Sean these are amazing. Thank you so much. One day, could you a do a video on single and double quotes and how to use with SQL statements and domain aggregate queries?
Added to my queue. This is a actually a great idea for a video, thanks!
@@seanmackenziedataengineering OMG thank you so much!! Truly getting a good understanding of quotes and why they're always ruining my SQL statements (particularly with variables and stuff like DMAX criteria which needs to be wrapped in quotes) has been the bane of my existence, and the fact that Microsoft is basically nowhere to be found on this topic is crazy!
How to open an Access database table and form and modify it in the form of an exe executable file
You can make a "locked" version of your app by converting it to accde; then give it to users.
Thanks
No prob!
Wala
As always ❤
Thanks!
First! You da man!!!
Glad that worked for you!
Great
Glad you liked it!