Search results

Phew - thanks Bob you're a star!

I have an access database that automatically opens a form when you start it up. It then runs some code to backup the Database and then quits the application. I meant to save a backup of this without the quit application bit. Like the fool that I am - I didn't. Is there a way I can break the...

Thanks Dennisk - you are right I was being a complete numpy!

I have a form that has several fields. What I would like is to use the duplicate button. The problem I have is that this duplicates a field that has an autonumber (which is set to not accept duplicate numbers). Is there a way to create a duplicate but replace the problem field with a new...

Cheers. That works a treat. JP:)

I have a Form called Demographics. On this form there are several fields three of which are relevant to my query. 1. Reported 2. Male 3. Female What I want to be able to do is to check that the total of Male and Female equals Reported. If not then display message box "Error etc". I would...

My Table is called is called contacts. It has a fields that contain email addressess and contact names. I would like to be able to send everyone in this table a reminder email using groupwise. I would need for the email to send them individually one at a time and not one email with eveyone's...

Thanks neileg. Good point about renaming the date field. I'm still struggling though. This is the syntax I have: Quarter: DatePart("q",[PaymentDate]) This gives me the quarter - the problem is it's based on the year starting on Jan the 1st. I want it to start from April the first. Is...

This is my first thread so be gentle. I curently have a query based on a payments table. In the payments table there is a field called date (when the payment was processed). I want to be able to display, in my query, the quarter that this payment was made in. It is based on financial...