| Date |
Type |
Title |
Description |
Action |
| 5/15/2013 |
Downtown Portland Workshop |
Questions and Answers |
Have a question? Bring your Access database file to demo. |
|
| 4/24/2013 |
Tigard Workshop |
Questions and Answers |
Have a question? Bring your Access database file to demo. |
|
| 4/17/2013 |
Downtown Portland Workshop |
Questions and Answers |
Have a question? Bring your Access database file to demo. |
|
| 3/27/2013 |
Tigard Workshop |
Upsizing to MS SQL |
- Access 2013 has dropped the old Upsize Wizard. That's okay since so many people complained about it, so what do you do now?
- Have a question? Bring your Access database file to demo.
|
|
| 3/20/2013 |
Downtown Portland Workshop |
Questions and Answers |
Have a question? Bring your Access database file to demo. |
|
| 2/27/2013 |
Tigard Workshop |
Access 2013 Web Apps |
- What is the new Office Web App?
- How do you modify Web Apps?
- What's good and bad about the Web Apps?
Have a question? Bring your Access database file to demo. |
|
| 2/20/2013 |
Downtown Portland Workshop |
Dealing with duplicate data |
- Sometimes you get data from multiple sources. How do you determine, what is the same and what is different.
- Have a question? Bring your Access database file to demo.
|
|
| 1/23/2013 |
Tigard Workshop |
Tips and Tricks |
- More on storing attachments...I have some code for working with the File Stream to store files in a SQL backend to share.
- Testing your app...what should we be doing?
- Have a question? Bring your Access database file to demo.
|
|
| 1/16/2013 |
Downtown Portland Workshop |
Meeting Canceled |
We need to find a different location to meet.
Please contact Dave White if you have a location suggestion. |
|
| 12/19/2012 |
Downtown Portland Workshop |
Questions and Answers |
Have a question? Bring your Access database file to demo. |
|
| 12/5/2012 |
Tigard Workshop |
Windows 8 and Access 2013 |
- Are you sure your Access app will run on Access 2013?
- What does your app look like on Windows 8?
- Bring you app on a thumb drive and let's see what it looks like on a Windows 8 with Access 2013 computer.
- Have a question? Bring your Access database file to demo.
|
|
| 11/21/2012 |
Downtown Portland Workshop |
No Meeting this date |
Happy Thanksgiving |
|
| 11/7/2012 |
Tigard Workshop |
Converting to Access 2007 / Attachments |
What has been your experiences with converting your apps to Access 2007?
How do you handle attachments?
Have a question? Bring your Access database file to demo. |
|
| 10/17/2012 |
Downtown Portland Workshop |
Questions and Answers |
Have a question? Bring your Access database file to demo. |
|
| 10/3/2012 |
Tigard Workshop |
UNION queries / Date Control |
- UNION queries; when to use and how to create .
- Date Control; are you using the new date picker. Can you add mnemonics for quick entry.
- Have a question? Bring your Access database file to demo.
|
|
| 9/19/2012 |
Downtown Portland Workshop |
Questions and Answers |
Have a question? Bring your Access database file to demo. |
|
| 9/5/2012 |
Tigard Workshop |
Create email with VBA / Pass-thru Queries |
- Have you attached a background image to an email in code, only to have the recipient not be able to see it? You need to add the image as an attachment and link it as binary data.
- Are you using Pass-thru queries? How about creating the query on the fly?
- Have a question? Bring your Access database file to demo.
|
|
| 8/15/2012 |
Downtown Portland Workshop |
Questions and Answers |
Have a question? Bring your Access database file to demo. |
|
| 8/1/2012 |
Tigard Workshop |
Access 2013 Preview |
The Access 2013 Preview is out. We need to start looking at what Access 2013 is and how we are going to use it. Also I hope to get an update from Steve Titus on his success with using ADO. |
|
| 7/18/2012 |
Downtown Portland Workshop |
Questions and Answers |
Have a question? Bring your Access database file to demo. |
|
| 7/4/2012 |
Tigard Workshop |
No Meeting this date |
Have a Happy 4th |
|
| 6/20/2012 |
Downtown Portland Workshop |
Helen Fedderman's 2007 VBA Bible Overview |
One of the available downloads from Helen Fedderman's 2007 VBA Bible on the Wiley website will be reviewed. If you don’t have this book, it is one you should consider adding to your library.
Have a question? Bring your Access database file to demo. |
|
| 6/6/2012 |
Tigard Workshop |
Binding Forms to ADO recordsets |
Have you considered binding a form to a ADO recordset? Is there and advantage?
Have a question? Bring your Access database file to demo. |
|
| 5/16/2012 |
Downtown Portland Workshop |
No Meeting this date |
Meeting canceled! |
|
| 5/2/2012 |
Tigard Workshop |
No Meeting this date |
See you at the conference |
|
| 4/18/2012 |
Downtown Portland Workshop |
VBA and form controls / Questions and Answers |
Have a question? Bring your Access database file to demo.
Main Topic: Using common event code for multiple form controls, and building control properties using code. |
|
| 4/4/2012 |
Tigard Workshop |
Alpha 5...is it a possible replacement for Access? |
Jim Dusoe from Alpha 5 will be doing a Webinar.
- Show what is possible with Alpha
- Case Manager (general operation, charts/maps)
- Reports
- Overview of the Alpha IDE, diagrams
- Quickly build a grid sample
Pat Bremkamp, an Alpha Software developer in Hillsboro OR for the past 10 years, is also planning on attending to answer questions. |
|
| 3/21/2012 |
Downtown Portland Workshop |
Questions and Answers |
Have a question? Bring your Access database file to demo. SQL Parser WROX downloaded code by Armen Stein will be presented.
|
|
| 3/7/2012 |
Tigard Workshop |
Controlling the amount of data displayed in Access |
Reducing the amount of data transferred across the wire.
Search forms
Limited Data forms
Standard DataGrid
ActiveX DataGrid
Listboxes
Have a question? Bring your Access database file to demo. |
|
| 2/15/2012 |
Downtown Portland Workshop |
Questions and Answers / Strategy for comparing alternatives |
Have a question? Bring your Access database file to demo.
A strategy for comparing alternative efficiencies will be presented. |
|
| 2/1/2012 |
Tigard Workshop |
Database Bloat and Best Practices |
What causes database bloat and what can I do about it?
What are the Best Practices with Access applications?
Don't forget, if you have a question, bring your Access database file to demo. |
|
| 1/18/2012 |
Downtown Portland Workshop |
Questions and Answers |
Have a question? Bring your Access database file to demo.
Backing Up, Deleting, and Importing data will be covered. |
|
| 1/4/2012 |
Tigard Workshop |
Questions and Answers |
Have a question? Bring your Access database file to demo. |
|
| 12/21/2011 |
Downtown Portland Workshop |
No Meeting this date |
Merry Christmas |
|
| 12/7/2011 |
Tigard Workshop |
Continuing with using SQL Express and Access |
Creating a DSN, there are several types.
Linking and Relinking ODBC connections
Don't forget to bring your questions? If you have an Access database file to demo, bring it to. |
|
| 11/16/2011 |
Downtown Portland Workshop |
Questions and Answers |
Bring your Access questions for group discussion. |
|
| 11/2/2011 |
Tigard Workshop |
Using SQL Express with Access |
Review accessing SQL Express
Have a question? Bring your Access database file to demo. |
|
| 10/19/2011 |
Downtown Portland Workshop |
File Scripting Object |
Dave will present two ways he often uses the file scripting object (FSO)
Have a question? Bring your Access database file to demo. |
|
| 10/5/2011 |
Tigard Workshop |
Where should you install your Access Frontend. |
If you use a directory under Program Files, you are in for problems.
Have a question? Bring your Access database file to demo. |
|
| 9/7/2011 |
Tigard Workshop |
Questions and Answers |
Have a question? Bring your Access database file to demo. |
|
| 8/17/2011 |
General |
No General meeting in August |
|
|
| 8/3/2011 |
Tigard Workshop |
Questions and Answers |
Have a question? Bring your Access database file to demo. |
|
| 7/20/2011 |
General |
No General meeting in July |
|
|
| 7/6/2011 |
Tigard Workshop |
Questions and Answers |
Have a question? Bring your Access database file to demo. |
|
| 6/20/2011 |
Downtown Portland Workshop |
Questions and Answers |
Have a question? Bring your Access database file to demo. |
|
| 6/15/2011 |
General |
Improve Me |
Bring a problem that you solved, but have that feeling there could be a better way. Share your solution and get some input in a different paradigm. |
|
| 6/1/2011 |
Tigard Workshop |
Office 365 |
What is it and what can I do with it? |
|
| 5/18/2011 |
General |
No General meeting! |
|
|
| 5/4/2011 |
Tigard Workshop |
Questions and Answers |
Have a question? Bring your Access database file to demo. |
|
| 4/20/2011 |
General |
Archiving Records And Using Archived Records As A Starting Point for New Records |
|
|
| 4/20/2011 |
Tips and Tricks |
GMail with SMTP |
Send email without using Access SendObject method. |
|
| 4/6/2011 |
Tigard Workshop |
Questions and Answers |
Have a question? Bring your Access database file to demo. |
|
| 3/16/2011 |
General |
Custom Report Writer |
|
|
| 3/2/2011 |
Tigard Workshop |
Questions and Answers |
Have a question? Bring your Access database file to demo. |
|
| 2/16/2011 |
General |
How do you Drupal? |
Drupal is a popular, free, open source web content management system. Nancy will present her experiences and impression of the platform. |
|
| 2/2/2011 |
Tigard Workshop |
Questions and Answers |
Have a question? Bring your Access database file to demo.
|
|
| 1/19/2011 |
General |
Switching printers and paper size |
|
|
| 1/19/2011 |
Tips and Tricks |
Color my Report |
When conditional formatting falls short - how to color inside the lines. |
|
| 1/5/2011 |
Tigard Workshop |
Questions and Answers |
Have a question? Bring your Access database file to demo.
Possible topic; The technique of using a form to enter query criteria, commonly known as 'Query by form' (QBF). In its more complex implementations, QBF can involve using a lot of code to construct an SQL statement out of thin air. QBFs can be used as sources of datasheets, forms, reports, and most anything else that a normal query can be used for. |
|
| 12/15/2010 |
General |
The Best of the Best |
Our annual party meeting. Pizza and Prizes! Pizza for everyone, Prizes for anyone who participates by sharing their favorite 3rd party tool or the coolest solution they created this year. BIG prizes (you'll be impressed!) for the BEST solution as voted by an audience of your peers. Please email nancy@comsmiths.com with your topic.
You each get 5 minutes. |
|
| 12/1/2010 |
Tigard Workshop |
Questions and Answers |
Have a question? Bring your Access database file to demo.
We did not get to talk about 'Backward Compatibility between Access 2010 and Access 2007' at the last meeting, so let's try again this month.
|
|
| 11/17/2010 |
General |
Querying to Infinity and Beyond |
Since the time when dinosaurs ruled the earth, how to provide query capability for your users without compromising the database has been a problem for developers. Everyone has their own interface system for enabling users to select and filter records but, can they save these selections for later recall and use? Can other users have access to them easily? What happens when you supply a new front end; are they lost? Will it keep them from messing with your internal system queries?
A simple Query Manager that can be dropped into any Access database is the answer. Unleash the full power of the Access Query Wizard and QBE while still keeping users from hurting themselves. (It’s so simple that even a beginner can implement it.)
Also, a bonus! Ever needed test data that really mimicked the real world? Using a real list can have liabilities; but now with a new function that scrambles field values you can create your own. This will turn a normal table into one in which the First Name no longer goes with its former Last Name, but rather with a random new one; and so forth. Use it to generate realistic but totally useless data for testing your applications or just messing with clients!
|
|
| 11/3/2010 |
Tigard Workshop |
Questions and Answers |
Have a question? Bring your Access database file to demo.
Possible topic...Backward Compatibility between Access 2010 and Access 2007.
|
|
| 10/20/2010 |
General |
Armen's Kick Off Presentation |
Armen will share a small Access/SharePoint web app, and talk about the pros and cons of this architecture. |
|
| 10/6/2010 |
Tigard Workshop |
Questions and Answers |
Have a question? Bring your Access database file to demo.
Possible topic...Review the recent Microsoft Access blog post about implementing a Soundex search on a web form. |
|
| 9/15/2010 |
General |
Images Galore - ImageMSO app |
Directory snapshot class - generalized routine for making a recordset of entries in a specified directory.
Method of synchronizing a table of directory items with the directory (IconFileManagement, OfficeIcon_fm)
Loading an imagelist control associated with a listview control (OfficeRibbonItem_SL)
Using a form with a listview control to return values to a calling form (OfficeRibbonItem_FM, Example... form)
Generating sample databases with ribbons that have ms office commands (MSOGalleryFunctions) |
|
| 9/15/2010 |
Tips and Tricks |
Logging Changes |
Jack found an app that logs all changes made to a database that's easy to implement. |
|
| 9/1/2010 |
Tigard Workshop |
Questions and Answers |
No planned topic.
Have a question? Bring your Access database file to demo. |
|
| 8/18/2010 |
General |
No General meeting in August |
|
|
| 8/4/2010 |
Tigard Workshop |
Questions and Answers |
If no one has any pressing questions that need to be answered, I think reviewing the updated 2010 Northwind database might be a good topic to review. Another topic could be reviewing the article posted on VB123.com, Preparing To Upgrade Access Tables to SQL Server 2005/2008. |
|
| 7/21/2010 |
General |
No General meeting in July |
|
|
| 7/7/2010 |
Tigard Workshop |
Questions and Answers |
No planned topic.
Have a question? Bring your Access database file to demo. |
|
| 6/16/2010 |
General |
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! |
|
| 6/16/2010 |
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 |
|
| 6/2/2010 |
Tigard Workshop |
Questions and Answers |
When was the last time you had to read the values from a subform. See the Smart Access link Accessing Subforms.
Other interesting articles, The Billable Hour Trap and When Clients Mess Things Up. |
|
| 5/19/2010 |
General |
Pushing the Envelope - Technology Today... and Tomorrow |
An overview of conventional and unconventional technology in the areas of: Connectivity, Social, Personal, Home, Medical, Account management and Travel. |
|
| 5/19/2010 |
Tips and Tricks |
Custom ToolTip Hover |
|
|
| 5/5/2010 |
Tigard Workshop |
No Meeting in May |
|
|
| 4/21/2010 |
General |
No Meeting |
|
|
| 4/7/2010 |
Tigard Workshop |
Questions and Answers |
Resent post on Access Unlimited discussed when to write code and when to let Access do what it does...see link. With Access 2010 this will become even more important. Should make for a good discussion.
Bring your Access file to demo your question. |
|
| 3/17/2010 |
General |
When Eight is Not Enough |
Use the Treeview Control for your database menu and say GoodBye to the 8 button limit of the Switchboard manager. |
|
| 3/17/2010 |
Tips and Tricks |
Back to Back |
I'll show you my solution for creating a back to back ID card report in Access. It's trickier than it sounds. |
|
| 3/3/2010 |
Tigard Workshop |
Questions and Answers |
No specific planned topic.
Bring your Access file to demo your question. |
|
| 2/17/2010 |
General |
Prize Winning Ribbons |
This application demonstrates one way to implement a custom ribbon as a menu system for the application. |
|
| 2/17/2010 |
Tips and Tricks |
Photo Handling |
Tricks for displaying photos on forms and reports. Handling exceptions without photos. |
|
| 2/3/2010 |
Tigard Workshop |
Using a SQL backend. |
|
|
| 1/20/2010 |
General |
Seven Steps to Protecting Yourself as an Independent Contractor |
|
|
| 1/6/2010 |
Tigard Workshop |
Questions and Answers - Standards |
|
|
| 12/16/2009 |
General |
The Best of the Best |
|
|
| 12/2/2009 |
Tigard Workshop |
Questions and Answers |
|
|
| 11/18/2009 |
General |
Microsoft SharePoint |
|
|
| 11/18/2009 |
Tips and Tricks |
SharePoint and Access 2010 |
|
|
| 11/4/2009 |
Tigard Workshop |
User Interface Design |
|
|
| 10/21/2009 |
General |
Build Robust Applications by Avoiding Hard-Coding |
|
|
| 10/7/2009 |
Tigard Workshop |
Questions and Answers |
|
|
| 9/16/2009 |
General |
PAUG wants YOU! Or at least your ideas! |
|
|
| 9/2/2009 |
Tigard Workshop |
Windows 7 and the new Virtual PC |
|
|
| 8/19/2009 |
General |
Displaying the status of multi-step processes |
|
|
| 8/19/2009 |
Tips and Tricks |
Linking an Access database into SQL Server |
|
|
| 8/5/2009 |
Tigard Workshop |
Working with customers |
|
|
| 7/15/2009 |
General |
What You Need to Know About Nulls |
|
|
| 7/15/2009 |
Tips and Tricks |
Eval Evaluation |
|
|
| 7/1/2009 |
Tigard Workshop |
Questions and Answers |
|
|
| 6/17/2009 |
General |
Flexible Error Handling Using a Class Module |
|
|
| 6/17/2009 |
Tips and Tricks |
Weekday Names Prior to any Given Date |
|
|
| 6/3/2009 |
Tigard Workshop |
Virtual PC |
|
|
| 5/20/2009 |
General |
Booklet Printing from Access |
|
|
| 5/20/2009 |
Tips and Tricks |
Reading Environment Variables |
|
|
| 5/6/2009 |
Tigard Workshop |
No May meeting! |
|
|
| 4/15/2009 |
General |
A Custom Switchboard, and Transferring Access Data to Quicken |
|
|
| 4/15/2009 |
Tips and Tricks |
Word 2007 Magic |
|
|
| 4/1/2009 |
Tigard Workshop |
Designing with the Access 2007 method standards |
|
|
| 3/18/2009 |
General |
Metadata: Data About Data |
|
|
| 3/18/2009 |
Tips and Tricks |
Dynamic Email Text Substitution |
|
|
| 3/4/2009 |
Tigard Workshop |
Questions and Answers |
|
|
| 2/18/2009 |
General |
Identifying and Handling Duplicate Records |
|
|
| 2/18/2009 |
Tips and Tricks |
Real Time Status Updates |
|
|
| 2/4/2009 |
Tigard Workshop |
Questions and Answers |
|
|
| 1/21/2009 |
General |
Bragging Rights and Pizza Party! |
|
|
| 1/7/2009 |
Tigard Workshop |
Questions and Answers |
|
|
| 12/17/2008 |
General |
Bragging Rights and Pizza Party! - **Postponed until January** |
|
|
| 12/3/2008 |
Tigard Workshop |
Questions and Answers |
|
|
| 11/19/2008 |
General |
Sorting Continuous Forms |
|
|
| 11/19/2008 |
Tips and Tricks |
Code for Code |
|
|
| 11/5/2008 |
Tigard Workshop |
Questions and Answers |
|
|
| 10/15/2008 |
General |
An Array of Alternatives |
|
|
| 10/15/2008 |
Tips and Tricks |
Bits and Binary and Combination Permutations |
|
|
| 9/17/2008 |
General |
Visio Designing |
|
|
| 8/20/2008 |
General |
CANCELLED for August - See you on September 17th |
|
|
| 7/16/2008 |
General |
Creating and Using a Series of Functions |
|
|
| 6/18/2008 |
General |
The Wizard's Favorite Tools and Tricks |
|
|
| 5/21/2008 |
General |
Access MDI (Multiple Document Interface) |
|
|
| 5/21/2008 |
Tips and Tricks |
Bat to Exe |
|
|
| 4/16/2008 |
General |
Canceled |
|
|
| 3/19/2008 |
General |
That Tasking Text Task |
I've had the opportunity recently to do a couple projects importing text files into Access tables. I want to share what I've learned, and show the interface I developed. I ended up building an interface that allows the users to import the data with as few clicks as possible. |
|
| 3/19/2008 |
Tips and Tricks |
Make Cents of Currency |
There is a quirk in the Currency data type that can cause problems if you don’t know it’s there. Walt will expose the quirk and explain how you can inoculate yourself against it. |
|
| 2/20/2008 |
General |
DeBug DaCode |
We all write code differently. We all fix it up differently. I'll show you everything I've picked up about debugging.
Whatever I leave out, the audience can contribute. |
|
| 2/20/2008 |
Tips and Tricks |
Run Run Run Command |
Information on RunCommand constants (more than 500) from Access/VBA help, Microsoft's web sites, or major Access books, is woefully inadequate. I will provide a great deal of documentation and demonstrate the principles of using this powerful command. |
|
| 1/9/2008 |
General |
SharePoint |
My experiences employing SharePoint in real life. |
|
| 1/9/2008 |
Tips and Tricks |
Treasures found on PAUG.com |
We have a large and valuable library downloads from former presentations over the years. I made use of a few and would like to share with you the treasure trove I found. Three ideas have changed my use of access: not-in-list functions, the open form common code, and the use of a common code library. |
|
| 11/21/2007 |
General |
Parameterized Queries |
Parameterized queries within forms and ADO. |
|
| 11/21/2007 |
Tips and Tricks |
Debug... Da Bomb |
Most developers know more than a few debug tools and tricks. I'll share my favorites and you can add yours. (For any of you who don't have teenagers living with you, Da Bomb translates to "The Best!".) |
|
| 10/17/2007 |
General |
Behavior-Driven Development |
Detailed specifications are great -- they tell you exactly what your software is supposed to do. But there's a gaping chasm between a Word document and a living, breathing application. I'll give you a peek at a bleeding-edge approach to writing executable specifications that comes from the far-off Planet Ruby. Then, I'll come back down to Earth and talk about how you can apply the values behind the techniques to improve your own work, given the constraints imposed by Access (not to mention the need to actually get paid someday). |
|
| 9/19/2007 |
General |
DVD Buttons on Forms |
For best performance, we know that we should open detail forms to just one record at a time. But then we lose an easy way for the user to quickly navigate between records. In this presentation, Armen will show how J Street Technology implements "DVD buttons" on detail forms. Once you understand how they work, you'll be able to add them to your own forms. Armen will also make the code available. |
|
