Recent content by Hiker

AHhh! running out of time and needing help!!!

I have got it into the query ok, but when I try and run it, it comes up with "run time error 13 type mismatch" If I say yes to debug it highlights this line for me in the code: dBDAY = CDate(dBDAY) I don't know how to fix the problem though. please help Thanks

Thanks for the help! I don't really understand Visual Basic Code, I understand how to put it into a module but I have no idea how to run it afterwards, so I can use that code. So I need a little help.

Hi, Well I found the code and I did put it in a module-but I don't know how to make it work in access afterwards? I tried the enddate startdate expression, but somehow I do not quite understand how that works-where does it give you the answer? And is there a way on that so, that you can use...

Thanks for the tip!!! but I was wondering where do I find this article? Thanks again!

I've had that and set it as short date in the input mask and it has the format of dd/mm/yyyy but somehow it still does not want to work in the query, maybe I am doing something wrong with the criteria? Thanks for the Help!

AHHHHHHHH!! That criteria does not seem to work on my computer!! Maybe it is something to do with my field name, am I aloud to have an input mask on it, and what data type should I be using? I have got text, or is there something else I am doing wrong? Please Help!!

Thanks jstroh! :-) Just hope that this thing will work!!

I was wondering if anybody knows what criteria I need, if I wish to work out how old somebody is now (current date) from knowing their date of birth! Thanks!