Results 1 to 11 of 11
  1. #1
    mike12ophone is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Apr 2014
    Posts
    6

    Access Setfilter Error In Sharepoint! Months of frustration...have mercy.

    I have an access 2010 web form that I've uploaded to SharePoint but the filters (via SetFilter) are giving me an error, refusing to filter. Everything works in Access but the translation to SP is giving me problems.



    My form has a combobox dropdown which will make visible any one of six textboxes from which a user can input a search string that executes a filter via a command button which holds the code for the filter.

    I’ve attached a snapshot of my code. Through trial and error I've discovered that everything runs if I omit the & “*” at the end of the SetFilter Where condition. But in doing so I lose the flexibility I need for partial search strings returning the appropriate results.

    All of my data is text and text boxes formatting is blank.

    I've been at this for a very long time and its driving me crazy. Please can anyone help? I've also attached the error message I get in SharePoint and a cleansed shot of my form if it helps.

    Click image for larger version. 

Name:	Error.png 
Views:	11 
Size:	111.1 KB 
ID:	16048Click image for larger version. 

Name:	Code.png 
Views:	11 
Size:	90.3 KB 
ID:	16047Click image for larger version. 

Name:	Form.png 
Views:	11 
Size:	82.6 KB 
ID:	16046

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Never used SharePoint but one thread I found suggests:

    You have to have the field you are filtering as a control on the subform. If you don't want to see it, just hide it, but it needs to be there on the published database.

    I see you have a control labeled GRANTEE - is that a combobox with lookup?
    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
    mike12ophone is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Apr 2014
    Posts
    6
    I read the same. The table below the column headings is what's being filtered. GRANTEE is a field in the table. I just removed the data for the screenshot.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    This is not a form/subform arrangement?

    That GRANTEE control is not a combobox?

    Then I am at a loss as to why the filter fails.
    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
    mike12ophone is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Apr 2014
    Posts
    6
    The combobox showing Grantee activates a textbox (in this case, GRANTEEFilter) above each corresponding column of the table.

    This is frustrating as I feel that the logic is valid. There is just some SharePoint/Access interface issue behind the scenes that I'm not understanding that returns an error when I keep the & “*” at the end of the SetFilter Where condition. Everything runs perfectly in Access itself.

    Does anyone have any ideas on maybe another way to go about this? My goal is to be able to search from the textbox and return the filtered result.

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Do TempVars work with SharePoint published db?
    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
    mike12ophone is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Apr 2014
    Posts
    6
    Yeah I used TempVars to hide/display the search textboxes above each of the columns according to what is selected in the combobox.

  8. #8
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Now I see the TempVars use in the example.
    Then perhaps set TempVars to the value of textbox and use TempVars in filter.
    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.

  9. #9
    mike12ophone is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Apr 2014
    Posts
    6
    It works the same as calling the textbox directly and may come in handy in future applications (thanks for that btw) but it's still giving me the same problem. I cant get SP to take my & '*' at the end to allow for flexible searching. My only option may be to require users to input the exact search term or else, rendering this whole venture rather pointless.

    This is so weird...such basic functionality shouldn't be this hard!!

  10. #10
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    So wildcard is the issue.

    I searched Bing: Access web form sharepoint wildcard search

    Is this relevant
    http://www.sharepointdiary.com/2013/...harepoint.html
    http://social.technet.microsoft.com/...eneralprevious
    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.

  11. #11
    mike12ophone is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Apr 2014
    Posts
    6
    Hmm seems those aren't really applicable here. I'm not a 100% sure but they seem to be speaking to something different. Thanks for your help though.

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

Similar Threads

  1. Replies: 0
    Last Post: 03-24-2014, 09:35 AM
  2. Replies: 1
    Last Post: 03-18-2014, 04:07 AM
  3. Graph Frustration
    By libraccess in forum Reports
    Replies: 5
    Last Post: 12-11-2012, 12:28 AM
  4. Replies: 3
    Last Post: 05-30-2012, 01:43 PM
  5. Setfilter works in Access but not Sharepoint
    By estroud in forum SharePoint
    Replies: 1
    Last Post: 05-28-2012, 12:55 PM

Tags for this Thread

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