Results 1 to 11 of 11
  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
    1,611
    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?search_query=debug+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
    1,611
    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?search_query=debug+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
    1,611
    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?search_query=debug+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 online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    10,139
    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
    1,611
    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?search_query=debug+access+vba



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