PAUG...The Portland Oregon MS Access Database User Group
Next Meeting: 6/16/2010
Location: Bonneville Power Administration
,
905 NE 11th Ave, Portland, Oregon. Map
Feature Presentation: The Word is XML
My client needed to customize the content of their Word Documents based on data stored in MS Access. It turns out that Word 2007 documents can contain “custom XML parts”, which can store arbitrary XML data. I will show you how to customize the content of your Word documents based on XML data – XML data that was generated from Access!
Speaker: David Larson
David Larson is The Silver Stream’s principle software architect. In 1995, David earned two Bachelors of Science degrees in Electrical Engineering and Physics from Portland State University. At that point his software development hobby turned professional and he has had the privilege to be a Senior R&D Engineer for local companies such as Synopsys, InFocus and Simutech. Starting in 2006, he took his highly successful development expertise to the next level and consulted nationwide for various companies; most notably for Intel, Texas Instruments and Qualcomm.
Link: Silver Stream Software
Tips and Tricks: Moving Excel Data to Access
1. Moving data from Excel to Access using TransferSpreadsheet within a loop to move all of the data from a specified spreadsheet tab for every Excel file in a target directory into one Access table.
2. Different approaches for moving data from an Access table into an Excel workbook, focusing on CopyfromRecordset
Speaker: Ed Arnold
Ed Arnold is a Financial Analyst at the Bonneville Power Administration and works in the Budget group. He uses Access for financial analysis and financial modeling. Ed is a Certified Public Accountant.
Meeting Schedule...
6:30 PM Doors Open. Arrive and negotiate Security.
7:00 PM Q & A / Geek-Out. Open to Access users of all levels. Bring your .accdb or .mdb file and pose your question.
7:40 PM Main Topic presentation.
8:45 PM Tips and Tricks.
9:00 PM Introductions, announcements and book raffle.
9:20 PM Adjourn