Forum Discussion

SuperUser20's avatar
SuperUser20
Copper Contributor
Nov 02, 2021

Regarding macros and function in Microsoft access

Hi, I have created one function in Microsoft access and I am trying to run that function using autoexec macro, but I am getting the error as shown below even if I am using the same function name tha...
access
isladogs's avatar
isladogs
MVP
Dec 02, 2021

For info, functions are always public unless specifically labelled as Private. The quote below is from the article that you linked

Also, the OP has already confirmed the function is Public

Karl_Donaubauer's avatar
Karl_Donaubauer
MVP
Dec 02, 2021

Hi Colin,

 

I don't remember if we have already advised him to do a check inside VBA in order to see if the function is reachable at all:

 

1. Open the Immediate Window of VBA by pressing <Ctrl>+G anywhere in Access.

2. In the Immediate Window type the name of the function , i.e.

FetchData

and press <Enter> in this line

 

If the function executes, it is really public and should be reachable also for macros.

 

Servus
Karl
*********
Access-Entwickler-Konferenz: https://www.donkarl.com/?AEK
Access DevCon: http://AccessDevCon.com
Access FAQ (de/it): https://www.donkarl.com

Resources