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.
Templates or products RPT Software offers. Most of these products we charge a small fee to obtain the product or source code.
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.
|
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.
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.
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.
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.
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.
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 and table design.
Microsoft Access queries and query design.
Microsoft Access forms and techniques used on forms.
|
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.
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.
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 and reporting techniques.
Microsoft Access macros and their uses.
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 thrid-party controls (the ones we like). These examples tend to be bigger and more complex.
|
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 for designing databases.
Microsoft Access general information (if we can't figure out which category we use this one).
|
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.
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 related links to other websites.
Microsoft Access news feeds.
|
Help - Overview
