Recent content by DJ-Specter

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