Note: This is part two of a series of articles on Access Data Projects, Click to see Part 1 Click to see Part 3 Access ADPs can provide you with the flexibility and power only a direct connection to SQL Server can provide, but a major drawback to a developer is the login box that will always show u [...]
Note: This is part one of a series of articles on Access ADP projects. Click to see Part 2 Click to see Part 3 Where and Filter Clause do not work when using DoCmd.OpenForm Statement One of the issues you will find when working with an Access Data Project, (ADP), is the lack of functionality in the [...]
Office 2007 will allow you to easily create PDFs from any Word Document using the output menu on the Office button, (Access does too with Reports), but recently I had to create a procedure for a client that wanted to convert Word docs to PDF, email them and do it all from Access. Note: To make this [...]
If you're using a SQL Server database with an Access frontend, then this article is for you. Leveraging the power of Stored Procedures from Access has numerous benefits: your server can perform transactions that would take far longer in Access. Recently I came across the following issue when working [...]
SQL Server views are one of the best tools a Microsoft Access programmer can use to limit exposure to data and improve Access performance. Unfortunately, you can't modify data in a view unless it has an unique index, read on if that is the case for you. (You can create indexed views in SQL Server, t [...]
(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 [...]