Results 1 to 2 of 2
  1. #1
    estroud is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2012
    Posts
    1

    Setfilter works in Access but not Sharepoint


    I am using a text box to enter a name and on the after update event execute a macro to do SetFilter to help find the desired record. The code in the SetFilter is
    Code:
    [EmployeeName] Like "*" & Forms![EmployeeQuery]!Text55 & "*"
    . This works fine when running in ACCESS but doesn't work when running on the web. No error message - the data just all goes away. Any help would be appreciated.

    Thanks

  2. #2
    pdstroud is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2012
    Posts
    1
    [EmployeeName] is a field in a table, a field in a query or an expression ? That sounds like you might need to change it to the new "data macro" like this if it is an expression.

    http://social.msdn.microsoft.com/For...f-c8a691face0e

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

Similar Threads

  1. Replies: 3
    Last Post: 03-15-2012, 03:42 PM
  2. Access VBA to SharePoint
    By Lorlai in forum SharePoint
    Replies: 4
    Last Post: 06-27-2011, 10:35 AM
  3. Access 2003 and SharePoint
    By dbuck in forum SharePoint
    Replies: 3
    Last Post: 01-31-2011, 01:12 PM
  4. SharePoint and Access 2010
    By ksmith in forum SharePoint
    Replies: 4
    Last Post: 08-24-2010, 09:19 AM
  5. Replies: 11
    Last Post: 04-04-2010, 07:42 AM

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