Search results for query: *

PHV, That will work for the batch routine to process follow-up notices. How do use the same routine to send only 1 email message from the On Click event of a button on the form. I don't have a recordset set up in the form. How do I pass the current record from the form to the subroutine? Do...

In October I developed a process which creates and sends an email message using Outlook when a user clicks on a "Send" button on the main data entry form. The email message which is generated and sent is called an "Award Completion Request". Now I want to develop a routine to send follow-up...

Remou, Thanks. No, this application doesn't have any code which updates links. The look-up tables in this application which I'm planning to move are system tables maintained by me. Changes are infrequent and planned. One concern I do have is about the Linked Table Manager. When the tables...

A little over a month ago I upgraded an application from Access 2003 to Access 2007 and split the database at the same time. I've done a number of things to improve performance. An additional step I would like to take is moving 3 look-up tables from the back-end to the front-end. Before I...

Thanks. I was able to do this.

I have a form which allows users to select a query to be run. Some of these queries have a run-time parameter defined using the default Access 2007 define parameter feature. At run-time the default dialog box titled "Enter Parameter Value" is displayed to the user with OK and Cancel buttons...

grgimpy, Remou: Thanks. I went back and checked Tools->References again before replying and found that I had mistaken the Office library for the Outlook library.

I used information from the Microsoft web site and from this forum to write VBA code last week to send email from Access using Outlook. The code is run when a user clicks on a "Send" button on a form. It worked fine for a few days. Now when a user clicks on the "Send" button they receive the...