Results 1 to 13 of 13
  1. #1
    Sarah.M is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2021
    Posts
    17

    Save Filter as Favorite for each user by himself

    Hi, Plz note, My VBA is disabled in my pc, I can use only Expression builder, Macros, Queries, Tables, Forms and Reports only.



    1.For example, if I make any filter in that table and I like it and I want to save it as Favorite, I click on the save filter button then I can put name for that filter and his criteria saved automatically and then it will show up in my Favorite filter in drop down list (combobox). and then I can chose which filter I like from the list and run it after update

    2.and I want each user can make his own Favorite filter by himself and manage them to keep them or delete them etc..

    How can I do it, because it is going to save time to me by making favorite filters

    Plz help!
    Attached Files Attached Files
    Last edited by Sarah.M; 10-28-2021 at 03:50 PM.

  2. #2
    Sarah.M is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2021
    Posts
    17
    I could not upload my Sample Database, your website doesn't allow me

  3. #3
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    I would probably save them in a table.
    The table would be something like

    tblFilter
    FilterID
    FilterUserName
    FilterObject
    FilterString

    The use DlookUp() to see if one exists.
    Perhaps give an option of using 'favourite' filters ?

    I do not know why you cannot upload a file, you appear to have enough posts?
    Check size, type of extension. Always best to zip and upload unless very small.?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  4. #4
    Sarah.M is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2021
    Posts
    17
    Hi, Thank you for reply,
    Kindly, can you make sample to us, I appreciate it

    I will tell you why I need to save Filter as Favorite, it is for flexibility
    I make multi Filter everyday manually, so I make a button as shortcut when I click it he will SetFilter to me, to make it flexible, When I make filter and I know that filter am I going to use it everyday, I can save it as Favorite and then I can use it next time quickly by chosing that filter from ComboBox

  5. #5
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    Quote Originally Posted by Sarah.M View Post
    Hi, Thank you for reply,
    Kindly, can you make sample to us, I appreciate it

    I will tell you why I need to save Filter as Favorite, it is for flexibility
    I make multi Filter everyday manually, so I make a button as shortcut when I click it he will SetFilter to me, to make it flexible, When I make filter and I know that filter am I going to use it everyday, I can save it as Favorite and then I can use it next time quickly by chosing that filter from ComboBox
    No sorry. I might write the odd snippet now and again, but it would take me a while to code something to do that. I am not an Access developer.
    I tend to offer a way to solve a problem, and it is up to the poster to use it or not.

    Take it a step at a time, is the best I can suggest.

    Sometimes I might write some code if the problem intrigues me, but this is not one of those.

    However, forgot you do not have VBA for some strange reason, so how I would do it then, I have no idea.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  6. #6
    Sarah.M is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2021
    Posts
    17
    Thank you for your advice

  7. #7
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  8. #8
    Sarah.M is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2021
    Posts
    17
    By Macros please

  9. #9
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    WGM, first link maybe not right, or the site is down at the moment.
    Thanks for the heads up.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  10. #10
    Sarah.M is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2021
    Posts
    17
    Hi,
    How can I delete this Thread?

  11. #11
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    No, it was me. Fixed now.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  12. #12
    madpiet is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Feb 2023
    Posts
    122
    No idea how to do it with macros, since I never learned to use them.

    You could store them in a table with (UserName, FilterName, FilterString, ...) and then you could use a combobox to grab the one you want, and to pass it to something. (like a combobox, and then you'd point to that in your OpenReport/OpenForm's filter property. Might be a bit of a hassle sorting out which filters can be applied to which objects, because the recordsources can be tables or queries, so you might have to loop through the fields collection of the object to see if you can filter it like you want. (Sounds like a serious hassle!)
    But you could do it if you were seriously determined? Do it in a macro? LOL. Not a chance.

  13. #13
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    You're a bit late to the party? Last post before yours was 16 months ago.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Records in form been save but with different User
    By Jamibollah_abbas95 in forum Forms
    Replies: 2
    Last Post: 11-20-2020, 07:52 AM
  2. Many to many with a 'favorite'
    By jwaes in forum Access
    Replies: 9
    Last Post: 05-15-2019, 01:29 AM
  3. Replies: 5
    Last Post: 06-12-2018, 01:35 PM
  4. Replies: 1
    Last Post: 02-16-2018, 03:38 AM
  5. Replies: 3
    Last Post: 11-06-2015, 05:06 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums