Search results

  1. J

    Attach an existing VBA sub to a new button

    I have looked at various searches on this but have not been able to determine how to create a button and then associate it with an existing VBA sub. ` Can anyone help, please? Thanks
  2. J

    how to query multiple criteria when one or more are null

    I probably stated the request incorrectly. I have a database that has fields: Store Sales Category Features Category Product name Order I would like to be able to have a form that uses combo lists showing stores, sales categories, and product name to drill down as needed. I cannot figure out...
  3. J

    how to query multiple criteria when one or more are null

    Thanks. Can I filter on numerous criteria in the report?
  4. J

    how to query multiple criteria when one or more are null

    Good day, all. I have a form that has multiple fields from which to include in a query, but can only query on one criterion at a time. I would like to query on any combination of the criteria. This would include the possibility of some fields being blank. I would appreciate suggestions on...
  5. J

    creating a histogram query

    Good evening all, I have scoured sources and not been able to find how to set up simple histogram queries. Can anyone shed some light, and perhaps a sample database? THanks JimL
  6. J

    multiple column forms

    Thank you once again. It worked as advertised. Have a great week! JimL
  7. J

    multiple column forms

    Thank you. This solution works wonderfully. The singular issue I have is that on both subforms, the first record has what appear to be navigation icons (up and down arrows). Is there a property that I can change to get rid of it? Since the arrows don't do anything, they are nothing more than...
  8. J

    multiple column forms

    Not to seem obtuse, but how do I create a multi-column report?
  9. J

    multiple column forms

    No, just to display. Thanks Jim
  10. J

    multiple column forms

    Good day to you all! I have a query that generates 50 records summarizing the count of observations per center. I want to display all the results on one form page, splitting the results into 2 columns. Is there a way to do so? I can set the query to display the top 25 records, but don't know...
  11. J

    Eliminate record count bar at bottom of a subform

    Eureka! Found the nav options when I right clicked on the subform rather than selecting the subform and looking at the properties sheet. Can't explain why that happened. Thanks again!
  12. J

    Eliminate record count bar at bottom of a subform

    Thanks to both of you for your replies. Unfortunately, there is no Navigation Buttons property that I can find in the subform properties sheet (I am running Access 365). Would it be of any help to send a screenshot of the "All" tab on the properties sheet?
  13. J

    Eliminate record count bar at bottom of a subform

    Hello all, I have a subform which will not be navigated (entire records will be visible at all times). I want to eliminate the frame and the record count bar so that the subform will look like part of the main form. Can this be done? Thank you. JimL
  14. J

    New member JimL

    PTC is the next town over from where I live. (Sharpsburg)
  15. J

    New member JimL

    Well, I thought I was deep in the south in Atlanta, but clearly, you have the crown. Like you, I am retired (a couple of years) and the proud "Pops" to 5 grandchildren all 3 years or younger with one on the way. My wife works from home so she has no choice but to put up with me!
  16. J

    passing listbox selection to a query

    I am using the macro builder behind the button. The first action is refresh and the second action is to run the query. Thanks
  17. J

    passing listbox selection to a query

    Thanks so much, Isladogs! The solution works. I am faced with the fact that the criterion passed to the query appears to remain in memory even though I have added a refresh command before the openquery command. The form needs to be closed and re-opened before a new listbox entry can be passed...
  18. J

    passing listbox selection to a query

    I have created a listbox named CenterCombo which contains a field called 'LocationName1'. I have used the following criterion in a query containing the field LocationName1: [Forms]![Center Level]![LocationName1] Unfortunately, the query returns only the records associated with the first name...
  19. J

    New member JimL

    Good day, all. I am an experienced Access user who has lapsed use for the past few years and as a result, have forgotten much. I will be posting some perhaps rudimentary questions for a few weeks, and hopefully, my lost skills will return! I look forward to interacting with y'all (forgive my...
Top Bottom