In my code, I specify the line to start my email task,
Set objOutlook = CreateObject("Outlook.Application")
I DID go to Tools, References, and checked "Microsoft Outlook 11.0 object library" (I have Outlook 2003)
But, when Access hits the above line, I get Automation error, the specified module could not be found.
Do any of your references say "Missing"? If so, please clear that reference and recompile to see if you really need the "Missing" reference. As soon as 1 reference goes goofy functionality of all other
In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
When developing Access applications, often we need to know whether an object exists. This article presents a quick and reliable routine to determine if an object exists without that object being opened.
If you wanted to inspect/ite…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page.
The problem with sub-reports and headings:
Add a dummy group to the sub report using the expression =1:
Set the “Repeat Section” property of the dummy…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string.
Specify the first argument, which is the expression to be returned:
Specify the second argument, which …