Access Topics: Question & Answer
We've added this category to include some of our general questions from viewers.
Database Window/Properties:
Hide a database window in Access 2003/XP/2000/97
Display/Unhide the database window in Access 2003/XP/2000/97
Open the database exclusively in Access 2003/XP/2000/97
Hide tables in Access 2003/XP/2000/97
Hide tables as system tables in Access 2003/XP/2000/97
View system tables in database window in Access 2003/XP/2000/97
View hidden tables in database window in 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 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 2003/XP/2000/97
Set the background color of a button in Access 2003/XP/2000/97
Query to retrieve max date in 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 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