Ms access vba screen updating
When you really stop to think about it, an Internet browser in its simplest form isn’t really that impressive an application.I mean, yes, the Internet is amazing by anyone’s standards.This is particularly true when assigning individuals to specific duties/tasks, such as managing the relationship with a new customer or processing a helpdesk ticket.Because notification in most organizations means sending an email, the low-tech approach of creating and sending an email outside of your Microsoft Access database, especially if you are dealing with a high volume of notifications, can be incredibly inefficient and means the duplication of workload.
Using the approach below, you can use Word, Access or Excel to read HTML documents on the web, alter those documents, and then output whatever you want in a new browser window.
Luckily these instances provide a classic opportunity to use technology to improve your productivity and in general make your job less aggravating.
This article will demonstrate how to implement vb-code that will automate the sending of emails (via Outlook) from a Microsoft Access database.
For the Helpdesk scenario, we will use the following database design: The relationship design of the Helpdesk database This shows the main table of tbl Help Desk Tickets, where information relating to problems/issues are stored.
The table, tbl Helpdesk Employees is the list of Employees who work on the Helpdesk logging the problems.