Search results

I've created a message box and saved as a macro. How do I make the message box appear? Is there more than one way of achieving this?

I opened up the Query Design window then inputted =14 into the Criteria under the field of which it applies. But then I thought if I right click on the box I just typed =14 & then select Build... then this will open the Expression Builder window and at this point I was trying to look for...

This part I've done But this part don't know how to do :confused:

yes i like your thinking that's brilliant thanks.

Hello All, I'm after a Message Box appearing when the number 14 shows in a query. I have set up a Macro for a message box and called it "SendEmailInvitation", and have run the macro to see if it works and it does. How do I associate the SendEmailInvitation Macro to show when the number 14...

I don't quite understand the Module part, infact there's snippets i do understand and have fathomed out but simple stuff like exporting a file and emailing and run apps, but when it comes to meddling with the code to add other variables then I don't really know where to begin.

excellent thanks

Hello there, the following code works on the one date ie. 02/10/1974 Expr1...

The reason I ask if it can be achieved in A2003 is because i read it wasn't possible to send an email from A2003 automatically on a certain date, but it is possible in A2007

Can this be done in Access 2003?

Hello all, I have quite alot of Questionnaire cards that people have filled in and posted into a box in a restaurant, now on the said questionnaire form is the following: We thank you for visiting our restaurant and hope that you enjoyed your meal. In order that we may maintain high...

ok thanks i'll give it a go

are there any easy to do tutorials on this with pictures...lol...as i'm really struggling

hello raskew, thanks for the code but where do I paste it and will i need to edit any of it? Sorry for asking all these questions but I'm a newbie on Access.

ok this works well and is correct: IIF((DateDiff("m",Date(),DateAdd("yyyy",( DateDiff("yyyy",#02-10-1974#,Date())+1),#02/10/1974#))) > 12, (DateDiff("m",Date(),DateAdd("yyyy",( DateDiff("yyyy",#02-10-1974#,Date())+1),#02/10/1974#))) - 12, DateDiff("m",Date(),DateAdd("yyyy",(...

you have been a great help DevastatioN, thanks very much for you time and the same goes foor the previous posters. Thanks

I have changed the following date to the same as the latter and it still returns a month count of 19 Expr1: DateDiff("m",Date(),DateAdd("yyyy",( DateDiff("yyyy",#02-10-1974#,Date())+1),#02/10/1974#)) Would it be better for me to upload the .mdb file or take snapshots?

So far the nearest results to of those which i want to achieve are from DevestatioN, Expr1: DateDiff("m",Date(),DateAdd("yyyy",( DateDiff("yyyy",#1974-02-10#,Date())+1),#02/10/1974#)) but this returns an Expr1 month value of 19

Hello all, I have creadted a .mdb using Access 2003 on a PC Windows XP. When I look at my Query that I've set up using the Wizard, I've selected it to show the following: Name Email Address Date of Birth Now what I want todo is to calculate how long until the next birthday. I did have a go...