Search by date problem :-(

[oneeyedwilly]

OK here goes:

I have a table containing personal details, one of the fields is date of birth.

I have a form (form 2)which i use to open another form (form 1)which contains personal data (form 2) is opened from form 1 in order to perform a search (not too important)

Form 2 contains only a text box and a button (created with the wizard) and it works great i can search through the records by typing the full date of birth in the text box i.e 08/08/1978 and clicking the button.

I want to be able to search through the records so that i find all the people born in a specific year, by typing 1978 in the text box how do i do this?

 

[krispi]

No guarantees but seems to work in my search routine - try using * as a wild card, i.e. type */1978 in the search box

 

[oneeyedwilly]

nope didn't work

 

[PeteJohnston]

Maybe an SQL select with

SELECT * FROM tablename WHERE DatePart("yyyy", DateField) = txtDateSelect

and use this string as the .RowSource for a list box would work? PeteJ
(Contract Code-monkey)

It's amazing how many ways there are to skin a cat
(apologies to the veggies)

 

[wemeier]

You could try adding a non-displayed field (call it [FormatDate]) to your form's RecordSource whose ControlSource is Format([birth date],"mm/dd/yyyy&quot.

Then, if a less-than-full date is entered, change the filter to [Format Date] Like "*" & [textbox] & "*".