Access Links

Access Links

Access VBA Tips and Tricks

  • Hits: 1522
    Microsoft Access Add-in (Library Database) Tips, Hints and Gotchas
    if you want to create an add-in for wide spread use outside your control then you should consider creating the MDE as an add-in with the USysRegInfo table. Otherwise just setting a reference works fine as Access 2000 and newer look in the same folder as the calling MDE for reference MDE.
  • Hits: 1039
    MSDN Using Conditional Compilation
    Conditional compilation lets you selectively compile certain parts of the program. You can include specific features of your program in different versions, such as designing an application to run on different platforms, or changing the date and currency display filters for an application distributed in several different languages.
  • Hits: 1276
    Microsoft Access VBA Uses WMI to Read the Registry
    Microsoft Access VBA can read and write to the Windows Registry by using WMI. In this article we are going to show you how easy it is to read 5 different types of Registry Values with VBA and WMI.
  • Hits: 1149
    Power Tip: Take advantage of Rich Text textboxes in Access
    Today
  • Hits: 1280
    Retrieving Identity or Autonumber Values
    You can set a column in a DataTable to be an auto-incrementing primary key in order to ensure a unique value for each row in the table. However, you may have multiple clients for your application, and each of those clients can be working with a separate instance of the DataTable. In this case, you might end up with duplicate values between the separate instances of the DataTable. Because all your clients are working with a single data source, you can resolve this conflict by letting the data source define the auto-incremented value. To accomplish this you use Identity fields in Microsoft SQL Server, or Autonumber fields in Microsoft Access.
  • Hits: 1010
    Setting Global Options Programmatically
    Summary: This article covers setting the global options for Access in programming code. It includes discussion, sample code, and detailed tables of all appropriate options. It highlights those options that were documented incorrectly and points out some undocumented options. (17 printed pages)
  • Hits: 1037
    Set Options from Visual Basic
    You can use the SetOption and GetOption methods to set and return option values in the Options dialog box from code. To view the Options dialog box, click Options on the Tools menu. The following tables list the names of all options that can be set or returned from code and the tabs on which they can be found in the Options dialog box, followed by the corresponding string argument that you must pass to the SetOption or GetOption method. Notes If your database may run on a version of Microsoft Access for a language other than the one in which you created it, then you must supply the arguments for the GetOption and SetOption methods in English. Some options are available only within a Microsoft Access database (.mdb) or Access project (.adp).

Latest News