Search results

Many thanks. I'll try this tonight and let you know how I get on John

Hi, I hope someone is able to help me on this complex issue. I'm sure there is a way to do this with code, but my skills have left me tied up in knots. I have two tables - Interviews & Placements. these tables have multiple foreign keys which pull information from other tables...

Its ok, I managed to get it working: IIF([forms]![ISISNavigationMain]![navigationSubform].[Form]![txtHasMobile]=-1 and ([Candidates].[PhoneMobile1] is not null,True,False)=[forms]![ISISNavigationMain]![navigationSubform].[Form]![txtHasMobile] took a while and a lot of messing but got there in...

Ok, I've got it working how I originally planned and may be biting off more than I can chew now, but I was hoping to put in a check box on the search form, so that if it is checked (i.e. True) the results only display rows where there is an entry for MobilePhone1. From searching online Dlookup...

Caz, thank you so much for writing that for me. I've just put it in and tested and it works perfectly! :) Brian, thanks I can see how doing that would make it looks simpler. I'm just starting to get my head around writing SQL like this and you've been very helpful

Hi Caz, For the LastContacted field, I need the query to return all results if both search date boxes are left blank. - If the "from" box has a date in but "to" is left blank the query needs to return only values that have a date after the date entered - and if the "from" box is blank and the...

I take it back. The query now works for the other fields, but the date range doesn't seem to filter at all now. I'll post the whole SQL query that is now running: SELECT Candidates.Company, Candidates.LastName, Candidates.FirstName, Candidates.Sector, Candidates.JobTitle, Candidates.WorkPhone...

Amazing, thank you so much! Its easy when you know how.

Hi Brian, thanks for the reply. Hmm, I'm not sure.... While testing, it now returns all values regardless of any other search filters that I've applied to it. basically I want the query to not filter by LastContacted if the "From" & "To" search boxes in the search form are empty, but also...

I think I may have just solved it. It helps when writing things down. In the query I have put an entry in the "or" line of the query Or: Is Null this now returns all results as I want

Hi, Hopefully someone can help me on this. There are many similar posts and I've spent the last few days trawling the internet to see if I can find the solution to my problem, but I can't seem to get it right, or find an answer to this part of it. I have a single table with customer...

It worked! Thank you so much for the help. I like the way that there is no chance of an empty record being created in the DB which would get messy over time.

Fantastic, thanks for the reply. I'll try that as soon as I get in :)

Hi, I'm a major newby on Access and trying to configure a database to work how I want. I've read many forum posts that seem similar but still not managed to get it working. I have 2 tables named Candidates & Comments. CandidateID is the Primary key for Candidates and CommentID is the primary...

Hi, I hope someone can shed some light on this issue. I'm pretty novice at creating Access Databases, but have managed to butcher the Contacts template for a Web Database I'm creating. I have it working mostly, but part of the requirement is to have a search form created so any fields can be...

Hi, It seems that I have the exact same issue that was posted on this thread. I have tried to follow the instructions as provided, but in my Access application, I am unable to enter any Parameters in the Search Macro builder. the hyperlink named "update parameters" does nothing when clicked...