Troubleshooting an Access Application 
Author Message
 Troubleshooting an Access Application

I have been trying to write a small program that would allow me to filter
my records in a form for Access 2.0. I am getting a Parameter Input Box
popping up when I run this module and I would like to automate the
parameter by having the user indicate a limit in an unbound combo box
prior to filtering. Here is the portion of the program in question:

Sub Search_Click ()
[Year] = Y
[Type] = T
[Number Query] = Q

Select Case T
    Case Applications
            DoCmd GoToControl "Applications 95"
            DoCmd ApplyFilter , "[Applications 95] > ""[Number Query]"

End Select

End Sub

The [Number Query] value is set before the user submits the filter
request; however, a parameter box pops up and requests that the user enter
in the limit for a second time. I would like to use the ApplyFilter
command properly, but I don't have a comprehensive resource to fully
understand its usage. If you could steer me in the right direction, I
would appreciate it very much.

Kevin M. Riordan                "One should follow the wise, the intelligent,

                                the noble; one should follow a good and wise
                                man, as the moon follows the path of the stars."

Sun, 21 Nov 1999 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Troubleshooting: Error Loading DLL

2. Real TroubleShooting

3. Combo Box troubleshooting

4. Troubleshooting Error when attempting to open windows address book

5. APC troubleshooting

6. Troubleshooting Conflict

7. Help troubleshooting Timex Datalink watch support

8. watermark troubleshooting

9. Troubleshooting DocumentBeforePrint

10. Page Fault troubleshooting guidelines

11. Troubleshooting Clearing Text

12. Microsoft Posting Acceptor troubleshooting


Powered by phpBB® Forum Software