Search results

I want the little search box to pop up, and then for example when i type in SMITH, and it shows me a table of all the records that have that surname in it, showing me their details, such as home address and telephone numbers, etc.

Yep, exactly that.

Hi all, Got a problem. I have a Database to complete for my I.T. project, and I'm running out of time with a crap load of stuff left to do. I'm not a newbie to access, though I feel like it. I haven't used it for 2 years, since I was in High School, and I've kinda forgot how to do some stuff...

I've come to the conclusion that, at the end of every season, I'll just change the name of the tables and then edit the relationships. It's the simplest way I can see of doing it right now. I may go back to it at the end, if I have time. Thanks for all your help, I really appreciate it :)

Oops, my mistake. What I meant to say was AFTER July 30th and BEFORE August 1st. :)

Got it at last! (I get by with a lil' help from my friends ;)) I used this formula... >#30/07/1992# And <#01/08/1993# Meaning that the player must be born AFTER 1st August 1992 but BEFORE July 30th 1993. Took me that long to figure out something so simple. Ah well, can press on with it now! :D

Thanks for the tips, I'll give the whole beginning of the year thing a try, that sounds as if it could work. I did actually try the DateDiff function on it, but it didn't work. My ICT teacher assisted me in that, so I think I tested that to the max. I'll give it all a shot anyway, thanks...

Hi, I'm currently experiencing some problems with my Access 2000 Database. I'm designing a database for a Youth Football Team you see, but have become a little stuck on something. In a table I have, I've created a field called DOB. What I want to do, is be able to enter a certain age, but have...