Search results
-
M
Query not combining and filtering values based on a form
Hi Gina, I’ve taken it upon myself to try and incorporate the code you supplied for the date filter into the existing code in the Event Procedure under the filter button, but it does not seem to work. The year filter seems to work but not the other date filters. Would you mind taking a look at... -
M
Query not combining and filtering values based on a form
Wait, I'm confused. I don't understand what I'm supposed to do? I keep the code that I have already? The code now does not have a date filter on it. -
M
Query not combining and filtering values based on a form
So I'm replacing what's behind the filter button now with what you just posted? This is what's there now: '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... -
M
Query not combining and filtering values based on a form
I totally understand. -
M
Filtering values for one combo box off of another
I was able to add more fields to be referenced in the subform AND was able to apply everything that we did with the IC fields (ICContainerType, ICContainerCode...) to the OG fields (OGContainerType, OGContainerCode...) So I am really happy about that! -
M
Query not combining and filtering values based on a form
No, I still need help. This was adding the date filter to the existing form named frmSupplierDescriptionCodeqry, that you helped me create. I've added the two combo boxes and two text boxes to the form and this is the SQL of the query: SELECT Equipment.Project_Name, Equipment.Unit_Cost... -
M
Filtering values for one combo box off of another
I thought so, the change in color should have been another clue for me. So that's kind of like the // in Java when you want to add a note in the code. Now I know what you mean by cleaning it up and making it look pretty :) Ok I'm going to start adding other fields/tables to reference in the... -
M
Filtering values for one combo box off of another
Curious, in the After Update procedure code in the first combo box, why is there an apostrophe before the code "cboICContainerCode.RowSource" or does it make a difference? Me.cboICContainerCode.Requery ' cboICContainerCode.RowSource = "ContainerType.Container_Code " & _ "FROM... -
M
Query not combining and filtering values based on a form
Ok I wasn't sure if I needed to create a new query or add the formatted date fields to the existing query that the form runs off of. So this is the SQL of the existing query with the formatted date fields added. I also added the actual date field in there, should it be? SELECT... -
M
Filtering values for one combo box off of another
OK found the design grid for query1. Now, like you said, when I add fields to the table it will automatically be added to the query and I should be able to reference the new field in the subform (and I wouldn't need to bring that field down in the design grid to do that?). But what if I need... -
M
Query not combining and filtering values based on a form
Okay, SQL for the query (qryDate): SELECT Year([Purchase_Date]) AS MyYear, Format([Purchase_Date],"m-yyyy") AS MyMonthYear FROM Equipment; And added the 2 combo and 2 text fields on the form (frmSupplierDescriptionCodeqry) -
M
Query not combining and filtering values based on a form
Also added the two combo boxes and text boxes to the form. -
M
Query not combining and filtering values based on a form
So I'm creating a whole new query. But it will be used in the existing form. Correct? This code is getting error messages: MyMonthYear: Format([Purchase_Date]."m-yyyy") -
M
Filtering values for one combo box off of another
Yes you are right I need sleep. I will look over more closely tomorrow. Thank you Gina. -
M
Query not combining and filtering values based on a form
Wait, I'm sorry, I think I didn't explain properly, the date filter is going on the form that you helped me create, frmSupplierDescriptionCodeqry. Which has two filters on it already. So in the query I'm bring in the table with the date field and i'm adding that to the design grid then I'm... -
M
Filtering values for one combo box off of another
Oh, Ok I think I'm starting to get it. It is making more sense. So the first combo the Row Source was still able to be Grouped By Container_Type. But the second combo with the Query1 you were able to bring in Container_Dimensions. I know there is a lot more to it, I'm just tired and need... -
M
Query not combining and filtering values based on a form
Yes, that would be great! I think that would cover everything. -
M
Query not combining and filtering values based on a form
Not sure. Mainly concerned with the month and year equipment was purchased and associated with a project. But that piece of equipment will be purchased maybe several times over the span of a project. So it's purchased once this year and next and the year after and would like to see the... -
M
Filtering values for one combo box off of another
I see in the After Update you've added: Me.cboICContainerCode.Requery But I'm not sure I'm following what happened. How does Query1 fit in? I see SQL code for it but I'm not sure how it fits in to the form? The form already has a query in the Row Source. Now the Row Source is back to it's... -
M
Query not combining and filtering values based on a form
I'm sorry to be asking this at this time but would you be able to walk me through adding another filter to frmSupplierDescriptionCodeqry. It's a date field and I've already added the field to the table and adding the field to the query and to the subform, I would just need to add the filter to...