|
|
|||
This site contains examples of Access queries and also various visual basic functions and procedures which can be incorporated within a database. Some of the procedures are linked to particular event properties on forms and reports. This is not intended to be a complete Access tutorial but will hopefully stimulate some interesting ideas and possibilities.
|
Access queriesExamples of many queries for selecting, grouping, joining, modifying and totaling data. |
|
|
ReportsA reports manager form to allow users to select a report and choose whether to preview, print or export it.Creating a report template which can save time and give your new reports a consistent appearance.Some visual basic code linked to report events |
|
|
Bits and PiecesUsing an Open dialog box in VBA to select and open other filesDefining some program variables such as a department name or default file locationsVarious bits and piecesSetting status bar messages to be displayed while VBA programs are runningIdentifying or removing postcodes from addresses |
This site also contains detailed help with using Excel spreadsheet functions, charts and exporting data |
|
Exporting data into applicationsCreating HTML web pages from access queriesGenerating XML files to export dataDistributing reports via email |
You should not place any reliance upon these programs and always thoroughly test all of the code in your databases.
| file:accessintro.htm | Page last updated Sep 06 | © MeadInKent.co.uk 2006 |
