PAUG...The Portland Oregon MS Access Database User Group

 

PAUG General Meeting

Meets 3rd Wednesdays of each month

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

Note: Don't forget that because the meeting is currently being held in a U.S. Government facility, you will need a valid picture ID to get in. If you are not a U.S. Citizen, there are additional documentation requirements that must met in order for you to admitted into the building. Please contact Jack Stockton for more information.

For further details regarding speakers for PAUG meetings or to suggest or to volunteer to be a speaker, please contact Nancy Sittig Smith