folks..any ideas on how to enable an Ms Access database to send an e-mail when it is updated
is it easier to do from within access or via a .NET app ( doing a simple check on the db tables to look for changes)
any ideas
thanks
ms access
Hot Topic
- Multiple series addition problem
- MS Office document and image writer print driver
- Problem: Macro not deleting columns I select
- Problem in Accessing Pivot field from cube using VBA code
- Unable to run VB6.0
- Using arrows to select in drop down list in access
- Office XP VBA can't find reference after saving by Office 2003
- Help with Excel VBA Code
- Working with a DLL
- Help with interface?
Microsoft ISV
- Word 2003 Includetext XPath
- xcacls.vbs context question
- Can you use VBA to access a spread sheet embedded in a word doc?
- vba create and add a macro for excel programmatically
- find current path in VBA macro word
- Generating Dialog Messages thru VBA over Excel
- Call Windows API to store hyperlink path to external documents
- "variable" to make Macro not associated with one specific sheet in workbook
- Projects, objects & modules
- Internet Explorer 7 jpeg and gif blurry after tools/internet options/advance/reset
ms access
Stormin Norman
Hi,
1. When data was updated
I don't think you can automatically "triggered" by a change to database in Access. What you have to do is to check the updated time of the table manually.
Try this.
For Each obj in Application.AllTables
Debug.Print obj.DateModified
Next
2. Sending Emails
Have you ever consider using automation and control Outlook to send email for you
Hope this can help.
Pedro Felix
Howard B
any thoughts on how to figure that an update has occurred to the access database if so i think i can use a macro to send an email
tx