Recent content by garyh_uk

Hi I want to build a pass through query for a large query I need to run. I understand how to do it except for 2 things: 1. In the query I have a calculated field which basically works out from 2 dates, which is the most recent and returns the values based on that. So for example...

Thanks Kiwiman that worked - one more question, I have my own mailbox and a department generic one which I am able to send emails from, is there any way to choose to send them from my department email account rather than my own (which it currently does)? Thanks

Hi everyone I have a form in MS Access 2007 from which I can send an email, this works fine, and I have managed to trap the error code when the user cancels the email, again this works fine. The problem I am having is that I want the form to close after the user has sent the email or clicked...