TechOnTheNet.com is dedicated to providing helpful advice, how-to's and FAQs. We focus on technologies such as Microsoft Access, Microsoft Excel, Microsoft Word, SQL, and Oracle/PLSQL.
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.
What's New
The latest Microsoft Word pages added to the site:
- Indent text in Word 2011 for Mac
- Make text appear like it was marked with a highlighter pen in Word 2011 for Mac
- Change font color in Word 2011 for Mac
- Center text in Word 2011 for Mac
- Double space text in Word 2011 for Mac
The latest Oracle/PLSQL pages added to the site:
The latest Microsoft Access pages added to the site:
- Refresh data in a form in Access 2007
- Redraw a form in Access 2007
- Popup calendar in a form/subform in Access 2007
- Load a form into memory, but do not display it in Access 2007
- Define a custom format for a Date/Time field on a form in Access 2007
- Check if a form is loaded in Access 2007
- Sort a form's records based on the value of a calculated field in Access 2007
- Display on a form, the number of related records from another table in Access 2007
- Set form colors to be consistent on different computers in Access 2007
- Set up a text box to flash red/black when a date is past due in Access 2007
- Filter records based on a combo box selection in Access 2007
- Enable Close button on a Form in Access 2007
- Duplicate a record in Access 2007
- Disable the Esc key in a form in Access 2007
- Disable Close button on a Form in Access 2007
- Open a Form from another Form (disabling the parent form until the child form is closed) in Access 2007
- Replace system error message with a custom message in Access 2007
- Update a text box to a value when a new record is created in Access 2007
- Use a control in an SQL statement in Access 2007
- Remove minimize, maximize, and close buttons from a form in Access 2007
- Conditionally change the background color of a text box on a Continuous Form in Access 2007
- Conditional formatting in Access 2007
- Change AutoFormat (background style) for a form in Access 2007
- Change the background color of a text box when the text box value changes in Access 2007
- Change the background color of a text box based on whether a value has been entered in Access 2007
- Center a form in the application screen in Access 2007
- Set the background color of a button in Access 2007
- Picture as background of a form in Access 2007
- Add an independent label on a form in Access 2007
The latest Microsoft Excel pages added to the site:
- Calculate a weighted value based on number of months in Excel 2007
- Set up cell to only allow 10 characters in Excel 2011 for Mac | Excel 2010
- Create hyperlinks to link cells in column E to their matching value in column C in Excel 2007
- Automatically highlight highest and lowest values in a range of cells in Excel 2011 for Mac
- Automatically highlight expired dates and dates that are 30 days from expiration in Excel 2010
- Automatically highlight highest and lowest values in a range of cells in Excel 2010
- Change the font color based on the value in the cell in Excel 2010
- Change the font color based on the value in the cell in Excel 2011 for Mac
- Remove subtotals on pivot table rows in Excel 2011 for Mac
- Remove subtotals on pivot table columns in Excel 2011 for Mac