Recent content by Finance

I created a new public module and put the function code in it and I put GetFilter() in the criteria of years_Strategy in the total_largeEntitycosts query. but its sayings it an undefined function.

Where did you put the function code? You could try changing it to a public function and place it in a module

Thanks for this, Ill try it out! the query is a master query that feeds into a report. I want the user to be able to filter the report based on the selection of years. I figured altering the query would be a lesser hassle that creating a parameter filter on the report itself.

should I put this code in the OnLoad event of the form? Can this code be written in the form of an expression instead of VBA?

Just one question, how do I make the sheet stay unfiltered by year if there are no inputs in the form ?

it worked! thanks June!!!!!!

Can you send me a copy of the database with the query ? Do you put this expression (CostSheet.Years_For_Strategy) Between [Forms]![Strategy_Form].[FYorCurrentYearStrategy] And [Forms]![Strategy_Form]![TxtTargetYearStrategy] in the criteria field for years of strategy in the TotalCostslarge...

The query is Total_Costs_largeEntity and the form is strategy form

I thought the Between and And operators cannot be used for fields that have a 'Number' Datatype? is that the reason why the query is going blank?

I tried doing that but the whole query is just going blank.

I have a Year field in the Told_Cost_LargeEntity query. I want to allow users to enter in the year criteria in a form and only values between that criteria will be visible in the query. Year 1 and Year 2 are two unbound textboxes in an unbound table. Years is a field in the query with a...

There’s an error whenever I click the checkbox. It doesn’t update the table or the macros aren’t activated the first time I click the form but it works on the second click of the option button. Anyone know why this is happening?

I have created a button to deselect all the option buttons on my form and I have written the following code to automate the button. The code is working in that it’s deselecting all the option buttons. My problem is that the option buttons have an embedded macro that is used to run update queries...

Bound checkboxes. They are bound to the same field in a table.

I have two checkbozes on a form. i need the checkboxes to be clicked or activated only if the user clicks the box. Right now if I click one box the other box is getting selected too. Any way around this?