Esteemed Forum Participants and Lurkers:
===============================
Access 2003 VBA
I'm a gutless wonder when it comes to Access (not to mention my gross disdain for the (in)capability of documenting??? an Access design!).
I'm trying to implement a user function in an access database. For testing purposes, I have the following trivial "triple" code in module "User_Functions":I can't seem to get this to work in a Report, or in a Query, or in a Table column (which is what I would really like to do!). My Report control looks like this:Code:Option Compare Database Option Explicit Function triple(anInt As Integer) As Integer triple = anInt * 3 End FunctionWhen I try to open the Report in Print Preview, I get a popup asking "Enter Parameter Value" for "MSI_10_10" which is the name of my table. I don't want a parameter. I just want an output for each record which (for now) = (Code x 3). If I enter a value in this popup, such as "99", my Report shows "#Error" in the Text4 control for the 2 integer values for the Code in my MSI_10_10 table ... 12 & 34.Code:TextBox: Text4 Control Source: =triple(MSI_10_10!Code)




Reply With Quote