Home
Microsoft Office
Access
Access Tutorials
Access Downloads
Access FAQs
Access Links
Outlook
Outlook Blog
Outlook Links
Windows
Windows Blog
Windows Links
Site Index
Directory
Downloads
Links
Store
Access Tutorials, TIPs, Examples
Access Links
You are here:
Home
Microsoft Office
Access
Access Links
Access VBA Tips and Tricks
Access Links
Access VBA Tips and Tricks
Unpublished
Filter Field
Display #
5
10
15
20
25
30
50
100
All
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).
Page 2 of 2
Start
Prev
1
2
Next
End
Latest News
ACC2000: How to Build a Visual Basic Module to Print a Report in Landscape Mode on Legal-Size Paper
Office Template Store
What happens to those free Windows 10 upgrades after July 29, 2016?
Preview a Report and move to last page
Deploying Application (Front End) Updates