MS Access: Question and Answer
We've added this category to include some of our general Access questions from viewers.
Errors
- Database variable "not defined" error in Access 2003
- How to fix a "Compile error.in query expression" Error in Access 2003
- Run-time error '424' (Object Required) in Access 2003
Multi Media
- Play a wav file (sound file) through the API in Access 2003
- Play a wav file (sound file) through the API when a form opens, based on a text box value in Access 2003
- Play a wav file (sound file) through the API when a button is clicked, based on a text box value in Access 2003
- Play a wav file (sound file) without using the API in Access 2003
Oracle
- Create a pass-through query to retrieve the nextval from an Oracle sequence in Access 2003
- Create a pass-through query to retrieve the nextval from an Oracle sequence with VBA code in Access 2003
- Call an Oracle stored procedure using VBA code in Access 2003
- Link to an Oracle table using VBA code in Access 2003
- Connect to Oracle using VBA code in Access 2003
Miscellaneous
- How to activate the built-in VBA functions in Access 2013 | 2010 | 2007 | 2003
- View only records with uppercase letters for a certain field in Access 2003
- Calculate and format an elapsed time value in Access 2003
- Parse a string into two values based on the occurrence of an underscore in Access 2003
- Convert a date to a numeric value in Access 2003
- Format a string to display as a currency value in Access 2003
- Export two Access tables into individual sheets in an Excel spreadsheet in Access 2003
- Create new database file and transfer tables using VBA in Access 2003
- Examples of converting Excel formulas to Access 2003
Advertisements