Search results
-
M
Query not combining and filtering values based on a form
This is the SQL of the query in the Record Source of the form. SELECT Equipment.Project_Name, Project.Material_Month, Project.Material_Year, Equipment.Unit_Cost, Equipment.Quantity_Purchase, [unit_cost]*[quantity_purchase] AS Total, Equipment.[Location/Affiliate_Name]... -
M
Query not combining and filtering values based on a form
Sorry I selected the wrong button to insert code :o Hope this is easier to read. 'Purpose: This module illustrates how to create a search form, _ where the user can enter as many or few criteria as they wish, _ and results are shown one per line. 'Note: Only... -
M
Query not combining and filtering values based on a form
Copied over the Clear button command. But I'm not sure I have the code correct for the Set Filter button. I tried running the query and I'm getting a "Run-time error '3464': Data type mismatch in criteria expression". I click on the debug button and it takes me to the code and highlights... -
M
Query not combining and filtering values based on a form
Just to make sure I'm doing the right thing: I copy the three command buttons you have on the frmMultiSelectqry and paste them on to the frmSupplierDescriptionCodeqry. Then I copy the code you just posted into the Event Procedure of the Set Filter command button in... -
M
Query not combining and filtering values based on a form
Wait, I don’t have any command buttons on the form yet. Should I copy and paste the three that you have on frmMultiSelectqry onto the new form? And add the new code to the event procedure of Set Filter command button? -
M
Query not combining and filtering values based on a form
Yes, it does. And added it as the Record Source to the form property. -
M
Query not combining and filtering values based on a form
I looked on the form you created (frmMultiSelectqry) and the form Record Source is set to qryMultiSelect. So does that mean I should set the Record Source for the new form (frmSupplierDescriptionCodeqry) to point to the new query I created (qrySupplierDescriptionCode)? -
M
Query not combining and filtering values based on a form
"Is this Madeup code the name of the feild in the query in the Record Source of femSupplierDescriptionCodeqry? " Madeup Code is the name of a field in Test code Query, but the Record Source of the form is empty. And the Madeup Code is just that it only exists in the query, it's not an actual... -
M
Query not combining and filtering values based on a form
Yes, that is Correct -
M
Query not combining and filtering values based on a form
Ok I was told that 'they' would like to search by Supplier name, Description and Madeup Code. I just combined Description and Madeup Code in the same drop down because they are one in the same. It didn't make sense to me to have Description and Madeup Code in two different combo boxes because... -
M
Query not combining and filtering values based on a form
In the form (frmSupplierDescriptionCodeqry) I now have two unbound combo boxes (cboSupplier and cboEquipment). cboSupplier has it's row source as: SELECT [Supplier].[Supplier_ID], [Supplier].[Supplier_Name] FROM Supplier ORDER BY [Supplier_Name]; cboEquipment has it's row source as... -
M
Query not combining and filtering values based on a form
Sort of, I only need two of them: one to search on Supplier (so that's just an unbound combo box that has a look up to the Supplier table to get it's values, correct?) but the other combo box would need to be a combination (two columns) of the Description along with the Madeup Code for that... -
M
Query not combining and filtering values based on a form
Post 49 was not a reply. I need to make another form just like the one you created but with different fields. And I've tried to understand how you created the first one but am not able to adapt that form to the new form I need to make. I've already created the query and have setup a basic... -
M
Query not combining and filtering values based on a form
Yes, it's on the report. I'm making a report out of the results of the form when it's filtered. -
M
Query not combining and filtering values based on a form
Well, I knew this would happen. I need to make another query just like the one you created for me but with different fields to query on. I reread how you explained how you created the code, but I'm just not understanding how I can adapt what you created to this new query :confused: I already... -
M
Query not combining and filtering values based on a form
"Oh, then you need to copy that SELECT line to the corresponding Row Source in the Filtere QUery, that should fix that issue!" I'm sorry to say that it didn't work :( Still only the AutoNumber not the name. Automation sounds great but I think I will leave that for when I get a little more... -
M
Query not combining and filtering values based on a form
Where would I find the SQL code for you to look at when I run a filtered and unfiltered Report? The one thing I can see different between the two reports is in the property sheet, the Row Source for Supplier Name field in a report: Unfiltered query (which displays the supplier name): SELECT... -
M
Query not combining and filtering values based on a form
That's it! Added Description field to qryMultiSelect. Then added it to the detail section of frmMultiSelect and saved all. Opened the form back up and it works perfectly! Thank you!!! Just a couple more questions and I promise I will leave you alone and stop asking questions. Do you know... -
M
Query not combining and filtering values based on a form
Gottcha. Yes, would like to add Description field to the query results. -
M
Query not combining and filtering values based on a form
Okay changed qryDropDownTest to qryMultiSelect. And the form name is frmMultiSelectqry. And I got rid of DropDown qry test. Phew! Now the Record Source in the form automatically changed to qryMultiSelect. Nice, I didn't even know I had that feature selected to track auto update :) Where is...