<

MS Access – Writing Solid VBA Code

Posted on
4,781 Points
681 Views
11 Endorsements
Last Modified:
Published
Experience Level: Beginner
6:40
Jim Dettman (EE MVE)
Independent consultant specializing in the writing of custom packages for businesses.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
11
0 Comments
If you want to save changes made programmatically to a reports Printer property do not use this syntax: docmd.close acReport, Reportname, acSaveYes
I found that a simple "Welcome" screen/form added to a database makes it both more friendly and easier to use.  Here is how I added one to a Microsoft Access database. Please see the important note at the bottom of this article regarding compati…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month