These examples are not detailed application examples, but rather are 'code snippets' that are designed to show various programming techniques with ASP-db™.
( 1a) |
A Simple Example using the Northwind Database. |
( 1b) |
Northwind Database showing a variety of fonts, colors, images, custom status bar, etc. |
( 1c) |
Northwind Database allowing you to CHOOSE which fields you want to see. |
( 1d) |
Northwind Database showing you a Custom Status Bar on a Form. |
( 1e) |
Northwind Database using dressed-up text navigation buttons. |
( 1f) |
Northwind Database showing the Status Bar at the top. |
( 1g) |
Northwind Database showing a Memo Field in Grid and Form (also drop the Time from a Date/Time field) |
( 1h) |
Northwind Database showing a Memo Field below a Grid. |
( 1i) |
See 3 Memo Fields on a Form. |
( 2 ) |
ASP-test.mdb Database using Tiny Text which shows how small you can get. |
|
You will also see a user-defined Filter Title. |
( 3a) |
Example of dbMode="Both" where you click on the GRID to drill down into a FORM. |
( 3b) |
Example of dbMode="Both" where the Form is a User-defined display. |
( 3c) |
Example of dbMode="Both" and having all fields be "drill-down" fields, using MagicCell's IndexAnchor. |
( 3d) |
Example of dbMode="Both" and suppressing the Nav buttons on the form. |
( 4a) |
Example of Various Number Formatting (also shows StatusBar Color). |
( 4b) |
Example of Various Date Formats. |
( 4c) |
Example of More Date Formats. |
( 4d) |
Example of Various Time Formats. |
( 4e) |
Example of Various Time Formats (using SQL). |
( 4f) |
Example of Specifying the Date Format in the SQL statement. |
( 5a) |
Example of Initial Query Form then show a GRID |
( 5b) |
Example of Initial Query Form then show a FORM (also shows the O'Neil technique) |
( 5c) |
Example of Initial Query Form then pass parameter on URL line |
( 5d) |
Example of Initial Query Form to search MULTIPLE Fields |
( 5e) |
Example of Initial Query Form to search a RANGE |
( 5f) |
Example of another O'Neil Technique |
( 5g) |
Example of choosing Multiple names |
( 5h) |
Example of choice containing a single quote character |
( 5i) |
Example of giving 2 choices |
( 6 ) |
Example of Passing Record Contents as Parameters on the URL line, also shows 2 hyperlinks. |
( 7 ) |
Example of Excel Spreadsheet and a Transparent Table |
( 8a) |
Example of using an Access Query (instead of a Table) |
( 8b) |
Example of using an Access Query with parameters |
( 9a) |
Example of Initial Filter Form |
( 9b) |
Example of Initial Filter Form / Custom Form. Also suppress the Toggle Drop Button. |
( 9c) |
Example of "Filter On Entry" |
(10a) |
Example of dbRecordSet |
(10b) |
Example of dbRecordSet (swap 2 columns) |
(10c) |
Example of dbRecordSet (Sorted) |
(11a) |
Example of Vehicles Table with Sorting a Computed Column. |
(11b) |
Example of Vehicles Table using a Select Box with combined fields. |
(11c) |
Example of Vehicles Table using a Start-Up Filter with DropDown Lists. |
(11d) |
Example of Vehicles Table Charting a Calculated Column using "AS". |
(12 ) |
Example of Table JOIN |
(13a) |
Use of Background (WallPaper), Customizable Fonts, Filter Screen Title, and Error Message. |
(13b) |
See the title colors on the filter screen. Also show use of Request("ASPdbClick_unit"). |
(13c) |
See how to customize the Sort Highlight Color -Both Title and Column. |
(14a) |
Download TEST (csvhref.htm) |
(14b) |
Example of Field Names for Downloads |
(15 ) |
Example of Table WildCard |
(16a) |
Example of MODE=DUAL-HORIZ, also Custom Filter Title. |
(16b) |
Example of switching from Grid to Form using 2 different asp pages. |
(17 ) |
Example of Custom Navigation Buttons. |
(18a) |
Example of combined fields. |
(18b) |
Example of combined fields with filter Drop-down list. |
(19 ) |
Example of Email hyperlinks (also uses dbNameMap to put a comma in a column title). |
(20a) |
Example of "GridForm". |
(20b) |
Example of "GridForm" with NO Column titles. |
(21a) |
Example of EasyFilterText=False |
(21b) |
Example of Filtering when the AS clause is used. |
(21c) |
Example of Filtering on the Same Field TWICE. |
(21d) |
Example of Filter DropList using data from a table in another database. |
(21e) |
Example of Filtering when the AS clause has a space in it. |
(21f) |
Example of Filtering with truncated names on the drop list. |
(21g) |
Example of Filtering fields with same name from two tables (ambiguous). |
(22 ) |
Example of using the [Form+] to spread a Form across multiple columns |
|
When things go wrong. See what happens when ... |
(23 ) |
... you have an EMPTY TABLE |
(24 ) |
... the MDB file is TRASHED |
(25a) |
... the MDB file is MISSING |
(25b) |
... the TABLE you requested is MISSING (or misspelled) |
(25c) |
... the DSN you requested is MISSING (or misspelled) |
(26a) |
... the ODBC DRIVER you requested isn't installed |
(26b) |
.... the MDB file is READ-ONLY and you try to make a change |
(26c) |
.... you have a Reserved Word in your Field Name an try to Update. |
(27 ) |
Example of Drill-Down Details. |
(28 ) |
Example of Memo Field with Custom Paragraph Markers and GridIndex numbers without Hyperlinks |
(29 ) |
How to put the cell contents of the highlighted record into local variables (export them) and define the column widths of the Grid and Form. |
(30 ) |
Example of Memo Field Export |
(31 ) |
Example of Toggling Grid/Form with Background (wallpaper) |
(32 ) |
Example of Column SUM |
(33a) |
Example of Custom "Go There" button (w/MouseOver) & Defining Column Widths on the Form |
(33b) |
Example of Hyperlinking using a New Target Window. |
(34b) |
Example of Cars Database with Restricted Filtering |
(35 ) |
Example of SelectDistinct |
(36 ) |
Example of a Filter Validation Routine. |
(37 ) |
Example of a Scrolling database. |
(38 ) |
Example of a Search Filter in Left-hand Frame / Results in Right-hand Frame. |
(39 ) |
Example of a JOIN having 2 Identical Fields. |
(40 ) |
Example of unusual field names. |
(41 ) |
Example of sorting columns that were renamed using the 'AS' clause. |
(42 ) |
Examples of all the Pre-defined Color Schemes. |
(44a) |
Example of a Customized Column Title when Column Spanning is used. |
(44b) |
Example of a Spanning Two Columns, Sort Column Color, MagicCell on Memo. |
(45 ) |
Example of a computing ELAPSED DAYS from Date fields. |
(46 ) |
Example of a Left Justified Grid. |
(47 ) |
Example of asking for an initial MODE. |
(48 ) |
Example of asking for a LANGUAGE. |
(49 ) |
Example of Students' Classes (Uses Languages, Codes, and Joins). |
(50a) |
Example of the "Car Demo" from our Home Page. |
(50b) |
Example of the "Car Demo" with user-defined bar chart scaling. |
(51 ) |
Example of using var's to save, display, and pass grid data. |
(53 ) |
Example, Startup Filter, Drop-Lists. |
(54 ) |
Example of Filter using a Date Range. |
(55 ) |
Example of using a BLACK Background. Also shows use of HeaderFontTag & CellFontTag. |
(56a) |
Example of displaying a CSV TEXT File using a File DSN defined on-the-fly. |
(56b) |
Example of displaying a CSV TEXT File using a pre-defined System DSN. |
(56c) |
Example of displaying a CSV TEXT File when there are Blanks inside Field Names. |
(57a ) |
Example of Remembering a User's Filter. |
(57b ) |
Example of Sending a Filter to a Second Page. |
(58 ) |
Example of using dbSilentCmdText to update records. |
(59 ) |
Example of showing a Bool on a Custom Form. |
(60 ) |
Example of finding records by successive Drill-downs. |
(61a) |
Example of a Custom Index Column (Text) for Details. |
(61b) |
Example of a Custom Index GraphicButton for Details. |
(62 ) |
Example of defining CSV Date Formats. |
(63a) |
Example of using JavaScript inside a dbMagicCell. |
(63b) |
Example of using JavaScript inside a dbMagicCell to format TWO numbers in ONE cell. |
(63c) |
Example of using VBScript inside a dbMagicCell. |
(64 ) |
Example of displaying a photo on a custom form. |
(65a) |
Example of using dbMagicCell to format a Memo field, and dbNameMap delimiters. |
(65b) |
Example of using dbMagicCell to do more formatting tricks. |
(66 ) |
Example of Searching for NULL and NOT NULL. |
(67 ) |
Example of Forcing Grid mode after a Filter. |
(68 ) |
Example of using OLEDB. |
(69 ) |
Fill out a Survey Form using RADIO BUTTONS. |
(70 ) |
Hiding Empty Fields in the Form in Dual-Horiz Mode. |
(71 ) |
How to tell which field was sorted. |
(72 ) |
How to Join 3 fields to 2 tables. |
(73 ) |
Example of Access and SQL Server on the same page. |
(74 ) |
Example of an Order By without an initial column hilite. |
(75 ) |
Example of Orders / Order Details. |
(76 ) |
Example of Replacing text using MagicCell also shows mouse-over. |
(77 ) |
Example of using your own graphical Navigation buttons. |
(78 ) |
Example of using Javascript to pop-up notes in another window. |
(79 ) |
Example of Setting Filter Focus using BodyTag (and SendHead). |
(101 ) |
Example of Database Adds/Deletes/Edits (Also shows default entries) |
(102 ) |
Example of Database Editing in Grid only mode (also shows: Custom Update Button, Custom Edit Titles). |
(103a) |
Example of Database Adds/Deletes/Edits with Memo Fields and "Field Notes". |
(103b) |
Example of Database Adds/Deletes/Edits with Memo Field as Read-Only. |
(104 ) |
Example of Editing Privileges based on UserID/Password. |
(105 ) |
Example of Data Entry Validation Checking. |
(106 ) |
Example of Editing Buttons in Form mode only. |
(107 ) |
Example of Editing a Variety of Field Types. Also shows a scrolling Memo field |
(108 ) |
Example of Editing with a Field Name containing a space. |
(109 ) |
Example of Using a List from Another Table for data entry. |
(110a) |
Example of Starting in EDIT Mode for ADDing records ONLY. |
(110b) |
Example of Starting in EDIT Mode for EDITing a chosen record. |
(111 ) |
Example of Updating MULTIPLE records. |
(112 ) |
Example of Custom text on the Editing Buttons (also uses an 'AS' clause). |
(113 ) |
Example of Editing when using the Table Wildcard. |
(114 ) |
Example of using a DropList when Editing (also hide update criteria). |
(115 ) |
Example of specifying larger edit boxes. |
(116a) |
Example of specifying 2 or 4 digit years in Access. |
(116b) |
Example of specifying a Future Date as a default entry. |
(116c) |
Example of specifying the Date Format on the Edit screen. |
(117 ) |
Example of hiding the various edit buttons. |
(118a) |
Example of editing without an AutoNumber Field. |
(118b) |
Example of Hiding the Update Criteria. |
(119 ) |
Example of an Add Confirmation Screen (and how to Set Focus). |
(120 ) |
Example of updating the Last Record and having it fall out of the WHERE. |
(121 ) |
Example of protecting against unwanted HTML code inside a memo field. (also: 1,5 to 1.5) |
(122 ) |
Example of a way to make a predefined field RO during Add. |
(123 ) |
Example of a way to timestamp records (also non-sticky add). |
(124 ) |
Example of adding/updating with droplists (also non-sticky add and multiple deletes). |
(125 ) |
Example of Adding a Hidden Field (also non-sticky add and multiple deletes). |
(126 ) |
Example of Editing when JOIN has duplicate field names. |
|
|
(127 ) |
Example of "FULL SCREEN" Editing. |
1. |
Simple ASP-db Gold Grid (No Templates) |
2. |
Simple Templates (Templates: Form, Filter) |
3. |
Northwind Example (Templates: EditAdd, Update, and Graphical "Submit" Buttons) |
4. |
True / False Field using Radio Buttons (and $ Currency) (Templates: EditAdd, Update, Delete) |
5. |
True / False Field using a Check Box (Templates: Form, Update) |
6a. |
FilterDropList (Templates: Filter) |
6b. |
FilterDropList with a Blank in the DropList (Templates: Filter) |
6c. |
Filter using Radio buttons on a Bool field (Templates: Filter) |
6d. |
Filter using Toggling Drop-Lists (Templates: Filter) |
7a. |
Look-up list during Add (Templates: Add) |
7b. |
TWO Look-up lists during Add (Templates: Add) |
8. |
Look-up (2 fields) during Form (Templates: Form) |
9a. |
Specifying a default value during Add (Templates: Add) |
9b. |
Ability to UPDATE or CLONE (Templates: Update) |
10. |
Non-Sticky Adds: Text (with and w/o defaults) & DropLists (with and w/o defaults) (Templates: Add) |
11a. |
Using DropLists for Add's and Updates, also Memo Field (Templates: Add, Update, non-sticky) |
11b. |
Using a Drop list for an update (without using dbMagiclayout) |
12. |
Adding a Hidden field (also shows a "Non-Sticky" Add) (Templates: Add) |
13. |
Using an "IF CHECK" inside a Template (Templates: Update) |
14. |
A very simple "LEVEL 2" Example (Templates: Send) |
15. |
A very simple "2 Table Edit" Example |