Using Microsoft Access

Access VBA Office Automation
Web LinksUsing Office Automation to have Access work with Excel, Word and other Office Applicaions.
Display # 
# Web Link Hits
1   Link   Import Data from Microsoft Excel
Maybe you have noticed that Excel spreadsheets do not always import data very nicely into Access. Sure, Access can import data from various sources with just a few clicks, but Excel files seem to give the most grief. Out of necessity, I created a code module that employs automation to loop through rows of an Excel spreadsheet and systematically add data to an Access table, cell by cell. While this is not exactly a "cut and paste" solution for your data import, it does provide a nice starting point.
2   Link   Export Data To Excel
... we look at how to get your data OUT of Access and back into Excel. While this may be as simple as right-clicking the table or query and choosing Export from the menu, it may also be complicated considerably by the need for custom formatting or the use of specific data templates. In the following article, we will demonstrate how to transfer your data into a prepared template using Excel Automation.
3   Link   Set Word Document Properties Programmatically
by Ken Getz on MSDN
4   Link   How to use automation to run Word mail merge from Access
This article shows you how to use Visual Basic for Applications to run a Microsoft Word mail merge in Microsoft Access.
5   Link   How to Use Automation to Add a Task or a Reminder to Microsoft Outlook
This article shows you how to use Automation to add a task or a reminder to Microsoft Outlook.
6   Link   How to send the current record to Word with automation
This article shows you how to merge the current record in a Microsoft Access object into a Microsoft Word document, to print it, and then to close Microsoft Word.
7   Link   Fill in Word Forms Using Information Stored in Access
Although Access reports are flexible and relatively easy to create, they're not always suitable for every task. For example, your company may internally use manual forms that can easily be filled with data from an existing Access database. Your natural reaction is probably to create an Access report that replicates the hardcopy form, but a number of hurdles may prevent you from doing so.

For instance, suppose that many other people have a continued need to fill the forms in manually. A consistent appearance between forms filled in manually and electronically is probably a requirement, so you could be looking at a lot of work to make the distinction between your Access report and the original form unnoticeable. In addition, the design of the forms is likely beyond your control?often maintained by someone using Word. Any time a form is modified, even cosmetically, you need to make changes to your Access objects. Fortunately, if the original forms are stored in Word, you can take advantage of the design work that's already been done. In this article, we'll look at how to populate Word documents with data from Access.
8   Link   How to automate Outlook by using Visual Basic
This article demonstrates how to programmatically control Microsoft Outlook using Automation from Visual Basic. The example demonstrates creating contacts, creating appointments, and sending messages by using Microsoft Outlook's object-model.
9   Link   Using Automation to Send a Microsoft Outlook Message
This article shows you how to use Automation to create and send a Microsoft Outlook message in Microsoft Access.

Sponsored Links


Latest News



Powered by Joomla!. Designed by: Free Joomla 1.5 Theme, linux hosting. Valid XHTML and CSS.