Recent content by freidaf

Thank you!

bastanu, I commented out the ApplyFilter line and did NOT get the error. Must have done something wrong the first time because the line was not commented out. Problem solved. Thank you very much!

Thank you for the suggestion. I will give it a try. Could you share the macros in your example? Thanks again!

Thank you bastanu, but I am still getting the same error.

Hello, I have a form that contains 2 multi select listboxes. The form opens a report filtered based on selections from the listboxes. I am trying to use a function by Duane Hookum that I found online but I am getting an error message: 2491: The action or method is invalid because the form or...

arnelpg - I have already tried your suggestion. When widths are set as you instructed, no data appears in the drop down box. Thank you for your input. I am going to see if I can post the structure of the database on Monday. Thanks to all..

Gasman good suggestion. I'll check with my manager on Monday to see if I can do that. Thanks!

Hello, I'm sorry, I didn't have time to log in yesterday. My tables don't contain any lookup fields so that's not the issue. Also, since my database is on my work PC I am unable to post a copy due to company policy. I did find a work around though. I created a text box and set the visible...

I'll try to post it tomorrow. I will have to mock up some data. Thank you so much for your input.

I thought I posted a reply but I don't see it so excuse me if it appears twice. My bound column is 1. I have deleted and re-created the combo box several times with the same result. I attached some print screens of my form and query if that will help. My other 2 combo boxes work fine, so...

Hello, I have a combo box on my form that is populated based on the value of 2 other combo boxes on the form. It has 2 columns, the Key field which is set to 0" width, and the MachName field which is set to 1" width. My problem is that when the key field (column 1) is set to 0" width...

Thank you pbaldy, this information is great! Mark thank you as well for the good advice. I appreciate your help!

Thank you both for your replies. I got it to work by doing as pbaldy suggested. It worked but it's more ugly than before! Thank you again for your help!

Hello, I have a query that obtains some of its criteria from a popup form. If the criteria fields on the form are left blank, all records are returned for that field. It worked fine until I added criteria for the date range: (((tblQDetail.QD_ProdDte) Between...

Thank you both for your replies. I do have a date field in my table. I think I need to re-think my query and add a field with a running sum by day. Then I can determine the date that the file reached 100%. I am going to give it a try. Thanks so much for your help!