Current Month Query and Back up question

[Ben]

Hi

I am currently building a database in Access 97 and have a (quite
easy) question.

I want to produce a query / report that will bring out all the people
in the database that have a birthday in the current month / next
month. The idea would be so that just before the beginning of a new
month, the user can click a button that will give a report of all
customers who have a birthday next month and this will print out. If
the database could do this automatically on a certain day of the month
that would be great too...

Also, I would like to be able to put a button in the database that
backs up the database to a cd rom, straight from Access. Is this
possible?

Many thanks

Ben

[tym]

On 3 Dec 2003 22:38:25 -0800, be**********@yahoo.co.uk (Ben) wrote:

Hi

I am currently building a database in Access 97 and have a (quite
easy) question.

I want to produce a query / report that will bring out all the people
in the database that have a birthday in the current month / next
month. The idea would be so that just before the beginning of a new
month, the user can click a button that will give a report of all
customers who have a birthday next month and this will print out. If
the database could do this automatically on a certain day of the month
that would be great too...

Also, I would like to be able to put a button in the database that
backs up the database to a cd rom, straight from Access. Is this
possible?

Many thanks

Ben

This button on a report will create a table with the relevant records
in it then view the table - play with this and see where you get,....
Private Sub Command0_Click()
Dim sCrit As String

sCrit = "SELECT name, birthday INTO tblBirthdays FROM Table1 WHERE
(((IIf(Month([birthday])=12,1,Month([birthday])))=IIf(Month(Date())=12,1,Month(Date())+1)));"

CurrentDb.Execute sCrit

DoCmd.OpenTable ("tblBirthdays")
End Sub

Tym

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~
See http://www.ictis.net/no_spam.html for unsolicited email warning
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~