Solved

Select Case as macro

Posted on 2008-10-29
4
402 Views
Last Modified: 2012-06-27
Is there a way to do Select Case in a Macro?  Or if I Have a message saying do you want to run this and they say not it will stop the rest of the macro from running?

2007 is createing macro when I create a button to run a query, but I am not real sure how to do some of the things I used to do in code.  

Thanks, Pat
0
Comment
Question by:PatKung
[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
  • 2
4 Comments
 
LVL 75
ID: 22835057
I *think* ... that in A2007, something like this can now be done.  I don't have A2007 loaded at the moment.

mx
0
 
LVL 44

Accepted Solution

by:
GRayL earned 500 total points
ID: 22836190
Why not use the macro to RunCode?  And the function named in RunCode has the Select Case?
0
 

Author Comment

by:PatKung
ID: 22859154
That should work.  

Thanks, Pat
0
 
LVL 44

Expert Comment

by:GRayL
ID: 22859496
Thanks, glad to help.

Ray
0

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

631 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question