473,324 Members | 2,166 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Best VBA option to have users run a variable list of procedures

68
I have a screen that shows the user a list of actions that they can run on a file. It's a form (off a query, off a table) that shows the action name and a checkbox. The checkbox defaults to Yes and they can uncheck whatever actions they don't want to run.

When they go to run the list of (checked) actions (mostly procedures that run append queries via SQL) there will be about 30 selections. What is the best way to link their list of 30 to the procedures in the VBA?

Originally I thought I would hide the procedure name in the list, move through the recordset, pull the procedure name off the table, and call it like a procedure using a variable name, but I got the error that you can't call procedures as a variable. Is there another way to do this?

I could do a case select but would have 30+ options.

What would be the simplest most efficient way to code this?
Thank you!
May 19 '11 #1

✓ answered by dk4300

I've just discovered Application.Run and it's working great.

2 1823
dk4300
68
I've just discovered Application.Run and it's working great.
May 19 '11 #2
NeoPa
32,556 Expert Mod 16PB
Nice design. Nice solution :-)
May 19 '11 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

6
by: Fazer | last post by:
Hello, I was wondering which would be the best way to compare a list? I was thinking of just using a for loop and testing the condition. What do you guys think? The best/fastest way of...
2
by: bwooster47 | last post by:
I'm a newcomer to python - what is the best way to convert a list into a function call agruments? For example: list = (2005, 5, 5) date = datetime.date( list ) fails with: TypeError:...
8
by: darrel | last post by:
I'm still trying to fully understand how best to pass variables between pages/usercontrols/each other. On a current site I've done, I've had one userControl do the logic and set the variable,...
1
by: johngilmer | last post by:
I have a dropdown list where the text that the user sees is unique, but the values behind the options in the list are not unique. So the text/value pairs in the list might be: a - 1 b - ...
2
by: jetal15 | last post by:
To develop a Framework for Content management system, which contians three part 1) core part 2)Data storage and retrival and 3)Workflow In Core part there is need to develop communication layer...
5
RMWChaos
by: RMWChaos | last post by:
I am working on a script to create and remove DOM elements, and I want to make it as efficient as possible (no redundancies). Because DOM elements each have their own set of attributes, the function...
9
by: | last post by:
In my database I have a 'control table' in which basic info is stored about the application, for instance the application's path and the name of the company that is using it. In all of the...
2
by: crazychrisy54 | last post by:
Hi there I have a option, select drop down list which a user can open. My page however refreshes very frequently and when this occurs the selected drop down list will pop back up. The user then...
1
by: mh | last post by:
I'm porting a C lex/yacc based project, and would like to redo it in python. What's the best option for a python lex/yacc-like? I've googled a few things, but wanted to see the current...
2
by: lonelylonely | last post by:
how to display in new text field when i add option from drop down list?
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.