Tech on the Net is dedicated to providing helpful advice, how-to's and FAQs. We focus on technologies such as Microsoft Access, Microsoft Excel, Microsoft Word, SQL, Oracle/PLSQL, UNIX, and Linux.
The information presented here is suitable for all programmers from beginner to expert. We hope you find this information useful and return to our site, as we expand our information base.
Last Added
The last Oracle/PLSQL pages added to the site:
Practice Exercises for COUNT Function
Practice Exercises for ALTER TABLE Statement
Practice Exercises for CREATE TABLE Statement
The last Microsoft Access pages added to the site:
Play a wav file (sound file) without using the API in Access 2003/XP/2000/97
Prevent a query from timing out in Access 2003
Query to retrieve records that contains keywords stored in a table in Access 2003/XP/2000/97
Create a sequential number you control that is assigned every time a form is opened in Access 2003/XP/2000/97
Display tables and related objects in the Navigation Pane in Access 2007
Display all objects (tables, queries, forms, reports, modules) in the Navigation Pane in Access 2007
Display modules in the Navigation Pane in Access 2007
Display reports in the Navigation Pane in Access 2007
Display forms in the Navigation Pane in Access 2007
TUTORIAL: Form Basics (Understanding and creating forms) in Access 2007
The last Microsoft Excel pages added to the site:
Check to see if files exist based on values from 2 columns in Excel 2003/XP/2000/97
Link to a cell in a Lotus file in Excel 2003/XP/2000/97
Use an array formula to average values when 2 criteria are met in Excel 2003/XP/2000/97
Calculate the incremental difference in a running total column even when blank values are found in the series in Excel 2003/XP/2000/97
Two-Dimensional Lookup (Example #4)
Sort data in alphabetical order based on 2 columns in Excel 2007
Sort data in alphabetical order based on 1 column in Excel 2007
Display the fields in the Values Section in multiple columns in a pivot table in Excel 2007
Display the fields in the Values Section in a single column in a pivot table in Excel 2007
Remove subtotals on pivot table columns in Excel 2007
The last Microsoft Word pages added to the site:
Open a template in Word 2007
Hide the horizontal and vertical ruler in Word 2007
Show the horizontal and vertical ruler in Word 2007
Create a template from an existing template in Word 2007
Create a template from an existing document in Word 2007
Create a template from a blank document in Word 2007
Create page numbers at the bottom of the page in Word 2007
Create page numbers at the top of the page in Word 2007
Make footers different for odd and even pages in Word 2007
Create a different footer for the first page in Word 2007