MS Access tips

• How to use MS Access for end users
• Finding the MS Access 2003 menu commands on the MS Access 2007 ribbon

Below are a collection of postings to Internet newsgroups and discussion lists.

• Simulating a control array on a form in MS Access
• Change code page from Access97
• Accessing help from a button...
• Reattach tables
• Hide, Show, Load... (Form CallBack)
• Breaking from a Loop using ESC key
• Clear Access 97 password
• How to count characters in a field
• Copy CommandBars using VBA
• Controlling exiting of Access
• Custom Addin calling another custom Addin
• How I Can Get How Many Days In A Month...?
• Dec(...) function in MS Access
• Different Setups For Access 97 (Creating Custom profiles)
• Dynamic Relationship Building
• How many external tables can Access handle?
• FixedFixUp (SQL humiliation)
• Getting the 8.3 file Name associated With a Long File Name
• Creating a Graph/Chart on a Report in VBA
• Shortcuts to database objects and API32
• Get Computer Name
• Getting the field caption property from code in Access97
• Call Let/Get Prop using string variable for name
• Import Excel Sheet to Back-End Database
• Import Excel Sheet to Back-End Database (Use Named Range)
• Couldn't find installable ISAM (Excel)
• Set Focus to last Character in Control
• Linked Tables Report
• Make mde file from MS Access 97
• Make MDE (Undocumented feature)
• Max AutoNumber Value
• Read a text file
• Sorting on a memo field
• Reading Excel Text Attributes from Access 97
• Check Refereneces (Lost function?)
• Fault referencing libs in MDE files (Custom profiles)
• How to exclude a report from printing if it has no information in it ?
• A sample code to workaround Access 97 TransferText implicit features
• Patch byte in external file
• Patch several bytes in external file
• Undocumented(?) MS Access 97's version control properties...
• GUID of MDE files
• Patching GUID of MDE files
• Comparing files using VBA/MS Access 97
• Building WHERE ... IN (list) from multiselect listbox
• Mystery Code - Why does this Function work ?
• Writing multilingual applications
• Non-English text display problem with functions
• How to prevent db bloating
• Get Active Users List
• Access 97: Help relinking Excel Tables
• Current thinking on using SEEK...speed
• Suppress #Error in calculated field
• Shutdown command
• Refering to the Control which "called" a procedure/sub
• Store expressions in a table - Run from Module or Query
• Alert for locked record
• Timing
• TransferText - Multiple txt files simultaneously
• Update all columns without column names
• Create (by default) userdefined documents collection from VBA
• Variable Number of Fields in Reports
• Calculating Working Days
• Adding "Window" pulldown menu through code
• Importing tables from MS Word
• Self-extracting VBA code and WithEvents tricks
• Excel Object Problems
• Import/export specification collection
• Syntax Error in Where clause
• Problem when using WithEvents keyword in Access 97
• VBA Challenge
• Representing a tree structure in an RDBMS system
• Writing Code to Manipulate Code
• Get full date given a short julian date
• Use Inno installer to distribute you windows apps,  it's one of the best and it's free.
• How to improve subform performance
• Troubleshooting Error Values
• Access not closing