Rx_
Nothing In Moderation
- Local time
- Today, 00:31
- Joined
- Oct 22, 2009
- Messages
- 2,803
Was reviewing the Denver Area Access Users Group (DAAUG) and came across this excellent presentation. This is probably something that will be more in demand for the next Access version as well.
There is an excellent Power Point Slide of the presentation plus credits that include: http://www.access-programmers.co.uk/forums/showthread.php?t=196662
Access data macros are similar to Triggers in SQL Server.
Also an interesting tidbit on XML.
There are over a dozen more free Access Downloads at the DAAUG site The titles and short descriptions are listed below - the site to link to the downloads is:
http://www.daaug.org/download.asp
Access Excel Automation - 8/1/2012 From Keith Poulin's April 2012 presentation, "Access Excel Automation" This presentation will cover the basic Excel capabilities that Access provides out of the box, as well as more advanced techniques for importing flexible spreadsheet formats and producing richly formatted Excel reports.
Microsoft Access Logging - 7/31/2012 From Lindsay Wert's November 2011 presentation, "Microsoft Access Logging" Discover an approach for consistently and easily logging run-time information from Access and VBA.
Focus on Access 2010: Table Macros - 7/30/2012 From Paul Schnitzler May 2011 presentation, "Focus on Access 2010: Table Macros"
A Generic Lookup Table Editing Form - 3/2/2011 From Jim Pilcher's March 2011 presentation, "A Generic Lookup Table Editing Form"
VBA Table Wrapper Classes - 6/17/2010 Lindsay Wert's Table wrapper classes
Crystal's Analyzer... the ultimate Data Dictionary Tool - 5/6/2010 Crystal's free Analyzer application to document databases.
How to Make an Add-in - 5/5/2010 Aaron Kogan's presentation on how to make an Add-in which includes an Add-in Template.
Access 2010 Web Database Template Relationship Diagrams - 4/9/2010 Access 2010 Web Database Template Relationship Diagrams, documented by Crystal, March 2010
Search Buddy - 3/4/2010 Aaron Kogan's Search Buddy (aka 'Search Pane') from his March 2010 presentation.
Outlook Attachment Options - 3/4/2010 Outlook Attachment Options utility (from Slovak Technical Services www.SlovakTech.com/AttachmentOptions.htm). Briefly presented by Aaron Kogan during the March 2010 meeting.
Importing Excel Data - 3/4/2010 Samples from Patrick Headley's March 2010 presentation, "Importing Excel Data".
'Tips and Tricks Inspired by Student Questions' Samples - 2/8/2010 Samples from Sco's January 2010 presentation, "Tips and Tricks Inspired by Student Questions"
Disable Mouse Wheel - 1/31/2010 From Sco's January 2010 presentation, the sample from Wayne Philips' EverythingAccess.com 'A new method for disabling the Mouse Scroll Wheel in Access forms'.
Table Interface Class Builder for DAAUG - 10/12/2009 Access, PPT, and related files from Lindsay's Presentation
MSDN Access Team Contributors' Toolkit - 5/21/2009 Background info on contributing to Power Tips
Access Add-ins and Code Snippets - 4/7/2009 More of Aaron Kogan's "Little Buddies" from his Code Library
Office Automation in Microsoft Access - 1/17/2008 Phil Ferrero demonstrated several techniques for automating Microsoft Word and Excel using Microsoft Access. He also demonstrated the differen between early and late binding in VBA code. Download and run this self extracting zip file to access the files that Phil used in his demonstration.
Word Automation from Access - 11/16/2006 This zip file was provided by member Alan Ruff as part of his demonstration on automating Microsoft Word by using Microsoft Access. When you unzip the files a new folder named C:\AccessAutomation will be created and the files placed in that folder. Everything will work from within that folder.
Hitting the Cycle with Outlook and Access - 4/20/2006 Mike Nindorf explained the application and processes that he built for his company to use in order to input data into Access from Outlook and then export that data into Word templates. Though he was unable to share the application with the group he has provided his presentation notes which includes code for gathering the data form Outlook and outputting it to Word.
The Access Sub-way - 2/16/2006 Subforms in Microsoft Access are possibly the most effective way to represent one-to-many relationships to your users. This download contains the forms and subforms that Jim used in his presentation.
DAO Transactions - 11/17/2005 (447 KB) Demo files preapared by M.L. "Sco" Scofield for his presentation on SQL Transactions. SQL Transactions allow you to process a set of SQL commands and commit the updates or roll back the updates as a batch, instead of one command at a time. In this way, you can roll back the set of SQL commands if one or more of the individual commands fail.
Practical Ways to Use XML with Access 2003 - 10/20/2005 (1.33 MB) presented by Tim Getsch, Microsoft Access Program Manager, Redmond, WA
A One-form Application - 9/15/2005 (29 KB) "Export Access Table Structure" Add-in presented by M.L. (Sco) Scofield
Unbound Forms - 8/18/2005 (780 KB) Presented by Jim Pilcher
Upsizing SQL Server - 7/15/2004 (16 KB) Presented by Kevin Bell
Recordsets in Microsoft Access - 6/20/2002 (264 KB) Presented by Barton P. Haase.
There is an excellent Power Point Slide of the presentation plus credits that include: http://www.access-programmers.co.uk/forums/showthread.php?t=196662
Access data macros are similar to Triggers in SQL Server.
Also an interesting tidbit on XML.
There are over a dozen more free Access Downloads at the DAAUG site The titles and short descriptions are listed below - the site to link to the downloads is:
http://www.daaug.org/download.asp
Access Excel Automation - 8/1/2012 From Keith Poulin's April 2012 presentation, "Access Excel Automation" This presentation will cover the basic Excel capabilities that Access provides out of the box, as well as more advanced techniques for importing flexible spreadsheet formats and producing richly formatted Excel reports.
Microsoft Access Logging - 7/31/2012 From Lindsay Wert's November 2011 presentation, "Microsoft Access Logging" Discover an approach for consistently and easily logging run-time information from Access and VBA.
Focus on Access 2010: Table Macros - 7/30/2012 From Paul Schnitzler May 2011 presentation, "Focus on Access 2010: Table Macros"
A Generic Lookup Table Editing Form - 3/2/2011 From Jim Pilcher's March 2011 presentation, "A Generic Lookup Table Editing Form"
VBA Table Wrapper Classes - 6/17/2010 Lindsay Wert's Table wrapper classes
Crystal's Analyzer... the ultimate Data Dictionary Tool - 5/6/2010 Crystal's free Analyzer application to document databases.
How to Make an Add-in - 5/5/2010 Aaron Kogan's presentation on how to make an Add-in which includes an Add-in Template.
Access 2010 Web Database Template Relationship Diagrams - 4/9/2010 Access 2010 Web Database Template Relationship Diagrams, documented by Crystal, March 2010
Search Buddy - 3/4/2010 Aaron Kogan's Search Buddy (aka 'Search Pane') from his March 2010 presentation.
Outlook Attachment Options - 3/4/2010 Outlook Attachment Options utility (from Slovak Technical Services www.SlovakTech.com/AttachmentOptions.htm). Briefly presented by Aaron Kogan during the March 2010 meeting.
Importing Excel Data - 3/4/2010 Samples from Patrick Headley's March 2010 presentation, "Importing Excel Data".
'Tips and Tricks Inspired by Student Questions' Samples - 2/8/2010 Samples from Sco's January 2010 presentation, "Tips and Tricks Inspired by Student Questions"
Disable Mouse Wheel - 1/31/2010 From Sco's January 2010 presentation, the sample from Wayne Philips' EverythingAccess.com 'A new method for disabling the Mouse Scroll Wheel in Access forms'.
Table Interface Class Builder for DAAUG - 10/12/2009 Access, PPT, and related files from Lindsay's Presentation
MSDN Access Team Contributors' Toolkit - 5/21/2009 Background info on contributing to Power Tips
Access Add-ins and Code Snippets - 4/7/2009 More of Aaron Kogan's "Little Buddies" from his Code Library
Office Automation in Microsoft Access - 1/17/2008 Phil Ferrero demonstrated several techniques for automating Microsoft Word and Excel using Microsoft Access. He also demonstrated the differen between early and late binding in VBA code. Download and run this self extracting zip file to access the files that Phil used in his demonstration.
Word Automation from Access - 11/16/2006 This zip file was provided by member Alan Ruff as part of his demonstration on automating Microsoft Word by using Microsoft Access. When you unzip the files a new folder named C:\AccessAutomation will be created and the files placed in that folder. Everything will work from within that folder.
Hitting the Cycle with Outlook and Access - 4/20/2006 Mike Nindorf explained the application and processes that he built for his company to use in order to input data into Access from Outlook and then export that data into Word templates. Though he was unable to share the application with the group he has provided his presentation notes which includes code for gathering the data form Outlook and outputting it to Word.
The Access Sub-way - 2/16/2006 Subforms in Microsoft Access are possibly the most effective way to represent one-to-many relationships to your users. This download contains the forms and subforms that Jim used in his presentation.
DAO Transactions - 11/17/2005 (447 KB) Demo files preapared by M.L. "Sco" Scofield for his presentation on SQL Transactions. SQL Transactions allow you to process a set of SQL commands and commit the updates or roll back the updates as a batch, instead of one command at a time. In this way, you can roll back the set of SQL commands if one or more of the individual commands fail.
Practical Ways to Use XML with Access 2003 - 10/20/2005 (1.33 MB) presented by Tim Getsch, Microsoft Access Program Manager, Redmond, WA
A One-form Application - 9/15/2005 (29 KB) "Export Access Table Structure" Add-in presented by M.L. (Sco) Scofield
Unbound Forms - 8/18/2005 (780 KB) Presented by Jim Pilcher
Upsizing SQL Server - 7/15/2004 (16 KB) Presented by Kevin Bell
Recordsets in Microsoft Access - 6/20/2002 (264 KB) Presented by Barton P. Haase.
