MS Access Topics: Question & Answer
We've added this category to include some of our general questions from viewers.
Navigation Pane (Access 2010 and 2007) or Database Window (Access 2003 or earlier):
- Hide the Navigation Pane or Database Window in Access 2007 | Access 2003/XP/2000/97
- Display/Unhide the Navigation Pane or Database Window in Access 2007 | Access 2003/XP/2000/97
- Open the database exclusively in Access 2007 | Access 2003/XP/2000/97
- Hide tables as hidden objects in Access 2007 | Access 2003/XP/2000/97
- Hide tables as system tables in Access 2007 | Access 2003/XP/2000/97
- View system tables in database window in Access 2007 | Access 2003/XP/2000/97
- View hidden tables in database window in Access 2007 | Access 2003/XP/2000/97
Graph:
- Create a graph (ie: chart report) in Access 2003/XP/2000/97
- Fill in missing data on a graph in Access 2003/XP/2000/97
Errors:
- Database variable "not defined" error in Access 2003/XP/2000/97
- How to fix a "Compile error.in query expression" Error in Access 2003/XP/2000/97
- Run-time error '424' (Object Required) in Access 2003/XP/2000/97
- Trim function will not work in a report in Access 2003/XP/2000/97
Conditional Formatting in a report:
- Change the formatting of a field in a report based on its value in Access 2003/XP/2000/97
- Change the formatting of a field in a report when the field contains a NULL value in Access 2003/XP/2000/97
- Conditionally format a field in a report in Access 2003/XP/2000/97
Security:
- Set a database-level password on a database in Access 2003/XP/2000/97
- Remove a database-level password from a database in Access 2003/XP/2000/97
- Launch the Workgroup Administrator in Access 2003/XP | Access 2000/97
- Associate an mdw security file with a database in Access 2003/XP/2000/97
Multi Media:
- Play a wav file (sound file) through the API in Access 2003/XP/2000/97
- Play a wav file (sound file) through the API when a form opens, based on a text box value in Access 2003/XP/2000/97
- Play a wav file (sound file) through the API when a button is clicked, based on a text box value in Access 2003/XP/2000/97
- Play a wav file (sound file) without using the API in Access 2003/XP/2000/97
Oracle:
- Create a pass-through query to retrieve the nextval from an Oracle sequence in Access 2003/XP/2000/97
- Create a pass-through query to retrieve the nextval from an Oracle sequence with VBA code in Access 2003/XP/2000/97
- Call an Oracle stored procedure using VBA code in Access 2003/XP/2000/97
- Link to an Oracle table using VBA code in Access 2003/XP/2000/97
- Connect to Oracle using VBA code in Access 2003/XP/2000/97
Miscellaneous:
- View only records with uppercase letters for a certain field in Access 2003/XP/2000/97
- Calculate and format an elapsed time value in Access 2003/XP/2000/97
- Convert currency into words in Access 2003/XP/2000/97
- Generate a random number between 2 user-specified values in Access 2003/XP/2000/97
- Report Example (Employee hours worked per day) in Access 2003/XP/2000/97
- Display parameter values in a report based on a parameter query in Access 2003/XP/2000/97
- Capitalize each word in a string (similar to InitCap in Oracle) in Access 2003/XP/2000/97
- Renumber invoices with VBA code in Access 2003/XP/2000/97
- Change AutoFormat (background style) for a form in Access 2007 | Access 2003/XP/2000/97
- Prevent the mouse wheel from scrolling through records in a form in Access 2003/XP/2000/97
- Set form colors to be consistent on different computers in Access 2007
| Access 2003/XP/2000/97 - Set the background color of a button in Access 2007 | Access 2003/XP/2000/97
- Query to retrieve max date in Access 2007 | Access 2003/XP/2000/97
- Retrieve the user name from Windows while in a database in Access 2003/XP/2000/97
- Populate underlying table when new entries are keyed into combo box in Access 2007 | Access 2003/XP/2000/97
- Populate underlying table using a popup form when new entries are keyed into combo box in Access 2007 | Access 2003/XP/2000/97
- Access a value from a table using VBA code in Access 2003/XP/2000/97
- Parse a string into two values based on the occurrence of an underscore in Access 2003/XP/2000/97
- Convert a date to a numeric value in Access 2003/XP/2000/97
- Format a string to display as a currency value in Access 2003/XP/2000/97
- Export two Access tables into individual sheets in an Excel spreadsheet in Access 2003/XP/2000/97
- Create new database file and transfer tables using VBA in Access 2003/XP/2000/97
- Examples of converting Excel formulas to Access 2003/XP/2000/97