Birthdays????

[sjtaylor_uk]

Hi
Im new to the board, i have got a problem in a database that ive managed to land my self building for my work!

The Brief is as follows

" to design a database that all peoples names, addresses, telephone numbers, childs birthday ect... can be input, and then when it comes round to the child birth day, there will be a report / mail merge automatically made with a letter basicly saying "we know its little johnys birthday in 2 months (2 month being the desired time before the date that the centre would like!) enclosed is the infomation that you need should you like to hold your party at the centre!!"

i have made the Tbl_customer which has got all the fields needed i think, for from here im not sure where to go , they say that they would like it to be semi - automatic, so they only have to click on one button and then it will come up on the screen saying "there are 43 new bithdays today - would you like to print letters??" if you catch my drift?

Any help would be greatly appehciated!

Many thanks
Simon

 

[mark curtis]

i've knocked up an example to get u started, attached.

 

[sjtaylor_uk]

Ok thanks for your help ill have a look and then ask again if i need anything, one thing to think about if you could is how to get it from the report to a written letter, the three that get shown in the Rpt are within the 2 month margins set, but then how can i knock up a automatic letter to these people?

 

[mark curtis]

u can just format the report to produce the letter for each birthday. just force new page for each id. u can run a macro or code behind a button to produce these letters.

if you put some data in the db and provide me with the letter format and content I will do it 4 u!

 

[sjtaylor_uk]

Hi again Mark,
i have had a good look at the DB now, and there is only one more question i think i need answering!

It is to do with the date on the select query! at the moment it will flag up results which are of the month "5" this is 2 months PREVIOUS of now, there dirthday will have been! how is it possible to set the date to be 2 Month in the Future, and then flag up there reults

i.e (from present date) anthing between now and september the 7th?

Many thanks for you help i apologise for being so "green" on the matter!

Simon

 

[mark curtis]

in the query change the date()+60

 

[sjtaylor_uk]

Thats that works very well, i think that i can manage the rest from here, i will post another thread if i get stuck again

Much apprehciated

Simon

 

[sjtaylor_uk]

Hi mark im having problems again!

On the database i want the Childrens birthdays to be entered as Date Of Birth - not Birthday! Then it wont be working from the pressent year, only the months

e.g if my DOB was on the 21/08/84 then it would flag up my birthday 2 months before i.e the 21/06/03 then it can carry on doing this for years!!!

But... i would also like to have the possibility of remocing people from the database,set on the condidtion that if they are more then say .... 14 (DOB 89) then they are not going to recive a letter due to them not realy wanting a kiddies party at 14! i should imagine this is going to need some code, which im toitaly lost in, hope i have given you enough infomation to help!

Thanks
Simon