filtering records in form by date based on value in combo box

[moeido]

i have a microsoft access database. it has a customers table and a date of entry of each customer. i have a form which includes all customers and their info.

i want to make a combo box (drop down box) that would include months of the year (January, February, March, April...) . when the user chooses April from the combo box, only the records which were added in that month will show up in the records table.

can this be done? i have been trying to do this for at least 3 days but no luck..

Kind regards.

[zmbd]

Easy enough...
For fairly small databases I do the following:

tbl_months
[months_pk] numeric(long)
[months_fullname] text(10)
[months_shortname] text(3)
>I use this table to feed my listbox. The row source is an SQL that pulls [months_pk] ast the first column and is the bound column; the second and/or third column as I need. Also, sorts the months on the primary key... so that Jan is before Apr (^_-)

In a query, you will need to create a calculated field.
calc_mo: month([fieldwithdate])
this will only work a date/time typecast field and it returns the numeric month (April = 4, etc...)
Becarefull with using reserved words and symbols! Access 2007 reserved words and symbols

In VBA, you can then use the selected value in the list box (or combo box) to build your SQL with the WHERE clause based on that value and any other restricting criteria.

In a pure SQL/Stored Query, you would create a parameter that will either popup the basic inputbox with a prompt to enter the numeric month, or you would create a form that the query will use for the parameter value(s).([url=http://office.microsoft.com/en-us/access-help/using-parameters-with-queries-and-reports-HA001117077.aspx(acc2003)[/url] <Newed examples use the Macro language which is not the same as VBA. Unless you'll be publishing to a sharepoint site, IMHO stick with the VBA versions)

[moeido]

ok there has been a change in plan.

the table has a date for each customer.

i want to make a text box which would take a date as input.

it will show all customers at the specified date.

can this be done? if yes how?


also, i want to make a record list that would show the records of all customers depending on a certain YES/NO field.

is it possible?

thanks very much.

[zmbd]

moeido:

All of the answers to the additional questions are basically the same - yes it can be done, the Queries are basically the same for filtering and the textbox would have either code behind it or a command button; however, we ask that each thread contain only one question. This is to make it easier to keep the answers on-topic and so that members can more easily search for answers to their own, similiar, questions.