| Date |
Type |
Title |
Description |
|
| 9/7/2011 |
Access 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 |
Access 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 |
Access 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 |
Access Workshop |
Office 365 |
What is it and what can I do with it? |
|
| 5/18/2011 |
General |
No General meeting! |
|
|
| 5/4/2011 |
Access 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 |
Access Workshop |
Questions and Answers |
Have a question? Bring your Access database file to demo. |
|
| 3/16/2011 |
General |
Custom Report Writer |
|
|
| 3/2/2011 |
Access 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 |
Access 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 |
Access 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 |
Access 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 |
Access 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 |
Access 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 |
Access 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 |
Access 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 |
Access 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 |
Access 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 |
Access Workshop |
No Meeting in May |
|
|
| 4/21/2010 |
General |
No Meeting |
|
|
| 4/7/2010 |
Access 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 |
Access 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 |
Access Workshop |
Using a SQL backend. |
|
|
| 1/20/2010 |
General |
Seven Steps to Protecting Yourself as an Independent Contractor |
|
|
| 1/6/2010 |
Access Workshop |
Questions and Answers - Standards |
|
|
| 12/16/2009 |
General |
The Best of the Best |
|
|
| 12/2/2009 |
Access Workshop |
Questions and Answers |
|
|
| 11/18/2009 |
General |
Microsoft SharePoint |
|
|
| 11/18/2009 |
Tips and Tricks |
SharePoint and Access 2010 |
|
|
| 11/4/2009 |
Access Workshop |
User Interface Design |
|
|
| 10/21/2009 |
General |
Build Robust Applications by Avoiding Hard-Coding |
|
|
| 10/7/2009 |
Access Workshop |
Questions and Answers |
|
|
| 9/16/2009 |
General |
PAUG wants YOU! Or at least your ideas! |
|
|
| 9/2/2009 |
Access 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 |
Access 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 |
Access 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 |
Access Workshop |
Virtual PC |
|
|
| 5/20/2009 |
General |
Booklet Printing from Access |
|
|
| 5/20/2009 |
Tips and Tricks |
Reading Environment Variables |
|
|
| 5/6/2009 |
Access 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 |
Access 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 |
Access 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 |
Access Workshop |
Questions and Answers |
|
|
| 1/21/2009 |
General |
Bragging Rights and Pizza Party! |
|
|
| 1/7/2009 |
Access Workshop |
Questions and Answers |
|
|
| 12/17/2008 |
General |
Bragging Rights and Pizza Party! - **Postponed until January** |
|
|
| 12/3/2008 |
Access Workshop |
Questions and Answers |
|
|
| 11/19/2008 |
General |
Sorting Continuous Forms |
|
|
| 11/19/2008 |
Tips and Tricks |
Code for Code |
|
|
| 11/5/2008 |
Access 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. |
|
