How to set the ServerFilterByForm property in a run-time application in Access 2002 (283362)

SUMMARY

IN THIS TASK

• SUMMARY
• • Steps to Enable the ServerFilterByForm Property
• REFERENCES

To enable the ServerFilterByForm property in an Access 2002 run-time environment, you must use the following code snippet.

Me.ServerFilterByForm = True
Me.Refresh
DoCmd.RunCommand acCmdServerFilterByForm
				

You do not have to have a toolbar with the ServerFilterByForm button on the form in the run-time application.

back to the top

Steps to Enable the ServerFilterByForm Property

1. Create an Access project (ADP), and connect to the Pubs database.
2. Create a new form that is based on the Authors table.
3. Create a command button with the following code snippet:

   Me.ServerFilterByForm = True
   Me.Refresh
   DoCmd.RunCommand acCmdServerFilterByForm
   					

4. Open the form in Form view, and then click the button.
   
   NOTE: The form will still display all of the information for the Authors table, but the ServerFilterByForm button on the toolbar is now enabled.
5. Before you start the application in a run-time environment, make sure that you set the Startup form.
6. Create a shortcut that starts the project, and include the /runtime switch in the command line, as follows:

   "C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE" "C:\Program Files\Microsoft Office\Office10\Samples\Pubs.adp" /runtime

7. Test the database. If you only use DoCmd.RunCommand acCmdServerFilterByForm and do not set the property first, you will receive the following error message:
   
   In the retail version of Access:
   Run-time error '2046':
   
   The command or action 'ServerFilterByForm' isn't available now.
   In a run-time application:
   Execution of this application has stopped due to a run-time error.
   
   The application can't continue and will be shut down.

back to the top