Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.
Solved
Running a module in Microsoft Access 2003
Posted on 2014-03-05
Experts,
How do I run a module from Access 2003? Currently this is the only code in the Database. I want to see if it works.
How do I run a module from Access 2003? Currently this is the only code in the Database. I want to see if it works.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
4 Comments
Active 1 day ago
The above answer is not entirely complete,
You need to open the VBA Editor first, by either hitting Ctrl-G or opening the module from database window.
At that point, F5 will work (specify the name of the sub or function you want to run)
You can also hit ctrl-G again, which will take you to the "immediate window" at the bottom of the vba editor. From there, you can run the sub or function by typing it its name and specifying pass parameters as needed.
You need to open the VBA Editor first, by either hitting Ctrl-G or opening the module from database window.
At that point, F5 will work (specify the name of the sub or function you want to run)
You can also hit ctrl-G again, which will take you to the "immediate window" at the bottom of the vba editor. From there, you can run the sub or function by typing it its name and specifying pass parameters as needed.
Active today
The technical answer is - you don't run modules - you run procedures. You need to run the sub or function contained in the module. If there are multiple, you need to figure out what is the "main" procedure that invokes the others. If they are all independent, you would need to run each in turn.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
- Query Syntax
- SQL
- Databases
- MySQL Server
- MongoDB
- NoSQL Databases, Percona
In this article, we’ll look at how to deploy ProxySQL.
- Databases
- Network Analysis
- Network Operations
- Network Security
- MySQL Server
- Network Architecture, Percona, *proxy servers, *Data Migration
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string.
Specify the first argument, which is the expression to be returned:
Specify the second argument, which …
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen.
Visualize your data! ... really see it
To use the code to create a calendar from a q…
Suggested Courses
Course of the Month7 days, 2 hours left to enroll
705 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.