Thank you for your great videos. When using Filters on Access, it displays actual Field Name instead of Captions. How can this be fixed? I dont want to change actual Field names into readable words with spaces
Nice vide as all of yours, Richard! A single word coming from the old times when I worked with Access and VBA (You know, I am retired seven years ago). I used the With... End With when dealing with several objects of the same report or form... I mean: instead of repeating Me.Name, Me.Caption, etc., I used With Me .Name .Caption... End With. My twopences!
the filtering in datasheet view being able to select from a drop down list multiple items is very helpful in sorting. Can this button be added to form in datasheet view in order to preserve this sortability.
Hi Richard. I have a question, I have a yes/no field in the form and I want to issue a command to change all filtered fields to yes, I have a query where I entered the criteria but I want it to be done based on the filtered fields in the form. Can you help me?
Hi Richard. Steven Faulkner from Australia (working in Thailand) love your videos. I can make this work easily from a main form, but I have tried without success to do it from a subform databsheet (easier filtering options) but keep getting errors in the VBA code. I can do it if I use a split form, but they're a bit of a pain. Is there a way to do this from the subform?
Great video--one question: I set every report up in my database this way, all worked beautifully, I walked away for two weeks and it stopped working! Now the reports respond to my filters, but not my sorts despite my OrderBy! Also, where I used to be able to sort reports with a right click, now that functionality is gone. I'm so confused--could this be the result of an update?
I could be. Updates have been doing some weird things lately. I would recommend running down the troubleshooter though to make sure first: 599cd.com/Trouble
I have tried this and it works but not on sub form any ideas i get message saying not supported. I can only assume i am not doing something quite right. Very helpful video thanks Richard
Good evening sir, your tutorial lessons are awesome, but I want to request for how to create student report card especially for a whole school with three terms of exams, thanks
Richard may I ask an unrelated question if I may please? Seeing as you are a huge Trekkie fan have you ever thought about making you Database forms look like the console screens on the Enterprise?
Thank you Mr. Richard
You are very welcome
Subscribed! This is EXACTLY the information I needed for a work project. Your videos are easy to follow. Thank you very, very much!
Welcome!
Excellent video. Thank you
Thank you for your great videos. When using Filters on Access, it displays actual Field Name instead of Captions. How can this be fixed? I dont want to change actual Field names into readable words with spaces
Nice vide as all of yours, Richard! A single word coming from the old times when I worked with Access and VBA (You know, I am retired seven years ago). I used the With... End With when dealing with several objects of the same report or form... I mean: instead of repeating Me.Name, Me.Caption, etc., I used With Me .Name .Caption... End With. My twopences!
Thanks
the filtering in datasheet view being able to select from a drop down list multiple items is very helpful in sorting. Can this button be added to form in datasheet view in order to preserve this sortability.
Thanks really helped me with your lesson , regards
Glad to hear that!
Hi Richard. What if the data source of the filter is an SQL statement?
This is valuable info. Will certainly be using this in all my Access DB's
Sweet
Very useful
Hi Richard. I have a question, I have a yes/no field in the form and I want to issue a command to change all filtered fields to yes, I have a query where I entered the criteria but I want it to be done based on the filtered fields in the form. Can you help me?
Hi Richard. Steven Faulkner from Australia (working in Thailand) love your videos. I can make this work easily from a main form, but I have tried without success to do it from a subform databsheet (easier filtering options) but keep getting errors in the VBA code. I can do it if I use a split form, but they're a bit of a pain. Is there a way to do this from the subform?
Great video--one question: I set every report up in my database this way, all worked beautifully, I walked away for two weeks and it stopped working! Now the reports respond to my filters, but not my sorts despite my OrderBy! Also, where I used to be able to sort reports with a right click, now that functionality is gone. I'm so confused--could this be the result of an update?
I could be. Updates have been doing some weird things lately. I would recommend running down the troubleshooter though to make sure first: 599cd.com/Trouble
I have tried this and it works but not on sub form any ideas i get message saying not supported. I can only assume i am not doing something quite right. Very helpful video thanks Richard
Super Awesome
Thanks
How can this form filtering method be used to define a query that can be used as the report's record source?
I think we already talked about this in the forums on my website
@@599CD I don't recall any mention of how to apply the form filter to build a query via QDF.
Great video Richard! I'm always trying to figure out how to make my code as "efficient" (i.e. less lines) as possible. 🙂
Thanks
Good evening sir, your tutorial lessons are awesome, but I want to request for how to create student report card especially for a whole school with three terms of exams, thanks
It's on my list
Shout out to Alex for shouting to you and correcting your habit. That made me laugh!
599cd.com/QQ
what is your office version please ..?!
Whatever the latest version of MS 365 was as of the time of this video
Richard may I ask an unrelated question if I may please? Seeing as you are a huge Trekkie fan have you ever thought about making you Database forms look like the console screens on the Enterprise?
If I had the time, sure. You can make your forms look like whatever you want: 599cd.com/Aesthetics
I'm not able to open report after adding the 2nd line of code
Well, try again. You must have missed something.