Search results
-
M
Query not combining and filtering values based on a form
That totally did it. Thank you again Gina. -
M
Query not combining and filtering values based on a form
Hi Gina, I'm sorry to bother you again but if I wanted to sort the month-year combo box, how could I do that? I have tried selecting “Ascending” through the query but that didn’t work. Presently the sql for it is: SELECT Format([Purchase_Date],"m-yyyy") AS MyMonthYear FROM Equipment GROUP BY... -
M
Query not combining and filtering values based on a form
:) Yes it's working! :) Thank you for walking me through that! Again, could not have done it without. -
M
Query not combining and filtering values based on a form
Wait, I think I just did it! I created a report of off an unfiltered query and named it rptSupplierDescriptionCodeqry. Then I modified the bottom of the code to this: lngLen = Len(strWhere) - 5 If lngLen <= 0 Then 'Nah: there was nothing in the string. DoCmd.OpenReport... -
M
Query not combining and filtering values based on a form
I think I did it wrong. This is the code that I ended up with after modifying it. It's opening up a report by it doesn't seem right. Private Sub cmdOpenReport_Click() 'Purpose: Build up the criteria string form the non-blank search boxes, and apply to the form's Filter. 'Notes... -
M
Query not combining and filtering values based on a form
So I would create a command button on the other query and on the On Click I would add this code and modify it to the other query? Private Sub Command34_Click() 'Purpose: Build up the criteria string form the non-blank search boxes, and apply to the form's Filter. 'Notes: 1. We... -
M
Query not combining and filtering values based on a form
The button you created to export the filtered results to a report, is that created by the standard create a 'macro' button on the ribbon? Maybe not, I just looked at the code and you added code to the VBA to do that? The reason I ask is bc I would like to do the same to the other query. -
M
Query not combining and filtering values based on a form
Works beautifully Gina! You really know your stuff! Thank you again for your time and effort. -
M
Query not combining and filtering values based on a form
When I debug it hightlights this in the code: Me.FilterOn = True -
M
Query not combining and filtering values based on a form
Yeah, I'm using v5 in frmMultiSelectqry when I filter on any Supplier I get a "Run-time error '3464' Data type mismatch in criteria expression" -
M
Query not combining and filtering values based on a form
Could that be what's triggering the run time error when filtering on Supplier name? -
M
Query not combining and filtering values based on a form
Ah I see. I understand now. -
M
Query not combining and filtering values based on a form
I'm sorry, I'm affraid I still get the same error message when I filter on Supplier. "Run-Time error '3464' data type mismatch in criteria expression" -
M
Query not combining and filtering values based on a form
err wait Supplier table was already in the query? You linked the fields? Err, I'm not really sure what you did to fix it? :confused: -
M
Query not combining and filtering values based on a form
I'm trying to follow what you did so I understand it. You added Supplier table to qryMultiSelect and linked Supplier_Name with Supplier_ID. Correct? -
M
Query not combining and filtering values based on a form
I understand. I created this db before we started talking so I didn't know as much as I know now. I tried filtering on Supplier name and I get an error message. "Run-Time error '3464' data type mismatch in criteria expression". The filtering on Project name works and when I create a report... -
M
Query not combining and filtering values based on a form
Oh my gosh! I didn’t even notice you added a create a report button. That’s great! Thank you! -
M
Query not combining and filtering values based on a form
It's still the same. Whenever I create a new report only the number comes through not the Supplier name. Would you mind trying to create a new report on a filtered query in frmMultiSelectqry? Filter on anything you like. -
M
Query not combining and filtering values based on a form
The report I created is called rptMultiSelectqry the Supplier name is a number. But if you create any filtered Report off of frmMultiSelectqry, only the Supplier name comes through, not the name.