Access Links

Access VBA Tips and Tricks

  • Hits: 2062
    2003 VBA Functions (by category)
  • Hits: 1633
    A work in Progress and 64 Bit VBA
  • Hits: 1978
    Access Reference Problems
    From time to time, you may find that common functions like CurrentDB, Str$ or Mid$ stop working. This condition is usually caused by a reference error in the database. (All Access databases contain references, which are a way of referring to another application's or project's type library. In general, you want to ensure that the files referenced in an Access application exist in exactly the same location on the client workstations as they did on the development workstation, and that each referenced file is the same version on all workstations.) Avoiding reference issues require an understanding of how libraries are referenced in an Access database and what is needed to install a database on a target machine without breaking these references.
  • Hits: 6424
    An Introduction to the Scripting Runtime Object Library
    Although some applications link to foreign files, an Access database generally contains all the objects an application needs. As a result, file management isn't the same kind of laborious affair it is with other applications. However, that doesn't mean you'll never need to work with data files and folders. If you're lucky, the task will be small and easily handled by the VBA functions and statements. On the other hand, major file management can quickly run into some long, convoluted code. When this is the case, we recommend you consider using the Scripting Runtime Object Library instead of the VBA functions and statements. You'll find this library much better suited to file management than VBA's counterparts. Although the Scripting Runtime Object Library was born from the need to manipulate files via the Internet, you'll find it works equally well with most Visual Basic applications.
  • Hits: 2094
    Conquer Access RunCommand Constants
    Great information and VBA code examples for using DoCmd.RunCommand
  • Hits: 1431
    Convert Currency ($500) into words (Five Hundred Dollars)
    Here is how to have Access convert the currency value "$531.20" into the text "Five hundred thirty one and twenty cents."
  • Hits: 2430
    Decompile Your Microsoft Access Database
    Decompile Your Microsoft Access Database to Improve Performance, Fix Corruption, and Avoid Strange VBA Errors Periodically, Microsoft Access databases with VBA module code perform oddly. Code that previously worked suddenly fail or behaves incorrectly. It's all very confusing, especially when Compact and Repair does not help. The initial assumption is that the database is corrupt, which is partially true. People then resort to creating a new database and importing their objects into it which is time consuming and a pain. It solves the problem, but there's a better alternative to check first.
  • Hits: 1453
    ExportXML Method
    The ExportXML method allows developers to export XML data, schemas, and presentation information from Microsoft SQL Server 2000 Desktop Engine (MSDE 2000), Microsoft SQL Server 6.5 or later, or the Microsoft Jet database engine.
  • Hits: 1754
    How Access resolves Visual Basic for Applications references
    This article discusses the sequence of tasks that Microsoft Office Access 2007, Microsoft Office Access 2003, Microsoft Access 2002, Access 2000, or Access 97 performs to resolve the references in Microsoft Visual Basic for Applications (VBA).
  • Hits: 2368
    How do I... Retrieve a random set of records in Microsoft Access?
    We usually think of data in sets of related values, but not always. Occasionally, you may need to supply someone with a set of unrelated records, retrieved completely at random. Perhaps a manager wants to predict future growth or an auditor is looking for anomalies. Now, it would be nice if Access offered a random query option, but it doesn
  • Hits: 1772
    HyperlinkPart Method [Access 2003 VBA Language Reference]
    ** Applies to Access 2003, Access 2007, and Access 2010 ** You use the HyperlinkPart method to return one of three values from a Hyperlink field or the displayed value. The value returned depends on the setting of the part argument. The part argument is optional. If it's not used, the function returns the value Microsoft Access displays for the hyperlink (which corresponds to the acDisplayedValue setting for the part argument). The returned values can be one of the four parts of the Hyperlink field (displaytext, address, subaddress, or screentip), the full address, address#subaddress, or the value Microsoft Access displays for the hyperlink.
  • Hits: 1956
    Hyperlinks: warnings, special characters, errors
  • Hits: 1850
    How to resolve reference issues in an Access database
    his article describes issues that concern the use of references in an Access database. Understanding reference errors requires an understanding both of how libraries are referenced in an Access database and of what is needed to install a database on a target computer without breaking these references. This article is a summary of the following topics: Viewing Access database references Resolving Microsoft Visual Basic for Applications references in Access Understanding reference error messages Resolving reference issues on the development computer Distributing database files Updating the reference list Distributing database files that have ActiveX controls Reregistering a file
  • Hits: 1688
    How to use the OpenDatabase method to open password-protected databases
    his article describes how to use the OpenDatabase method to open a Microsoft Access database that has a database password. Note that this is different from opening a database that is secured with the Microsoft Access user-level security feature.
  • Hits: 1932
    Introduction To Classes
    Classes are a powerful tool in intermediate to advanced level VBA programming. This page is an introduction to what a class and an object are and will hopefully get you started working with classes. This is by no means a comprehensive guide
  • Hits: 2404
    Inventory Control: Quantity on Hand
    written by Allen Browne "How do I update the Quantity On Hand each time an item is sold/used?" The simple answer is: You don't! You calculate the value when you need it. The calculation is very simple: the total number acquired, less the number disposed of. Just use DSum() on the table of acquisitions to get the number acquired for any product. Another DSum() expression on the table of uses/invoices gets the number disposed of. For the simplest databases, that's all you need.
  • Hits: 1739
    Importing and Exporting XML Data Using Microsoft Access
    Office Space: Tips and Tricks for Scripting Microsoft Office Applications Although the Office Space column has been in business for several months now there are at least two topics we haven
  • Hits: 2732
    Late Binding in Microsoft Access
    Late binding means you can do not have to concern yourself with what version of other software, such as Word, Excel or Outlook, being installed on the target system. Or if that software is not installed at all on the target system.. We found this problem when a client had Outlook 98 everywhere and the IT manager decided to load Outlook 2000 just to play with it. You will, of course, have to ensure you do not use any version specific code.
  • Hits: 1492
    MSDN ADOX Fundamentals
    Microsoft
  • Hits: 1390
    MSDN ADO Programmer's Reference
    This section contains the following topics. ADO API Reference, RDS API Reference, ADO MD API Reference, ADOX API Reference

Latest News

Popular