Access MVP (2010-2015)

oOo.oOo.oOo.oOo.oOo.oOo

List Tables and Fields…

When I’m designing a database I usually start off with one of my Templates. But, as with any Template, the Tables therein do not always fit exactly with the Client’s needs. And, since I like to document changes I built this tool…

In a nutshell… After the Template database is created I import the […]

 1,468 total views

Send eMail with Default (Outlook) Signature…

Question: How do I send eMail and include my Outlook signature?

Answer: Create a Module, name it anything you like except the name of the Function.

At the top of your Module under…

Option Compare Database Option Explicit

…place

Function streMailWithOutlookSignature() ‘Works in Office 2000-2016 Dim OutApp As Object Dim OutMail As Object Dim strbody […]

 771 total views

Tools, Utilities and more…

Recently, I watched Free Tools for Microsoft Access recorded by Crystal Long and Adrian Bell (Microsoft Access MVP’s) on Channel 9. Upon looking at comments below it dawned on me there is no central location for all those great free tools! How is anyone to find them? After all, you may not know they […]

 661 total views,  1 views today

eMailing specific Reports to specific Recipients…

Question: Can anyone tell me how to eMail a report with content based data based on the individual?

Answer: Create a Module, name it anything you like except the name of the Function.

At the top of your Module under…

Option Compare Database Option Explicit

…place

Public olApp As Object Public olNameSpace As Object Public […]

 866 total views

Call Me…

Calling an Event Procedure from one Form to another…

Every once in a while I need to use the same code I have in the Event Procedure of a one Control in another Forms Event Procedure, whether it be the On_Click event of a Command Button or the After_Update of a Combo Box. 99% of […]

 660 total views