Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Jan 2005
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Filter Error Message (2002)

    I am trying to build an Access Page with a filter button on the screen for our plants. The problem is I get the error 889200d and stops at the line secData.DataPage.IsFilterOn = True. This same access page works in a different access database. Any idea what the problem could be? I cannot see what the difference between the 2 databases is.

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Filter Error Message (2002)

    By "Page" do you mean a Data Access Page (viewed using Internet Explorer), or are you referring to an Access form? In general errors of the type you are encountering have something to do with errors in the Filter String - they look much like the WHERE clause of a SQL query, but without the WHERE.
    Wendell

  3. #3
    New Lounger
    Join Date
    Jan 2005
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Filter Error Message (2002)

    I am working with an Access page to view on Internet Explorer. Below is the code that is being used. I had exported the structure of the table to a second database for someone to build the access page. It works fine there but when I imported the access page to the original database it stopped working.

    Dim secData
    Set secData = MSODSC.GetContainingSection(CEB)
    If Len(txtCEBFilter.value)> 0 Then
    ' Set the filter
    secData.DataPage.Filter = "CEB =" & txtCEBFilter.value
    ' Turn the filter on and display the boxes
    secData.DataPage.IsFilterOn = True
    CEB.style.Visibility = "Visible"
    PlantName.style.visibility = "Visible"
    DateApprove.style.visibility = "Visible"
    End If

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Filter Error Message (2002)

    Unfortunately I am not proficent at using Data Access Pages - and very few of the loungers seem to be either. (Few people use the approach since you are restricted to using Internet Explorer to work with the data.) Nothing in the code jumps out at me as being suspect so I would guess the issue might be data related rather than a code problem per se. Can you determine what the value of txtCEBFilter.value is at the point where the error occurs?
    Wendell

  5. #5
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Filter Error Message (2002)

    Also, not having used Data Access Pages much at all, could it be a references problem?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •