Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. vtandi

    Use Dcount on form filtered with parameter query

    Please disregard previous post. I played around with relationships and it seems to be working now (even though I'm pretty sure I put everything back the way it was???) :>) Andi
  2. vtandi

    Use Dcount on form filtered with parameter query

    Michael, I was so thrilled that the filter was working correctly, I did not notice that the user was unable to edit the form. This even though I have the Allow Edits, deletions, additions and data entry properties of the form all set to yes. It is probably something obvious I have failed to...
  3. vtandi

    Use Dcount on form filtered with parameter query

    Michael, I can't thank you enough for all of your work on this. I like your form. It is pretty swift. Will probably continue to use the menus because I am going to need them to be able to filter on quite a few other fields. However, I am going to save your version (and the code) for future...
  4. vtandi

    Use Dcount on form filtered with parameter query

    Michael, I can't thank you enough. The version that I sent you did not have the custom menu bar. Basically, the users will work from the Referral form, the menus will be <Referrals>, <Patients> and <Reports> and the options under these will lead to the unbound parameter selection forms (e.g...
  5. vtandi

    Use Dcount on form filtered with parameter query

    Michael and Duane, So, I have lost the parameter queries per Duane's advice and am now using a small pop-up form where the user can select their parameter. This morning this seems to be working though last night I couldn't get the unbound lookup field to match the values in the lookup field in...
  6. vtandi

    Use Dcount on form filtered with parameter query

    Thank you both. I have been tasked with creating a database YESTERDAY. Also, I am a VB novice and have not even made an Access application in over 2 years. So,,,,,rusty. I was hoping to avoid code and use macros. Currently, I am using a custom menu item that runs a macro that: Selects the...
  7. vtandi

    Use Dcount on form filtered with parameter query

    In my DB [Referrals] I have a form [FRM_Referrals] that users can filter based a parameter query. I am using a macro with the ApplyFilter command to accomplish this. The problem is that when no records match the user's criteria, a blank form is displayed. I have searched for solutions and...

Part and Inventory Search

Back
Top