(Note: I loved the code I found on the original posting, but it would not work without a simple change. I'm copying the post here and highlighting my changes, talk about a time saver!) Granting Select to all tables for a login can be an extremely painful and lengthy process. Utilizing the SQL Server [...]
The other day I needed to connect to my local instance of SQL Server Express 2008, and I wanted to do it without exposing my SQL Server via TCP/IP, (why invite the world to my doorstep if the server is for local use only?). I was having trouble doing so until I found the right syntax at ConnectionS [...]
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 [...]