Search results

I have two tables, one smaller and one larger. I have an existing personnel entry form that adds records into the smaller table. What I need to do is link the two tables together somehow so that when I enter a name that exists into the personnel entry form it searches to see if there is an...

I was just using the expression posted earlier in this thread, but I've put it back to this Age: DateDiff("yyyy",[Birth Date],Date()) as it worked ok with this. however, I need to be able to search for age ranges i.e. 25-40 but I cant search for any ages other than single ages i.e. just 40 year...

Thanks for that update, I'm still getting the data type error, but I'm under more pressure to get the search function working so do you have any ideas as to why I cant use the greater than or the less than symbols in the age search? I realised that I'd not put up a shot of the query in sql...

I tried this after editing it to work with the field names i'm using - is this right? age: DateDiff("yyyy",[Birth Date],Date())+DateSerial(Year([Birth Date]),Month([Birth Date]),Day([Birth Date])>Date()) but when i run the query i get a data mismatch error. I'm presuming that the fields its...

sorry about that, didn't realise. Are these screenshots any more helpful?

Hi, I've shown the inputs and results for running the search with both a fixed age and a ">" included in the age input. hope this helps? cheers

Thanks dcb, i've got most of it working now apart from the age searching. I did what you said and added the calculating field in the mainquery and i can search in the search form for exact ages but when i use any of the greater than or less than operators it comes up blank. i thought it might...

hi, i'm doing this as i've been shown this video: http://www.datapigtechnologies.com/flashfiles/searchform.html and my current personnel table only has a birth date field so as it stands at the moment, i'd have to ask users to input the date of birth ranges which isn't very user-friendly.

Hi, I want to update all records with a birth date listed to have an age in a separate 'age' field. I have got the hang of the datediff function but i can't seem to get it to work in an update query. I need the query to search for all records that have a birth date listed which i have done...

Thanks for that last post! The first picture (multiple criteria....jpg) shows my current master form with all the profiling buttons. the second (age form.....jpg) shows the form that is brought up when a button is clicked on. I want to turn the command buttons into toggle buttons and use...

how do I post an image as an attachment if its not hosted on the net and only on my hd? - there's no attchment option on the message posting box.

I have separate forms and querys for individual age ranges (16-24, 25-34 etc), gender, ethnicity and disabilities all with buttons on a single page that bring up all people conforming to the individual profiling method. I'm trying to replace the command buttons with toggle buttons so that when...

I'm going to try and use toggle buttons as inputs for the criteria - can i use them to toggle a code snippet to be inputted into a blank query? cheers

I thought it would make things easier if i moved turned the spreadsheet into an access table. aside from first and last names I cant think of anything else i could use as a unique field as if i insert an autonumber field in the old spreadsheet table, as some of the records in the spreadsheet...

Hi I'm trying to create a system for a multiple inputable criteria query and I need to use a toggle button to use as an interface to create a query and input a criteria. any ideas? thanks

When you say link them, would a relationship with the update option enabled between first and last names on both be what you mean? Also, would both tables have to have exactly the same fields in them for it to be able to retrieve all the relevant information or would I have to make a...

Hi, my client has two databases, one smaller one saved as an access database with more complete details of clients and a much larger one saved as an excel spreadsheet with many incomplete entries but many more fields. I need to create a system whereby upon entering a new user in the smaller...

Hi, I know that access can send commands to open word easily but how do I tell access to lift just the addresses field of a record and send it into word as a letterhead? Thanks

nice one, sorry man - i've litterally had to learn access in like two weeks so i've got loads to learn still so cheers for helping me. i know how to do all the stuff you said up till the query with paramaters that are the form controls - do i have to enter some code into the criteria box the...

What is an input form? is it something that only appears on versions after 2003? just as that is the version i am limited to unfortunately. The point of the system i am trying to create is to have an easy to use interface for people so they don't have to involve themselves with any of the...