Search results

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)

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!

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

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

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

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