Applecore Pages on Microsoft Access

Index of general pages

Close event for Access
References
Using Excel Functions from within Access
The last day of the month
Formatting Cardinal Dates
Getting file names in a directory
Remove spaces from a string
What is the next/previous Monday?
Getting the path to the current database
Number of days in the month
Copying data to and from the clipboard
Replacing characters within a string
Changing the caption for a database
MDE Files
Error Handling in Access
Creating Static HTML files from an Access database
Programmatically Hiding and Showing the Database Window
LDB files
ADO vs. DAO (or A97 vs A2K)
Collections of Objects

Top

Deleting objects in another database
Controlling Outlook 97 from Access 97
Reading in the cdplayer.ini file
Good practices when working with Access
Programmatically using a Database Object's Description
Using PKZip or WinZip from within Access
Converting numbers between the various bases (Decimal, Hexadecimal, Octal)
Is a Database already open?
File I/O Using VBA
Automating Excel Using Access
Automating Word using Access
Using SQL Strings from within VBA
Counting records in a Recordset object
Getting the specified date for the day of the week containing a given date
Problems installing using ODE and wininet.dll/urlmon.dll
Counting The Number Of Files In A Directory
Handling Null in Access

Top

Handling different screen resolutions
Finding the size of a folder
Transferring objects between two external Access databases
Deploying your application on systems that do not have Access installed
Error: 6 - Overflow
Import Errors when Importing from Excel
Controlling external files from within Access
Changing the extensions of all files of a certain type in a folder
Splitting a string cleanly at the end of words
Changing a File from Read-Only to Normal
Keeping track of who is logged into a Database
Getting the Name of a File from the Name and Path
Declaring Variables
Checking if a Recordset has any records
Using the AutoKeys Macro Group as a Developer
Generating a random Password
Counting the number of lines of code in a database
Getting the names of image files from a web page
Getting the target that is executed by a shortcut
Why Access changes words as you type them
Counting the frequency of words in a text file

Top

 


HOME | NEW | TABLES | QUERIES | FORMS | REPORTS | GENERAL | API | DOWNLOADS | TUTORIAL | RESOURCES
E-MAIL
Copyright & Disclaimer

 

Last modified at 06/06/2006 14:57:20