Using MS Access/Help

Advertisement


Question
When I try to run my code in the code window by pressing Run commad or F5, it opens the Macros window and expects me to write the name of the macro. Could you please help me how to get rid of this Macros window!

Answer
Code needs to be run by an event related to a form, or form control, or custom function you have entered in a query.  Events start or trigger code to run.
Your code will be either a subroutine or a function.
You can test it by placing a form button control on a form and call the code from the Click Event of the button by using the name of the function or subroutine.

Bob Heifler

MyAccessProgram.com
DailyAccessTips.com

Contact at:
http://myaccessprogram.com/Contact.html

Find example files at:
http://myaccessprogram.com/Download.html

Find free video tutorials at:
http://myaccessprogram.com/Tutorial.html

Using MS Access

All Answers


Answers by Expert:


Ask Experts

Volunteer


Bob Heifler

Expertise

ALL MICROSOFT ACCESS DESIGN AND PROGRAMMING QUESTIONS 
Free Microsoft Access Tutorial Videos are available to you at my web site. Fifteen years of Microsoft Access experience allows me to answer most of your questions. Common question example files available here.

Experience

Microsoft Access programming since 1994. Support for all versions.

Publications
My Microsoft Access articles are published at:DailyAccessTips.com

Education/Credentials
UCLA GRAD, Member of Association of Database Developers

Awards and Honors
AccessToExcel.com has won several shareware awards for assisting analysts in moving data from MS Access to Excel.

Past/Present Clients
See some of my past clients here.

©2012 About.com, a part of The New York Times Company. All rights reserved.