This is a modification to an earlier tip I wrote, whereas this code will only record delete changes, my earlier article will record delete and update changes to the data. I found code online by Brett Kaiser and I modified it for my purposes, with a mind to other Access developers I made some changes [...]
Note: If you need to send out a massive amount of emails this code is not for you, instead we recommend FMS's Total Access Emailer. Note 2: You must add a reference to Outlook in your Access project in order for this code to work, if you need an alternate version that does not require it then look a [...]
The other day I needed to create a query where it returns all records with dates for the current month. I did not want to hard code the beginning and ending dates in the query, so I came up with the following line of code you can paste into your query: Between CDate(Month(Date()) & "/1/" &am [...]
