RPT Software
Contact Us Site Map Online Meeting
 Home    About Us    Products    Samples    Clients    Pricing Info    Help    Contact Us  


Help - Overview

This section of the website is provided to offer free help via articles and sample code examples developed by RPT Software. We have divided the help section into various sub sections to better help you find the article or sample code which interests you. If you don't see an article which answers your question feel free to contact RPT Software for immediate help or to ask for a future article to be written about your area of interest.

All articles and examples apply to Access 2000 thru Access 2007. We started this help section in April 2009 so we hope it will provide very up to date advice, we found that many Access help sites have grown old and stale.


Microsoft Access Templates

Templates or products RPT Software offers. Most of these products we charge a small fee to obtain the product or source code.


Microsoft Access Examples

Any article containing code that can be downloaded will be referenced in this section. Most of our Microsoft Access example articles will contain source code to help the user understand the details of the article or example.


Microsoft Access Ribbon Customization Part 1 (article date: Apr-5-2009)

This is part 1 of a 4 part series on how to customize the Access 2007 ribbon and other tips related to the quick launch toolbar and navigation pane. In this example we show the basics of doing your first ribbon, how to get started and other references to learn more. In parts 2 thru 4 of this series we add functionality to the ribbon and database.

Microsoft Access Ribbon Customization Part 2 (article date: Apr-5-2009)

This is part 2 of a 4 part series on how to customize the Access 2007 ribbon and other tips related to the quick launch toolbar and navigation pane. In this example we add on to Part 1 by adding a form to run reports and show how we can use a custom ribbon for print preview.

Filtering and Data Entry - Part 1 (article date: Apr-3-2009)

This example was built to demonstrate a simple use of one form with a listbox control that lets the user filter sort, add, edit and delete records and they can optionally open the record using another form which allows form-based data entry. This example is built in Access 2000 and uses a fair amount of code to help with things like sorting and filtering.

Filtering and Data Entry - Part 2 (article date: Apr-3-2009)

This example was built to demonstrate a simple use of a Microsoft Access 2007 datasheet that lets the user filter sort, add, edit and delete records and they can optionally open the record using another form which allows form-based data entry. This example uses primarily embedded macros for the majority of the logic, see Part 3 of this series of articles for this same example using no macros and only VBA code.

Filtering and Data Entry - Part 3 (article date: Apr-3-2009)

This example was built to demonstrate a simple use of a Microsoft Access 2007 datasheet that lets the user filter sort, add, edit and delete records and they can optionally open the record using another form which allows form-based data entry. This example uses VBA code for all logic, see Part 2 of this series of articles for this same example using primarily embedded macros and very little VBA code.

Microsoft Flex Grid Example (MSFLXGRD.OCX) (article date: Apr-1-2009)

This example was built to replace a Microsoft Excel solution with Microsoft Access. In this example the MSFlex Grid is used to improve the Access interface and particulary deal with an issue of editing data from a crosstab query, while leaving the interface close to the customer's original Excel worksheets.



Microsoft Access Tables

Microsoft Access tables and table design.


Microsoft Access Queries

Microsoft Access queries and query design.


Microsoft Access Forms

Microsoft Access forms and techniques used on forms.


Filtering and Data Entry - Part 1

This example shows a two page approach for filtering and data entry. Filtering and selection is done via a list box control which then opens a data entry form.

Filtering and Data Entry - Part 2

This example shows an Access2007 database with two pages for filtering and data entry. Filtering and selection is done via a datasheet with the option to open a data entry form. In this example the majority of the logic is built using embedded macros.

Filtering and Data Entry - Part 3

This example shows an Access2007 database with two pages for filtering and data entry. Filtering and selection is done via a datasheet with the option to open a data entry form. In this example the logic is built using VBA code.


Microsoft Access Reports

Microsoft Access reports and reporting techniques.


Microsoft Access Macros

Microsoft Access macros and their uses.


Microsoft Access Modules/VBA

Microsoft Access modules and vba code. Note: VBA code will be used in most examples but only examples that don't fit into another category will be found in this section.


Microsoft Access Third-Party Control and Libraries

Microsoft Access thrid-party controls (the ones we like). These examples tend to be bigger and more complex.


Microsoft Flex Grid Example (MSFLXGRD.OCX) (article date: Apr-1-2009)

This example was built to replace a Microsoft Excel solution with Microsoft Access. In this example the MSFlex Grid is used to improve the Access interface and particulary deal with an issue of editing data from a crosstab query, while leaving the interface close to the customer's original Excel worksheets.


Microsoft Access Tips

Microsoft Access tips for designing databases.


Microsoft Access General

Microsoft Access general information (if we can't figure out which category we use this one).


Microsoft Access Ribbon Customization Part 1 (article date: Apr-5-2009)

This is part 1 of a 4 part series on how to customize the Access 2007 ribbon and other tips related to the quick launch toolbar and navigation pane. In this example we show the basics of doing your first ribbon, how to get started and other references to learn more. In parts 2 thru 4 of this series we add functionality to the ribbon and database.

Microsoft Access Ribbon Customization Part 2 (article date: Apr-5-2009)

This is part 2 of a 4 part series on how to customize the Access 2007 ribbon and other tips related to the quick launch toolbar and navigation pane. In this example we add on to Part 1 by adding a form to run reports and show how we can use a custom ribbon for print preview.


Microsoft Access Links

Microsoft Access related links to other websites.


Microsoft Access News

Microsoft Access news feeds.

  
2017 RPT Software    Contact Us    Privacy Policy    Terms of Use    Legal    Site Map