Developers' tools
Total
Access Analyzer - 2.0, '97, '2000, '2002
Total
Visual Sourcebook
Black Moshannon Speed
Ferret
Visual Basic 6.0 - Access
Using Excel functions in Access
Assume that you have Excel on the same machine. In a
standalone module, select Tools, References in the menu and enable the Excel
library (the description varies between different Excel versions) In Excel'95,
it's described as "Microsoft Excel 5.0 Object Library".
Next, key in the following code:
Function acRound(dblNumber As Double, bytePrecision As Byte) As Double
acRound = Excel.Application.Round(dblNumber, bytePrecision)
End Function
Click the Compile icon to ensure that you have not made any
mistakes and the system works. Now, in any place that you care to put a function
to work, use acRound() instead of Round()
Note: This was an arbitrary example. I just found that in
Access 2000, the Round() function is not listed in the Expression Builder but is
available to Access expressions.
VBA
Outlook - Access
PowerPoint - Access
|
