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