Search results

Thanks David that's pretty much what I thought. You've given me a lot to think about, but given the complexity of what you suggest and the relative simplicity and small-scale of what this database is, I think my solution is simple. I tell any lazy bones to check it themselves :P

Hi all, This is probably a stupid question so I'll keep it short and sweet. Is there any way access can send an email (based on when a field date expires) when Access itself hasn't even been opened? I've been asked to set up a reminder system but they don't want to have to check in every day...

I am trying to send out data collection emails to fill in my records but it will only let me select fields from single access tables, I want to be able to get them to fill out all the fields as entered in my forms, which contain sub-forms and therefore links to multiple tables. is there an easy...

still no luck :\ Is there a way to ask the query not to search for a field if the search box has been left blank? eg some kind of 'Iff false' statement? :)

I tried setting the default values within the subforms for each other table to a new N/A value, but this only works if you then click the default value and press enter. i need it to automatically create the relationships employee to field :\ is there a way to apply an 'OR IsNull' function to...

Sorry for the delay, I tried playing around with the joins but it hasn't helped, in any case I have made some progress... I've now used Select Distinct to cut down the thousand or so records I get back per employee (it only seems to work because I've told the query not to show anything except...

Sorry this message becomes a bit of a brainstorm session towards the end :) In any case, I got the Nz to work :) And you're right I can leave it as N/A by default on the forms, good point. But i'm not sure that will actually solve the bigger problem, yes it will fill any gaps where there is...

I'm trying to avoid that if possible, there are a lot of fields and I don't want the user to have to enter n/a every time theres a field they want to leave blank.. I've been playing around with the Nz Function but I'm not entirely sure how to work it.. can it be used in the query field name...

I have a form & query to search across two related tables 'Employees' and 'qualifications' (Many-many relationship), which semi-successfully finds employees and their qualifications based on what is typed into the form. The problem is that the form will only return records where all the fields...

I think (and do correct me if I'm wrong) the problem isn't that there are holes in the employee details table, it seems to pick up on those as long as i've searched for at least one relevant field. The problem is when that employee has no involvement with one of the other tables. For example...

MSAccessRookie, could you please explain where you would put that statement in the SQL? I have a very similar problem to the above :) I tried just putting it at the end but got a message saying the LEVEL clause includes a reserved word/argument that is missing/mispelled or punctuated...

Hmm no luck. But you've definitely put me on the right track, i'm reading up on union queries as we speak ;) Thanks for all the help guys :)

Sounds promising, unfortunately I'm too rubbish to apply it correctly. Any chance I could ask you to take a look at my code and see where I've gone wrong??? I keep getting an error message for syntax in the FROM line... already see one problem... Corrected but still syntax error in FROM

you asked for it ;) here's the SQL: I've attached what that looks like.. I can't include any sample data, but its pretty regular stuff, Name, Title, Address, Postcode and qualifications. But this is not 100% complete for all employees, for example a lot of them are missing titles, and many...

Still no luck despite hours trolling the internet... I still want the query to return all the data (name AND Details, not OR) But I can't allow it to ignore entire records just because one (often irrelevant) piece of information is missing... Lots of people online have asked if there's a way to...

You make a good point Paul, I will have to reconsider. But thanks for the explanation (as usual!) :)

I have a query I'm using in a search form to look up employees based on their ID num, title or first or second name. But for some reason it's only showing me complete records, so if for example the person didn't put in their second name, they don't show up at all. This is what I have put in...

... is what I found myself asking. The question: Is there a way to export all records across multiple tables onto a single excel spreadsheet, but without a ludicrous amount of duplication every time there's a one to many relationship? Let me explain, I have an HR database featuring tables...

I am trying to set up a (locked) checkbox on a form so that it becomes checked if there is one specific entry in one subform, and another entry in another subform. But I haven't quite got the access-brain to figure it out. So far I've tried altering the control source of the checkbox to the...

I have a form called Employees and a sub-form called Availability, which lists area names where the employee can work. I was wondering if there's a way to make a button or something that can be clicked to automatically select/deselect all areas for that particular employee?? I realise this...