PAUG...The Portland Oregon MS Access Database User Group
| Filename | Date | Size (KB) |
Description |
|---|---|---|---|
| UsingFSO.zip | 10/20/2011 | 97 | Two uses for the File system object or scripting. Presentation by Dave White. Browses folders and files, and creates an html index to a directory. |
| CDO_SMTP_email_v2.zip | 8/14/2011 | 259 | Sample file of how to use CDO for email, uploaded to UtterAccess. |
| EnableDisableShiftBypass.mdb | 6/24/2011 | 332 | Code to enable or disable the Shift key bypass of an MDB file from Ed Arnold |
| Safe Closing.zip | 12/18/2010 | 36 | Sample file Walter White showed to prevent closing your database. |
| GoogleMapping.zip | 12/15/2010 | 861 | Displaying Google maps and how to print. Access 2007 and 2010 from Malcolm Dixon and Bonnie Hicks. |
| File Dialog.accdb | 12/13/2010 | 744 | Samples of using the Excel, Word and Access FileDialog object. 32/64bit. |
| NeedleDB.zip | 12/13/2010 | 174 | Needle dashboard class coded by Malcolm Dixon |
| DatabaseGraphics.zip | 12/13/2010 | 865 | Dashboard graphics by Developed by Mike Alexander: www.datapigtechnologies.com |
| AccessUITechniques.ppt | 11/18/2010 | 163 | Armen's User Interface techniques |
| So Many Choices.ppsx | 11/18/2010 | 429 | Armen's October 2010 presentation on the pros and cons of various development platforms from Access front/back to Access front end with SharePoint Web App back end. |
| modAudit.bas | 9/16/2010 | 5 | Code module to easily add auditing of all data changes on a form demoed by Jack Stockton. |
| imageMso2.zip | 9/15/2010 | 4609 | Dave White's presentation on imageMSO images and listview / imagelist controls |
| XMLWord.zip | 8/29/2010 | 779 | Database, forms, templates and PowerPoint presentation from David Larson on XML to Word |
| The word is XML.pptx | 8/28/2010 | 343 | Using XML to export data to Word |
| Menu_Tree.zip | 3/18/2010 | 241 | Steve's file used in his presentation of how to use a tree control for a menu instead of the Switchboard. |
| RibbonImplementation.zip | 2/18/2010 | 3562 | Steps for using a ribbon for navigation. Includes a complete application with a ribbon for navigation by Dave White. |
| 7 Steps for Independent Contractors.ppt.pdf | 1/30/2010 | 3485 | Attorney Sara Adams (daughter of Tom Howe) |
| BuildRobustApplicationsByAvoidingHard-Coding.pps | 10/21/2009 | 10000 | Armen Stein's PowerPoint presentation at the 10/21/2009 General meeting. |
| ProcessingDisplay.zip | 8/20/2009 | 213 | Display progresss of a multi-step procedure. Access 2000 & 2007 samples. Jack Stockton |
| PAUG20090617DateDemo.zip | 6/18/2009 | 972 | George Hepworth demo on returning the date for any weekday prior to the passed in input date with language selection. |
| BookletPrinting.zip | 5/21/2009 | 3781 | Dave White gives details on how to print a booklet style report, either directly from Access or by PDF reader. |
| Duane_PAUG_March.zip | 3/18/2009 | 236 | Duane Moore showed us different types of metadata logging and how they can be used. These metadata logs include error, user, menu usage, and timing logs. Also his list of free software. |
| PAUG_Progress_Indicator.zip | 2/18/2009 | 1121 | Duane Moore shows some simple ways to overcome user feedback limitations to provide a better interface. Several methods are shown, including the traditional status bar message, status bar progress meter, and some homemade progress meters. |
| DealingWithDupes.zip | 2/18/2009 | 276 | Geoff Hollander's techniques and code for identifying duplicates such as creating successful matchcodes, using Soundex and polling functions to determine the degree of match between entities. |
| Sorting_Demo.zip | 11/19/2008 | 1439 | Jason Martinez file demonstrating sorting continuous forms, including an approach for sorting multiple columns. |
| Arrays.zip | 10/27/2008 | 145 | Jeff Croxford's care and feeding of arrays. When are arrays the best bet and when alternatives could be just as suitable. |
| ApplicationPrototypingUsingMicrosoftVisio.zip | 9/28/2008 | 5005 | Armen Stein's Visio templates and stencils. Use stencils to quickly build design sketches that will match your application. |
| PasswordsDB.zip | 6/18/2008 | 3197 | Mark Hammer's Passwords Database. |
| WizardsToolbox.zip | 6/18/2008 | 7557 | Mark Hammer's Wizard's Toolbox |
| rdc_vba.zip | 3/24/2008 | 248 | Sometimes you have to use Crystal Reports. This file contains samples that demonstrate how to integrate the Report Designer Component with Access VBA. Source Link. |
| CurrencyQuirk.zip | 3/24/2008 | 67 | There is a quirk in the Currency data type that can cause problems if you don’t know it’s there. Walt White exposes the quirk and explain how you can inoculate yourself against it. |
| BaseFor2007User.zip | 3/18/2008 | 232 | Sample file for dealing with Access 2007 users in your 2000 database by Jack Stockton. |
| GUIDSample.zip | 3/6/2008 | 204 | Demo of using a GUID string. Include function to generate and sample forms of usage. Additionally, MakeID function for importing data. By Jack Stockton |
| RunCommand constants Access Menu visuals.pdf | 2/25/2008 | 224 | Accompaning file to Duanes presentation. |
| RunCommand.zip | 2/25/2008 | 157 | Information on RunCommand constants (more than 500). Presentation by Duane Moore |
| CodeCDX_350.zip | 2/14/2008 | 953 | CodeCDX is a working archive for your VBA code. As a code library (databse) you can use, store and refine your code in one place and easily deploy it with your applications. - Geoff Hollander. |
| NotInList.zip | 1/22/2008 | 216 | By Rick Rickard - Examples of Automated response to not in list, and Check marks instead of check boxes |
| SharePoint_OverviewListsLibraries.pps | 1/19/2008 | 10000 | SharePoint 2007 Lists and Libraries, plus an overview of SharePoint capabilities by Kristie Gladhill. |
| Parameterized Queries ppt.zip | 11/24/2007 | 453 | Great Power Point presentation notes from Jason Martinez on parameterized queries. |
| Parameterized Queries mdb.zip | 11/24/2007 | 973 | Sample database to go with Jason Martinez Great Power Point presentation on parameterized queries. Access 2000 format. |
| ActiveX_2000.zip | 10/31/2007 | 17 | This 2000 Access Db contains a form with a variety of ActiveX controls that come with Access; in theCommon Controls ocx. Follow the directions on the opening form to resgister this library on your machine so the sample form will work. |
| bdd_talk.zip | 10/20/2007 | 595 | Sam Gray's presentation on Behavior Driven Development. |
| DVD Buttons Example 2000.zip | 9/30/2007 | 493 | Armen's DVD buttons example...converted to Access 2000 format. |
| DVD Button Example.zip | 9/20/2007 | 3003 | Armen's DVD buttons example...2003 format. |
| SortFilter.zip | 9/14/2007 | 584 | By Nancy Smith: Simple form that filters on criteria collected from several fields. Also sorts on one field. Name unbound filter controls to match the field to drop in any form. |
| VBA Presenation - 2007-08.zip | 8/8/2007 | 30 | VBA Presentation file, August 2007 |
| Duane Moore - ShellEx Presentation.zip | 6/21/2007 | 1350 | ShellExec. Two simple Win32API functions can be used in Access to provide functionality beyond what Access offers. With ShellExecute, you can send email, open web pages, view or print documents, and much more. By Duane Moore - Access Curmudgeon |
| DataMigration_PAUG.ppt | 6/21/2007 | 278 | Data Migration – Overview of data/database migration best practices, tools, and case studies. By Frank Bubenik – co-owner of Compass Computing Group, Inc. |
| ASP.NETresources.doc | 3/20/2007 | 31 | From Scott Walker. A list of online and print resources for beginning ASP.NET 2.0 and database development for the Internet. |
| ExcelExport2.zip | 2/21/2007 | 804 | Jack Stocktons Exploration of exporting a query to Excel; DoCmd.OutputTo, DoCmd.TransferSpreadsheet, DoCmd.SendObject and Excel automation. |
| TableDesign.zip | 1/25/2007 | 420 | Sample database used to explore table design at Fundamentals meeting. |
| ListBoxFun.zip | 12/20/2006 | 39 | Rick Rickards sample file exploring the power of the List Box. |
| JeffCroxfordCrosstab.zip | 6/21/2006 | 267 | Presentation by Jeff Croxford dealing with dynamic crosstab queries |
| MacroSecurity.zip | 3/15/2006 | 897 | Jack Stockton's Power Point slide show he used at this presentation on Macro Security. Good stuff, a must know for everyone. |
| DisplayMessage.zip | 12/21/2005 | 372 | Demonstrates a way to display messages to the user when you are running a multi-process activity. Presented by Jack Stockton |
| AccessUITechniques.zip | 10/19/2005 | 107 | Armen Stein's JStreet User Interface Techniques |
| CalendarTestE.zip | 10/19/2005 | 230 | Edie Felix's Calendar and Time Picker from Tips and Tricks |
| JulyDuane.zip | 7/20/2005 | 1187 | Dont know how to spell? Use SOUNDEX. Also report/form tricks. |
| RegExPaug.zip | 5/18/2005 | 3530 | Regular Expressions for data validation, cleanup, filtering and string manipulations. Adnan Khan Tips and Tricks |
| colorstuff.zip | 5/18/2005 | 371 | The Almost Wonderful World Of Color By Bob Allen--Presentation covers VB Colors, QB Colors, RGB Colors and System Colors. |
| DWhiteAutoDocTool.zip | 4/20/2005 | 1154 | Dave White presents code modules and exported spreadsheets and reports useful in researching and documenting Access applications. |
| SteveJTips.zip | 4/20/2005 | 93 | Steve Jorgensen presents Spellchecking in Access and code for making popup forms partially transparent. |
| GetDatabaseStructure.txt | 12/22/2004 | 5 | Code to return database and table structure--provided by Steve Titus |
| ArmenSteinPresentation.zip | 12/15/2004 | 1258 | Techniques by Armen Stein to make Access applications easier to use and more professional-looking. They range from user interface design recommendations, to handy techniques for daisy-chaining forms, finding records, incrementing dates. |
| AntiBloatTipsJGroh081704.doc | 8/18/2004 | 25 | Avoiding bloat by using a temp database; Avoiding the need to hack the registry when working with a large rs in DAO by Jan Groh |
| BobAllenmicrosoftaddons.zip | 7/21/2004 | 4352 | Microsoft Addins by Bob Allen (tongue in cheek) |
| Base2.zip | 7/21/2004 | 585 | Super Numbers Presentation by Bob Allen at General Meeting |
| Extending Access.Zip | 5/23/2004 | 990 | Extending Access Presentations by Duane Moore at 2004 Spring Conference |
| scope.pdf | 5/23/2004 | 3100 | Presentation on Project Scope by Roger Parish |
| steriods2.pdf | 5/23/2004 | 330 | Data Modeling on Steroids II by Roger Parish (Conference 2004 presentation) |
| steriods1.pdf | 5/23/2004 | 638 | Data Modeling on Steroids I by Roger Parish (Conference 2004 presentation) |
| GetARow.zip | 4/21/2004 | 120 | Fantatastic cross tab trick presented by Rick Rickards of Everest Consulting |
| JackStocktonAndGeoffrey.zip | 3/17/2004 | 68 | Presentation by Jack Stockton; Input Prompt for query criteria which includes default; How to get to, alter, or create database properties and what they can do for you (icon example, includes icon) |
| SLG-X12.zip | 2/18/2004 | 489 | OOP: I Did It Again--Slides and handouts from Sam Livingston-Gray presentation |
| Conf2003HankP--CrossTab.zip | 4/1/2003 | 62 | Conference 2003--Hank Piatek on Hacking the CrossTab Query--Create editable, accessable cross tab queries using boolean logic and go the extra step by using Rozenshtein functions. Must have for any serious query fanatic. Includes Rozenshtein crib-sheet. |
| Conf2003HankP--HankPiatekDotNET.zip | 4/1/2003 | 118 | Conference 2003--Hank Piatek on Dot NET for the Access Programmer--Web Service stuff too--If you are interested in DOT NET, here is where to start. |
| Conf2003MarkH--WizardToolBoxFormsFandango.txt | 4/1/2003 | 1 | Conference 2003--Mark Hammer Forms Fandango and Wizard Tool Box II. Plethora of items to enhance your database and form design. A must have for any serious programmer. Get those bells and whistles that you only see in professional applications. |
| Conf2003PatrickC--MSDE.ppt | 4/1/2003 | 76 | Conference 2003--Patrick Caldwell presentation on understanding MSDE--Patrick was the keynot speaker at the conference. |
| Conf2003SteveJ--2003 Spring Conference.zip | 4/1/2003 | 144 | Conference 2003--Steve Jorgensen presentations on Taming the Dataview and Disconnected Recordsets. You will never be the same once you realize the functionality of dataviews and realize that recordsets have a life of their own. 2 separate presentations. |
| Conf2003HankP--AdvancedPrinting.zip | 4/1/2003 | 373 | Conference 2003--Hank Piatek on Advanced Printing |
| Conf2003--How to get Code Tools.txt | 4/1/2003 | 1 | Directions where to order Pat Gibson Code Tools. Very handy code library-plus that was demonstrated by Hank Piatek at the 2003 Silver Falls Conference. Only $10 and well worth it! |
| Conf2003SteveT--GraphStuff.zip | 4/1/2003 | 4446 | Conference 2003--Presentation by Steve Titus on Graphs and Charts. One of a kind; someone finally explains it the way it really is. This download chock full of stuff. Be careful, you will never be the same! |
| Conf2003PatrickC--SQLXML.ppt | 4/1/2003 | 40 | Conference 2003--Patrick Caldwell presentation on SQLXML addin for SQL Server--Patrick was the keynot speaker at the conference. |
| Conf2003PatrickC--Web Services and You.ppt | 4/1/2003 | 42 | Conference 2003--Patrick Caldwell presentation on Web Services--Patrick was the keynot speaker at the conference. |
| Conf2003SteveT--References.zip | 4/1/2003 | 2610 | Conference 2003--Presentation by Steve Titus on References. For those that think they know everything about references. Steve takes you on a journey to the hidden land of how Access understands where to find it and how to do it. |
| Conf2003SteveT--Security.zip | 4/1/2003 | 2522 | Conference 2003--Presentation by Steve Titus on Access Security. Learn why people avoid Access security and learn what Steve does to be able to live with it. You can't buy this stuff anywhere. Only at a PAUG conferen |
| PAUGNETFullCourse.zip | 2/2/2003 | 19000 | Complete Samples of PAUG DOT NET SIG by Tom Howe. .NET Framework and SQL Server needed to run samples. Pretty darn good examples. |
| SteveJ--Feb 2003 TipTricks.zip | 2/1/2003 | 537 | Steve Jorgensen shows how to compress and save images in an Access database |
| AnatomyOfAFunction.zip | 1/15/2003 | 92 | Excellent break down of using functions, proper naming conventions, and error handling. This material by Sam Grey, presented at January General Meeting, provides an excellent reference to those wondering or already in the know. |
| JoelKTreeview.zip | 12/18/2002 | 564 | Main presentation by Joel Koedoot on the VB Treeview control. In depth, very understandable power point slide show and accompanying .mdb file. Finally, the treeview control is demystified! |
| overlapping_date_ranges.zip | 9/18/2002 | 66 | Sam Gray presents Tips & Tricks on checking for overlapping date ranges. Download includes slides and demo database. |
| Structured_Laziness.zip | 8/21/2002 | 18 | Slides of main talk by Sam Gray on structured laziness. |
| ListAndComboDemo.zip | 7/14/2002 | 456 | July 2002 Fundamentals presentation by Jeff Honsworth. In depth coverage and examples of combo and list boxes. |
| RefTipTrick.zip | 5/16/2002 | 150 | Steve Titus's Tips and Tricks: Fixing References on the Fly with code originally by Peter Walker |
| DWIntroToDataWHPAUG20020515.ppt | 5/16/2002 | 1005 | Introduction to Data Warehousing. by Roger Parish, PMP President Spectrum Consulting Group, Inc. |
| DotNETCharts.doc | 1/9/2002 | 102 | Overview charts from Joanne DeHaan's "A Fish Eye View of .NET" presented at the .NET SIG |
| SteveTitusOutlook.zip | 12/18/2001 | 228 | Steve Titus's Outlook / Access Automation. Includes interesting copy to clipboard function(module2.txt) |
| HankPiatekDotNET.zip | 12/18/2001 | 163 | Hank Piatek explains .NET and C# at the .NET SIG using Power Point. Good starting point for anyone. |
| PMGConformBgrd.zip | 6/22/2001 | 22 | Pat Gibson's Changing the Background Color of the Current Record in a Continuous Form. This technique will highlight the current row in a continuous form. |
| TipsTricks061301.zip | 6/13/2001 | 13 | VB SIG tips and tricks on opening and closing folders. Includes code and example |
| RChauvet.zip | 6/12/2001 | 725 | Remove duplicates and Find no match functions. Look for them in module: "CleanUp before Referential Integrity Enforcement" |
| Access2Word.zip | 3/23/2001 | 1157 | Nancy Sittig Smith, PAUG's expert on Word VBA, presents some simple code to write data out to Word. Great for formatting and for data distribution. |
| FormsDesign102.zip | 2/20/2001 | 1317 | Mark Hammer's Form Design102 presentation |
| Graph0221.zip | 2/19/2001 | 545 | Steve Titus's presentation on building graphs using Access 97 |
| FormsDesign101_Install.zip | 11/14/2000 | 738 | Mark Hammer's Form Design 101 presentation. |
| AlanStrattonCombo.zip | 10/10/2000 | 17 | Combo Box API/Module. Alan Stratton's Tips and Tricks Presentation at the VB SIG. Includes Listbox code, examples. |
| DonorTrackerSetup.EXE | 10/7/2000 | 1336 | Mark Hammer's Complete Donor Tracker database. |
| Access2000dBaseFPro.zip | 6/23/2000 | 3 | The ISAM driver for xBase files which comes with Access 2000 no longer supports xBase indexes |
| PMGSubformsExample.zip | 6/23/2000 | 211 | Pat Gibson's mother of all subform examples |
| AdvReports.zip | 3/18/2000 | 762 | Hank Piatek's Advanced reports presentation. Lots of good stuff. |
| BobAllenTools.zip | 2/22/2000 | 264 | Bob Allen's "Randomize It" for hiding crucial data during testing and "Display Database"--a process that will traverse a database reviewing ever field in every record |
| KarlKnappEvents.zip | 2/15/2000 | 212 | Karl Knapp shows the ins and outs of Access Events. Includes PowerPoint presentation |
| CollectionsDemo.zip | 1/24/2000 | 174 | Programming with Collections--Presentation by Bob Regan--all you need to know about collections and then some. |
| PMGErrorHandler.zip | 11/22/1999 | 269 | Pat Gibson's outrageous error handler. Makes a print screen, sends an email, makes the coffee. . . . . |
| IDGen97.zip | 11/22/1999 | 104 | Steve Titus's Access database to lock records, generate Ids. Includes API calls to GetComuterName, GetUserName |