Results 1 to 7 of 7
  1. #1
    sdballer is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2014
    Posts
    4

    Help with sorting/filtering

    Hello,

    I was hoping someone could push me in the right direction on filtering some fields. I am using a MS template "Project Database"
    Currently they have tabs Open Projects and Closed Projects. Both are using the Status field in combination with the Active (Yes/No) fields. The tabs form properties are using [Active]=False & [Active]=True, for those project tabs. My issue is that I am looking to add a new tab with "Current Projects" that would look the same as the others, but filter by [Status]... I was hoping it would be just as easy as [Status]=Current... but doesn't work. Can someone please help! =) thanks!


    Click image for larger version. 

Name:	Capture.PNG 
Views:	12 
Size:	11.8 KB 
ID:	18591

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,633
    Is this the web version? Do you really need web version? They are harder to modify and limited to macro coding.

    Form modifications are done in Layout view.

    That is a Navigation form which compounds the difficulties.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    sdballer is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2014
    Posts
    4
    Yes, its the web version and I do need it. For some reason when I do [Status]="20" as the value I need for "Current" it works for a moment, but then when I switch tabs, it defaults back to [Active]=False.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,633
    That would be expected behavior.

    From what little understanding I have of Navigation form/control, only one subform at a time is active. So each time you click a tab, current active subform is unloaded and another is loaded. The filter criteria is applied during load.

    Might find this of interest https://www.accessforums.net/forms/t...orm-32053.html

    Possibly you need to create a new tab for dynamic filtering on Status field. This tab would have a query or form as target object. The filtering would be by a dynamic parameter in query which is set by popup input or referencing a control on the main form for user input and macro code behind the control to requery the form. I am really grasping here because never built web db and don't use macros, only VBA.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    sdballer is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2014
    Posts
    4
    It's unusual because the filter gets deleted and replaced with another. Once i go back into the form properties, its reverted.

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,633
    I don't know what that statement means. My understanding of Navigation form and web db is very limited (put the two together and I am really lost). I can't even find how the form is filtered by True or False.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  7. #7
    sdballer is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2014
    Posts
    4
    I uploaded my database. The Current Projects tab is correct, except I don't want it to show Carry Forward. The Carry Forward tab is showing the same as Current, which should only be Carry. Canceled/Discontinued is working correctly.

    Any help would be much appreciated. Thanks!
    Attached Files Attached Files

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

Similar Threads

  1. Sorting/Filtering a continuous form
    By Reaper in forum Forms
    Replies: 3
    Last Post: 01-30-2013, 03:07 PM
  2. Replies: 11
    Last Post: 01-12-2012, 07:55 PM
  3. Sorting/filtering by year and then month
    By Remster in forum Queries
    Replies: 1
    Last Post: 11-08-2011, 07:10 AM
  4. Filtering/sorting data
    By jemelton in forum Access
    Replies: 5
    Last Post: 06-09-2010, 01:47 PM
  5. Need Sorting Help
    By rbpd5015 in forum Access
    Replies: 1
    Last Post: 09-28-2009, 07:39 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