Recent content by JimL

I have created a "saved imports" file for importing a txt file into my database. I am attempting to create a macro to automate the process with the ImportExportText action. When I come to the 'Specification Name' field, the dropdown list is empty. Will not allow any effort to manually...

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

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...

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

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...

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

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

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...

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

No, just to display. Thanks Jim

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...

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!

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?

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

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