Recent content by erinkleiman

I need the duplicate values in the underlying query because I need to report on the related information.

I have a report in which there are a list of number with the duplicates hidden. At the end of the report I wish to Count all of these numbers, NOT including the duplicates. When I do the count at the footer it still counts the duplicate numbers. How can I count only distinct numbers?

Event Exit Dabase Shacket.... I have my code written and ready but I need to know what kind of module or macro I should use to implement this code when the database is exited. Thanks a bunch!

Left function ?? Nero.... I want the database to send these emails automatically every month. It looks like your code tests for only one date, which means the email wouldn't be sent automatically every month. I am also a little confused about the line: MailDate = Left(MyDate,2) If MyDate is...

Oh nevermind....got it! Thanks a lot!

When I go to Tools-> the 'References' link is not available (it's grey)??

Trouble with Outlook.Application Object Hi Nero, Thank you for referring me to this thread but when I try out your code the compiler gives me an error in the line: Dim olkapps As Outlook.Application that says "user defined type not defined" Do you know what the problem might be??

I need to send an automatic email update every week when a certain event does not happen. Does anyone know if this is possible in Microsoft Access and if so how I would go about doing this? =)