Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
224 views
in Technique[技术] by (71.8m points)

vba - Suggested startup tasks for access split DB (AutoExec)

I am working on a MS Access split database and I read in many places to create AutoExec macro to automate a few startup tasks like securing front end (hide ribbon etc.). I am learning as I am going through the project so I am fairly a newbie to access programming.

Can anyone list, like a few "good practice" startup tasks that can be added to the front end and if possible with sample codes/links to sites.

Thanks.

question from:https://stackoverflow.com/questions/65850042/suggested-startup-tasks-for-access-split-db-autoexec

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)

Use macros incl. AutoExec as little as possible, as these are hard to debug and document.

Best practice is to specify in Settings the form to open at launch, then let this run the startup tasks you need.


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

2.1m questions

2.1m answers

60 comments

57.0k users

...