Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms Programming / May 2008

Tip: Looking for answers? Try searching our database.

Allen Browne Search

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
pfm721 - 27 May 2008 14:56 GMT
I have modified the Allen Browne search form to filter the results of a
parameter query. The query gets its paramters from some of the fields on the
search form. It works but only if I type in the Locality parameter. For
Example:

User Enters

5 digit code in txtFilterCPTCode
Selects State from cboFilterState
Selects County from cboFilterLocality

The query uses the input from those three boxes as the paramters.
The query works great. However after entering a value in those three places,
when you select the filter button on the form I get a Dialog box that pops up
asking me to enter a parameter value for Locality. I can't figure out why it
is doing this as I selected it in my last combo box. If I enter the Locality
by hand in the box the form works. If I click cancel it asks me to Debug and
takes me to Me.Filter = strWhere which is highlighted.

The immediate window has this in it:

([HCPCS Code] = "45378") AND ([State] = "GA") AND ([Locality] = "Albany")

Looking at that it looks like it should have worked.

Thanks in Advance
Allen Browne - 27 May 2008 16:01 GMT
If your HCPCS Code field is a Number field (not a Text field), remove the
quote marks from around the value, i.e. generate:
   ([HCPCS Code] = 45378) AND ...

If is is a text field, it looks right. Mock up a query to see if there are
any results.

Signature

Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I have modified the Allen Browne search form to filter the results of a
> parameter query. The query gets its paramters from some of the fields on
[quoted text clipped - 28 lines]
>
> Thanks in Advance
Jan Baird - 27 May 2008 20:52 GMT
Jan Baird is out of the country until September 20.   Every effort will be
made to respond to messages, but please be patient.
Jan Baird - 27 May 2008 20:52 GMT
Jan Baird is out of the country until September 20.   Every effort will be
made to respond to messages, but please be patient.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.