Run AutoExec macro in the backend access db

[theDBguy]

Congratulations! Now, you're a VBA user. Good luck with your project.

 

[AsMok]

Congratulations! Now, you're a VBA user. Good luck with your project.

many many many thanks

and how should i run it another beginner question

 

[theDBguy]

many many many thanks

and how should i run it another beginner question

Well, now, you can create a macro in the FE and use the RunCode action to call the function name. You can then run the macro however you decide to. For example, you can use a button to call it.

 

[AsMok]

Well, now, you can create a macro in the FE and use the RunCode action to call the function name. You can then run the macro however you decide to. For example, you can use a button to call it.

​

after i created a runcode macro

 

[theDBguy]

Can you show us the macro?

 

[AsMok]

Can you show us the macro?

 

[theDBguy]

Okay, I think I understand. Since we are using a macro, you'll need to call a function. What we just created was a sub. So, go back to the code and change

Public Sub

to

Public Function

And also, change

Exit Sub

to

Exit Function

 

[AsMok]

Okay, I think I understand. Since we are using a macro, you'll need to call a function. What we just created was a sub. So, go back to the code and change


Public Sub


to


Public Function

yes that is the problem​

and I add () to the function name

now it works great

many many many many many thanks for your great help

 

[theDBguy]

Hi. I rarely use a macro, so I never planned on this before. Glad to hear you got it sorted out. Cheers!

 

[AsMok]

Hi. I rarely use a macro, so I never planned on this before. Glad to hear you got it sorted out. Cheers!

Thanks from the bottom of my heart

 

[theDBguy]

Thanks from the bottom of my heart

Don't mention it.