Access Runtime Problems

Topic

New Reply

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.

Reply | Quote

Replies

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.

Reply | Quote

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

Reply | Quote

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

Reply | Quote