Forum Discussion

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

Karl_Donaubauer

MVP

Nov 03, 2021

Hi,

You didn't tell how you refer to the function in the macro. Maybe you just didn't add the parenthesis, i.e. in the Function Name property of the RunCode action you should have: FetchData()

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

SuperUser20

Copper Contributor

Nov 03, 2021

Karl_Donaubauer

I am using FetchData() only, still it not working

Karl_Donaubauer
MVP
Nov 03, 2021
Hi,

Another common reason for the message are security restrictions. Do you perhaps see yellow warning triangles on actions in the macro editor?

Is the database in a "trusted folder" or have you disabled macro security?

Servus
Karl
*********
Access-Entwickler-Konferenz: https://www.donkarl.com/?AEK
Access DevCon: http://AccessDevCon.com
Access FAQ: https://www.donkarl.com
- SuperUser20
  Copper Contributor
  Nov 16, 2021
  I tried disabling all security restrictions still it is not giving me the required output.