The following are either Code Snippets that I have developed or links to other websites with commonly needed code or other valuable information. This is just the beginning. Please stop back frequently for additional information. At this point these are not in any particular order. After I finish it up completely I will arrange these things in a little different order.
Record # of Records - How to place a control on a form that displays which Record of Records the form is currently displaying.
Next Day Function - A Function that returns the next day (entered by the user) after a given date. Thus, if the user wants to know the date of the Monday that follows Dec. 23,2005, this function will return Dec. 26, 2005.Mixed Case ProperCase - We all like to be able to set the display of text string for names in Proper Case, but end up with frustration when dealing with oddities like MacDonald or De La Rosa. This code on the Access Web will solve some of those problems.
Import Report - This procedure utilizes the TransferDatabase method to import a report from another database. The users will input the database name and the report name into text boxes on a form.
Corruption Problems – Tony Toews (Access MVP) has put together an excellent resource of information about database corruption.
User Level Security – A synopsis of useful information regarding MS Access User Level Security
Jeff Conrad’s Handy Reference List – A list of links to useful MS Access websites.