Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    Indiana
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access Runtime Problems

    I have a really straight-forward database which our organization has chosen to put on a LAN for multi-user use. Due to licensing conflicts and limitations we do not have the full version of Access on all of our 700+ PC's. We do however use the free Access 97 Runtime application which allows for the running of databases on most PC's. The problem I am having is one of my main reporting functions does not like the Runtime app. Specifically I have a form set up to Filter on any of 10 different controls that, based on information returned, then feed a report.

    My problem is that the I cannot get the "Filter By Form" option to work in Runtime. In the full version it will "knock the socks" off of you. I have designed a custom toolbar specifically for this form, however no matter how I code the specific "Filter By Form" button, including the use of the old standby Macro, I cannot get it to set the form up for selecting the filter criteria.

    Stumped.

    As always I appreciate the excellent results you feed back. <img src=/S/fire.gif border=0 alt=fire width=15 height=15>

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Access Runtime Problems

    Post the code you're trying to use. Runtime applications don't have access to some of the built-in stuff in libraries that can't be redistributed, so you have to program around them. If you show what doesn't work, someone should be able to come up with alternatives that do.
    Charlotte

  3. #3
    Lounger
    Join Date
    Jan 2001
    Location
    Indiana
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Runtime Problems

    Here is the code being used.

    Private Sub cmdSetFilter_Click()
    On Error GoTo cmdSetFilter_Click_Err

    DoCmd.RunCommand acCmdFilterByForm


    cmdSetFilter_Click_Exit:
    Exit Sub

    cmdSetFilter_Click_Err:
    MsgBox Error$
    Resume cmdSetFilter_Click_Exit

    End Sub

  4. #4
    New Lounger
    Join Date
    Jun 2001
    Location
    Louisiana
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Runtime Problems

    Article ID: Q262094 on the Microsoft Knowledgebase site says that Filter By Form is not available in the Runtime version.

Posting Permissions

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