Mass Filter Query?

[g28dman]

Hello, I have been working on my database for sometime - searching this forum for answers, thanks to all the experienced people for their sharing of knowledge.

My question is this: My database will be over several years of data, on my splash screen (switchboard) I would like to have a combo box of with choices for years. When a user chooses a year, the entire database is filtered. Say if the choice was for 2005, then anything with a binderdate of 01/01/05 to 12/31/05 will be filtered.

This will need to be done across several tables, queries, forms, and reports.

Once the choice is made for that year - any form the user is on will be filtered for that specific year.

I am still fairly new at access programming, so any code snips or working examples would be greatly appreciated.

 

[alastair69]

You could try Like "*" & [Your Textbox Name] in a query, you will need to know the name of your input form, should look something like:-

Like "*" & [forms].[MainForm].[Subform].[Combo Box]

Let me know if this works for you.

Alastair

 

[g28dman]

You could try Like "*" & [Your Textbox Name] in a query, you will need to know the name of your input form, should look something like:-

Like "*" & [forms].[MainForm].[Subform].[Combo Box]

Let me know if this works for you.

Alastair

Alastair - Thanks for reply. I got this to work from the query. However, it does not work from my combo box on my form. I am having trouble understanding the "on click" event handler.

 

[alastair69]

Can you post your database and i will have a look for you.

 

[g28dman]

This is the one I play and experiment with. That way I dont mess up the one I am working with. So it's not very pretty...

You'll notice a combo box, down by the calculator on initial opened form (policyentry) , then under queries (policyentryfilter) the expression you given me.

 

[alastair69]

I will have a look now and let you know

 

[alastair69]

Your Database will not let me change any thing could you send the master database, because it is a replica

 

[g28dman]

Oops, sorry for that.

here ya go

 

[alastair69]

Were are do you want to use the query as in which form?

 

[g28dman]

I would like to use it on the form it is currently located. (PolicyEntry) OT: I am not asking you to redo my database, and I know it's not very pretty as far naming fields(i.e cbo, tbl, frm etc) but, am I on the right track?

I got about 120 hrs of building and research in whole thing, and I am kinda proud of it. Would like some constructive critism from someone who has been using and working with access longer.

Thank you for your help. It is very much appreciated.

 

[g28dman]

I forgot to mention - using the binderdate as what's being filtered by year.

 

[alastair69]

Yoiu have a good idea of form layout, the only surjestion i have is that for the calulater you may need to look at twips this will allow you to use the calulater with out lossing the back ground form.

Alastair

 

[g28dman]

Yoiu have a good idea of form layout, the only surjestion i have is that for the calulater you may need to look at twips this will allow you to use the calulater with out lossing the back ground form.

Alastair

Thanks for your help on the combo button. Thank you for kind words - I am trying, and am proud of what I have .

As for a newbie question - what is twips? for the calculator. And, is I got to thinking is there a way I can place the amount shown in the calculator into the premium column on my subform - that would be cool.

 

[alastair69]

G28DMAN,

Please find the attched copy of your database, i have changed the following if you need more help i would be pleased to help you.

Frm Calclator I have included the twips calulation and used it on your form, it now pops up and you can see the background form (I think it will make your form easier to follow and understand).

The total from the calculator will now be placed in the Premium field on "Refresh" or data entry into the form.

On your main form there is a hidden text box that you can see in design mode please do not delete this as it provides the link to the Premium field.

I have also included some ideas for you to use on nameing your froms in "Form View"

Once again any problems send them to me and i will have a look and see if i can help out any more.

Alastair