Database
Creating PDF in Access and emailing through Outlook
http://accessexperts.net/blog/2013/02/26/email-reports-from-access-as-pdf-attachments-in-outlook/ Private Sub cmdEmailInv_Click() Dim DocName As String Dim objOutlook As Object Dim objOutLookMsg As Object Dim strBody As String Dim DocPath As String Dim rst As DAO.Recordset ‘Me.txtBillingEmail is a text field on the invoice form that has the billing email On Error GoTo cmdEmailInv_Click_Error If Me.txtBillingEmail = “No billing email on file.” […]
Versioning tools
In meeting with Mark from MAS we noted some versioning tools Subversion is an open source version control system http://subversion.apache.org/ See screenshots
Failures caused by Name AutoCorrect
This feature was introduced in Access 2000. It tries to help users who rename a table field, so that queries, forms and reports automatically recognise the new field name. Microsoft has addressed some of the problems with this feature, but is it still buggy, incomplete, and a performance problem. One of the known performance problem […]