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.
Forums
We're proud to offer a new feature to our site called techonthenet.com Forums. We encourage you to visit the forums to post questions and answers relating to Oracle, Microsoft Access, and Microsoft Excel. Or just browse the forums to find answers to many of the questions that you may have.
You can access the techonthenet.com Forums by clicking on the Forums link in the Navigation bar at the top of any one of our pages. Register now and be one of the first to post!
Last Added
The last Oracle/PLSQL pages added to the site:
Practice Exercises for LIKE Condition
Practice Exercises for UPDATE Statement
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:
Create a form where you can perform both text and numeric searches in Access 2003/XP/2000/97
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
The last Microsoft Excel pages added to the site:
Change data source for a pivot table in Excel 2003/XP/2000/97
Use two combo boxes to retrieve values from a table in Excel 2003/XP/2000/97
Enter a value in an InputBox and then search for this value in a column and copy row to new sheet for all matching values in Excel 2003/XP/2000/97
Count the number of cells with a particular font color in Excel 2003/XP/2000/97
Use an array formula to calculate monthly attendance in Excel 2003/XP/2000/97
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
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