Search results

  1. H

    Possible to filter by form using a command button?

    I haven't heard back from anyone about this. Here's what the macro commands look like for my Filter by Form button. This is the button on the main dashboard which opens the search form in Filter by Form mode. Is this where the command line about focus needs to go? What is that code...
  2. H

    Grouping with information from multivalue fields

    CJ_London, thank you so much for your included link with information about Multivalue fields. It turns out the answer for the rest of my queries was in the information at that link, and the solution is laughably simple. Instead of using the actual field name of multivalue fields in group and...
  3. H

    Grouping with information from multivalue fields

    I have a table set from which the people's names are added to the multivalued field, which will just populate the control to keep up with any new additions. However I can see where doing this by having to specify the specific "X" would be a bit of a pain. Is there a way to make the code you...
  4. H

    Grouping with information from multivalue fields

    Greetings Greater Gurus! I have a table which now contains a couple of hundred records with more than thirty fields each, and will ultimately contain over 1000 records. Some of these fields use the multiple value feature, and the fields and the forms which fill them work beautifully. Now...
  5. H

    Filter button in form

    I thought I had seen replies to this. I have a similar situation. I have set a form to open from a button on a dashboard in Filter by Form mode. The form opens exactly like it's supposed to, allowing entering of multiple criteria in multiple controls. However, the button I created on the form...
  6. H

    Possible to filter by form using a command button?

    Gemma-the-Husky, thank you for your reply. I'm not exactly sure where this code should be entered. Should the screen and focus command be entered in the button where the command is to open the search form in Filter by Form mode? Should it be in another location in the properties of the form...
  7. H

    Filter button on access form

    I sense this is really getting close to what I need. I have a dashboard for my database with a button for users to click to open a search form. Upon clicking it, the search form opens in Filter by Form mode, exactly like I want. But the command buttons are greyed out. I saw several coding...
  8. H

    Possible to filter by form using a command button?

    Right. The form is open in the Filter by Form mode, allowing entering of criteria for search in any of the controls. The button that is supposed to run the filter isn't accessible right now...it's grey. However, the search happens exactly as I want it to if I click "Toggle Filter" in the ribbon.
  9. H

    Possible to filter by form using a command button?

    Thanks a lot, pbaldy, for your help. I found a setting in the form that was not allowing filters. Once I changed that to "yes" I was able to make the form open as I want. It does allow searches based on multiple criteria from multiple fields. Unfortunately, I haven't been able to run the...
  10. H

    Possible to filter by form using a command button?

    I understand that that's what your directions did. I don't want to create another query or query set...I just want to automatically open the form in the filter by form mode. The filter by form mode handles the criteria exactly like I want to. It opens a blank form, allows me to select any...
  11. H

    Possible to filter by form using a command button?

    I guess I'm being dense or something. I'm not clear how the SQL directions apply to what I need to do. I have never done any programming in SQL. I have the form already created which I want to use for the filter capability. What I want to do is to click on a button in a dashboard and have it...
  12. H

    Human verification at registration

    Hi, Folks, When I first came to these hallowed halls, I was unable to register. It appears that some security setting or other at my workplace made it so that neither the graphic that needs to be responded to nor the text box to respond showed up on the registration screen. I wrote a couple...
  13. H

    Now who the heck introduces themselves...

    Thanks for the welcome, Folks! Keep on Smilin'! Don (er, Hagridore :))
  14. H

    Possible to filter by form using a command button?

    Okay, folks, I suspect I'm going to need something a bit more specific. Here's what I want to do. I want to program a button on a dashboard so that it will open a search form that is a replica of my main data entry form in Filter by Form mode. My users need to be able to type in any...
  15. H

    Now who the heck introduces themselves...

    ...in computer software forums? People like me who hope to really get everything out of it they can, that's who! :-) My name is Don Naff. I've messed around with all of Microsoft Office pretty well since its carving in stone tablets from a mount...oh, sorry, but MS Office seems to've been...
Back
Top Bottom