Home
What's New
En Français
Table Of Contents
Credits
Netiquette
Bugs
Tables
Queries
Forms
Reports
Modules
APIs
Strings
Date/Time
General
Resources
Search
mvps.org
Feedback
  
Terms Of Use

 

 

 

URL View

 A listing of all articles, grouped by sections, that are currently available on the website.  Each page is listed only once. To find out about recent updates, please visit the What's New section.
  • Bugs
  • Date/ Time
  • Forms
  • General
  • Modules
  • Queries
  • Reports
  • Resources
  • Strings
  • Tables
  • Updates
  • Win32 API
    •
    Bugs

    Go To Top

     
    1. Common Functions like CurrentDB, str$, Mid$ fail to work
    2. Automation Error error messages, unable to change/save/delete a database object
    3. Cannot Start Data Access Object error message.
    4. Numlock key keeps turning off.
    5. Access minimizes to Windows 95/NT toolbar instead of closing
    6. Database name isn't an index this table: error message
    7. Run-Time Error 429:  ActiveX component can't create object.
    8. Solving Access 97 IPFs with /Decompile
    9. Error registering Comcat.dll in registry during Install
    10. Error 3014 - Can't Open Any More Tables
    11. Mailmerge starts new instance of Access
    12. Bookmark Bug
    13. There is no license: Error message
    14. Office SR-1 does not work in Win 98
    15. Report returns more records than query
    16. Access bugs fixed by Office SR-2
    17. Couldn't Find Installable ISAM
    18. Hyperlink with "mailto:" tag opens two windows
    19. Error 53 when calling functions from custom DLL
    20. Compile Error in Hidden Module
    21. Maximum length strings crash Access Security Wizard
    22. Solving VBS Error '800a01ad' on CreateObject in ASP/IIS
    23. Code changes are lost during a recompile of code
    24. TransferDatabase Causes Page Fault If Object Exists.
    25. Undefined Function in Expression (Error 3985)
    26. Form_Resize fires after Form_Close on maximized forms
    27. Database Won't Open
    28. Access 2000: Compile Error in converteddatabase
    29. WebBrowser control: Run-Time error '438'
    30. No read Permissions on "MsysModules2"
    31. Access 2000: Type Mismatch or User Defined Type Not Defined 
    32. Access 2000: Can't Open/Convert Access 97MDEs 
    33. Access 2000: Getting additional information 
    34. Access 2000: Setup Flags 
    35. Access 2000: Formatting MsgBox's with '@' 
    36. To Hide Or Not To Hide
    37. Access 97 fails to start after Access 2000 Uninstall
    38. Access 2000- Corrupt VBA Project message during conversion
    39. Access 2000- Using Group by along with NZ results in unreadable characters
    40. How to Install Access 97 and Access 2000 on the Same Computer
    41. Access 2000 ADPs- Memo field corruption
    42. Access 2000- Database password appears to be set
    43. Access 2000- DeleteObject code doesn't work
    44. Image Control may cause a GPF when browsing between records
    45. Access 2000- Differences between Jet Compact and Access Compact
    46. Jet 4.0 SP3- Text IISAM does not work without txt file extension
    47. Access 2000- Changes made to code in referenced databases are not saved

       
    Date/Time

    Go To Top
    1. Calculate Age of a person
    2. Return a date in the future from a given date
    3. Calculate differences in time
    4. Return Dates in US #mm/dd/yyyy# format
    5. Calculate # of Working Days
    6. Various Date manipulation functions
    7. How to handle midnight in calculations
    8. Time, adding and subtracting time and timesheets
    9. Determining Average Time
    10. How many Sundays between two dates
    11. Doing WorkDay Math in VBA
       
    Forms

    Go To Top
    1. Use Variables in SQL behind forms
    2. Find out if a form is open
    3. Cycle through controls with common names
    4. Enumerate all controls on a form
    5. Have the form move to the record selected in List/Combo box
    6. Return Strings from Option Groups
    7. Use Multi-Select List boxes as query parameters
    8. Grab what the user has typed in a control (uncommitted value)
    9. Fill Fields automatically on form based on a control's value
    10. Detect new record in a form
    11. Move cursor to the end of text in a textbox
    12. Carry current value of a control to new records
    13. Form doesn't open as Modal even though Modal property is set to true
    14. Suspend code until a popup form is closed
    15. Add item to combo box using OnNotinList event
    16. Disable PgUp/PgDown keys in a form
    17. Determine name of parent form
    18. Resolve #Name error in a form/report
    19. Use ControlTipText to display textbox value
    20. Make a label flash
    21. Delete current record
    22. #Error when the Subform has no records
    23. Cannot ApplyFilter on SubForm
    24. Colors and Continuous forms
    25. Refer to Controls on a tabbed form
    26. Duplicate "Record x of y"
    27. Ask before saving record
    28. Limit content of combo/list boxes
    29. Hide a subform if no records present
    30. Handle/Display images in forms/database
    31. Refer to Form and Subform properties and controls
    32. Create a clock on a form
    33. Determine selected records in datasheet view
    34. Open a form in an external database
    35. Set defaults for Find Dialog Box
    36. Form only allows new records to be entered
    37. OnMouseOver Effect
    38. Control Arrays in Access
    39. Tooltips don't seem to work
    40. Close all open forms and "For Each" syntax
    41. Make Numeric and Date fields respond to Plus or Minus keys
    42. Move and Resize form windows from code
    43. Adding 'All' to a listbox or combobox
    44. Displaying photos in a form
    45. Adding a Search form to a database
    46. Display a dialog box for a specified duration
    47. Changing the Background Color of the Current
    48. Record in a Continuous Form
    49. First Control in a Read Only subform retains focus
    50. Callback function for a Multi Column List box
    51. Mini Calendar
    52. Clock From Around The World
    53. Calendar Month View
    54. Shaped Forms
    55. TSI Subforminator!
       
    General

    Go To Top
    1. Convert Access databases to Executables
    2. Automatically resize forms to current screen resolution
    3. Access, Office and Year 2000
    4. Determine name of sub/function where error occurred
    5. Prevent Access from closing
    6. Reset Autonumber field in Table
    7. Get path and file name of Current database
    8. Importing Excel spreadsheets from code
    9. Send Fax/Email from Access
    10. Run Word 97 MailMerge
    11. Some Access specifications
    12. Commonly used naming conventions
    13. Why CompactCurrentDatabase doesn't work from code
    14. Learn about the new Access Virus
    15. Run Dos Batch files from Access
    16. Cannot open Access 97 database in previous versions
    17. Automation object doesn't close automatically
    18. DLookup Usage Samples
    19. Use LIKE in queries and code
    20. Inputbox and Password Masks
    21. How to create Shortcuts on Desktop
    22. Duplicate VBA code in Perl using OLE
    23. Generic Name Structures in Access
    24. Troubleshoot conversion to Access 97 problems
    25. Use Autonumbers properly
    26. Connect your database to the web
    27. Runtime command line argument doesn't work
    28. Run wizards from code
    29. Replace the Access splash screen
    30. Reading a drive's Volume Label
    31. Show/Hide database window from code
    32. Email/Export Charts from Access
    33. Jet 4.0 Replication
    34. Who's logged in?
    35. Copy CommandBars and Import/Export
    36. Specifications to a new database
    37. Displaying IP Addresses by using an Input mask
    38. What was that password again?
    39. Bits and Bitmasks
    40. Access 2000- Hiding Replace Tab in Find-Replace Dialog
    41. Securing AllowBypassKey
       
    Modules

    Go To Top
    1. Convert Currency ($500) into words (Five Hundred Dollars)
    2. Use variables to call functions
    3. Read Word Document Properties (Author, Last PrintDate etc.)
    4. Return a concatenated list of sub-record values
    5. Use SendKeys to open another database
    6. Sample Excel Automation
    7. Run Excel Macros through Automation
    8. Concatenate fields in same table
    9. Check to see if a File or Directory exists
    10. Filter a recordset
    11. Disable Shift key
    12. Domain Aggregate Functions Replacements
    13. Use Class modules to return Dir and File names
    14. Check if an object exists in the database
    15. Use FTP
    16. Conquer RunCommand Constants
    17. VB5 Switchboard Utility
    18. Import Outlook 98 messages
    19. Send Email using CDO/Outlook 98
    20. VB5 Compact Database utility (Access 97)
    21. Maintain a history of changes
    22. References Wizard
    23. Class Builder Wizard
    24. Compile And Save All Modules
    25. PrivDBEngine and Startup Properties
    26. Forms Format Wizard
    27. Bills of Materials
    28. Using WithEvents to get saved filenames
    29. Convert an Access 97 database to Access 95
    30. Access 97 Compactor Addin
    31. Code Comment Builder Wizard
    32. Class Information Wizard
    33. TSI Synchronizer
    34. Creating a reference to a Class in a Library database
    35. Transferring Records to Excel with Automation
    36. Specify UserName & Password for new Access instance
    37. Internet Data Transfer Library
    38. Determining who has Word Doc file open
    39. Getting the Decompile and Compact context menu options
    40. CodeWriter 2.0
    41. VBA Developer's Handbook - Replacement for functions in Chapter 12 
    42. Scheduler Utility
    43. Opening a new Word document based on a template through Automation
    44. Determining the number of dimensions for an array
    45. Backup Wizard
    46. Exporting an Excel worksheet as a CSV file
    47. Spelling number, in many languages (PolyGlot Number Speller)
    48. Rotate Label ActiveX Control
    49. TSI Xpression 9.0
    50. TSI Form-Report to Data Access Page Wizard
    51. File Search and Properties Object
    52. Access 2000- Using DAO code in ADPs
    53. File Change Notification Component
    54. Implementing a custom Rounding procedure
    55. LDB Viewer Form
    56. Search Wizard
    57. Reading Text Files
    58. Text Export Class
    59. Class for sending emails through GroupWise
    60. File Slice Wizard
    61. TSI Word to the Wise
    62. Automating Internet Explorer 5
       
    Queries

    Go To Top
    1. Use a parameter to return all records if Null
    2. Return database object names
    3. Open Parameter queries from code
    4. Have query return highest/lowest value in a field
    5. Use a variable in a field's criteria
    6. Have a query return every nth record in a table
    7. Find Unmatched records between two tables
    8. Find Duplicate key values
    9. Solving problems with Dates in SQL
    10. Create a query that returns Top n records
    11. Create a query that returns Random records
    12. Turn off the default Action query confirmations
    13. Too few parameters, expected n
    14. Simplify action queries in code
    15. Handling floating-point, Currency, and Decimal Datatype in SQL
    16. Finding all X having all required Y
    17. Fixed column name and crosstabs
    18. Continuous sequence, maximum length (stroke)
    19. Quartiles, Percentiles
    20. Getting a related field from a GroupBy (total) query
    21. Merging sequences
    22. Jet-MSDE- DELETE * FROM Table1; Incorrect syntax near '*'
    23. BOM, with Joe Celko Nested Sets
       
    Reports

    Go To Top
    1. Printout Multiple copies of a report
    2. Print only the current record to a report
    3. Handle reports from a modal form
    4. Show totals at bottom of report
    5. Use Multiselect listbox to limit records in report
    6. Close report automatically if no data found
    7. Handle Null values in fields
    8. Send a report via EMail
    9. Change printers from code
    10. Boxes with variable dimensions
    11. Save a report's output as a PDF file
    12. Open a report in an external database
    13. Printing First and Last Page Numbers for Report Groups
    14. Use a recordset as report's datasource
    15. Bring up Print Dialog from code
    16. Count the Number of Groups on a Report
    17. Printing Page Numbers on multi column report
    18. Displaying timelines on a report
    19. Lines/Graphics not retained in Word/RTF Export
    20. Custom Zoom in Reports
       
    Resources

    Go To Top
    1. Books/Mags
    2. Technical Papers from Microsoft
    3. Third party Technical Papers
    4. Products
    5. Other Sites
    6. Visual Basic
    7. Mirrors
    8. Patches
    9. Utilities
    10. Downloads
    11. Newsgroups
    12. General
       
    Strings

    Go To Top
    1. Parse one field's data into multiple fields
    2. Extract characters from a string containing both numbers and characters
    3. Parsing character separated string into individual components
    4. Replace a character with another within one string
    5. Capitalize first character of every word automatically
    6. Convert all text to Upper/Lower case
    7. Increment Numeric portion of a string
    8. Names with Mixed cases
       
    Tables

    Go To Top
    1. How to find out if a table exists in a database
    2. "Too many fields defined" error message
    3. Referential Integrity between databases
    4. Hide a table in Database Window
    5. Have Autonumber field start from a value different from 1"
    6. How to perform Seek on Linked Tables
    7. Retrieve linked database namepath
    8. Create Hyperlink Field from code
    9. Reconnect linked Access tables from code
    10. Reconnect linked ODBC tables from code
    11. Don't let the Synonym "bug" bite
    12. Relink tables from different datasources
    13. Sub-classing Entities
    14. Creating DSNs from code
    15. Synchronization without Replication
    16. Creating an AutoNumber field from code
    17. Lookup Table Manager
       
    Updates

    Go To Top
    1. November 6th, 2000
    2. April 3rd, 2000
    3. February 16th, 2000
    4. December 5th, 1999
    5. November 8th, 1999
    6. October 6th, 1999
    7. September 26th, 1999
    8. August 8th, 1999
    9. July 10th, 1999
    10. June 7th, 1999
    11. April 6th, 1999
    12. March 15th, 1999
    13. March 13th, 1999
    14. March 6th, 1999
    15. February 15, 1999
    16. January 26th, 1999
    17. December 11th, 1998
    18. November 6th, 1998
    19. November 4th, 1998
    20. September 27th, 1998
    21. September 9th, 1998
    22. August 27th, 1998
    23. August 17th, 1998
    24. July 15th, 1998
    25. June 23rd, 1998
    26. June 4th, 1998
    27. May 22nd, 1998
    28. May 8th, 1998
    29. May 1st, 1998
    30. April 26th, 1998
    31. April 16th, 1998
    32. March 29th, 1998
    33. March 9th, 1998
    34. February 15th, 1998
       
    Win32 API

    1. Call Windows File Open/Save Dialog box
    2. Call Windows Browse for Folder Dialog box
    3. Get Local Drives and UNC Path of network drives
    4. Have Access pause until Shelled process has finished
    5. Retrieve Unique Filenames for mass export
    6. Search for a file
    7. Find out if an application is currently running
    8. Network User Name
    9. Current Computer Name
    10. Retrieve Windows/System/Temp Directories
    11. How to play WAV/MIDI/AVI files
    12. Use GetSystemMetrics to return System specific information
    13. Find class names of a running application
    14. Create/return a unique temp file
    15. Read a Value from Registry
    16. How do I quit Windows from Access?
    17. How to retrieve information about a specific Locale
    18. Start Registered applications with ShellExecute
    19. Manipulate Access Window
    20. Return Long or Short Filenames
    21. Make it "Sleep"
    22. Disable Close button on maximized form
    23. Retrieve executable's filename and path
    24. Daylight Savings Time & PreciseDateDiff
    25. Close another Application
    26. Copy a database
    27. hWnd of Controls
    28. Change cursor while editing
    29. Detect Available Resolutions
    30. Interrupt running code
    31. AddressOf
    32. Drag and Drop from Explorer
    33. Enumerating System Fonts
    34. Detect Application Activate/Deactivate
    35. Put an image in Access window
    36. Track IntelliMouse's wheel
    37. Suppress the "Printing" Dialog
    38. Suppress the "Loading Image" dialog
    39. Retrieve NT Server's Time
    40. Retrieve Current User's NT Domain
    41. Preventing Multiple Instances of a database
    42. Copy an image to the Clipboard
    43. Put a custom icon in the form's caption bar
    44. Displaying a custom Mouse icon
    45. Subclassing form for SysTray functionality
    46. Replacement for Sendkeys
    47. Enabling Full Row Select in a ListView
    48. Enabling Full Row Select in a Treeview
    49. Copy variables/control contents to memory
    50. Rotate Text
    51. Read/Set Internet Explorer URL from code
    52. Determining Combobox's Dropped state
    53. Drawing images on an Access form
    54. Retrieving a Special Folder's location
    55. Retrieving Operating System Name
    56. Changing button captions in GetOpenFileName dialog
    57. Removing Min-Max-Close buttons from a report's Preview Window
    58. Enumerating user accounts in a NT Domain
    59. Changing Access's Priority under NT-Win2000
    60. Calling Windows Choose Color Dialog
    61. Calling Windows Choose Font Dialog
    62. Return the UserID currently logged on a remote machine
    63. Close the VBE window in Access 2000
    64. Change the ForeColor and Bold properties of a selected node in Treeview
    65. Get Version of Office Exes (detecting Office 2000 SR1 patch)
    66. Get full name of the user currently logged in to the system
    67. Perform IP Lookups and resolve addresses

    © 1998-2000, Dev Ashish, All rights reserved

    Terms Of Use

    Optimized for Microsoft Internet Explorer
    If you find the font size too small or too big on this site, then use control-'[' and control-']' or control-'IntelliMouse wheel scroll' key combinations in Netscape and Internet Explorer respectively to auto-size the fonts.