[AccessD] Is it Possible to Have a Variable in a VBA "CALL"Statement?

Brad Marks BradM at blackforestltd.com
Fri Jan 27 19:13:36 CST 2012


Arthur,

Sorry, I should have explained earlier in more detail what I am trying to do.

I am building an Access 2007 "Reporting" application.

I have written a number of small chunks of VBA code to support "Compound Dynamic Report Filters".  Much of the code is "Common" code, but some of the code needs to be customized slightly for each Report.

In the "common" code that calls the "Specialized" code, I current use IF statements to call the proper sub.  This will require one IF statement for each report (someday we might have 50+ reports)

By being able to use a variable in the VBA CALL statement, we will be able to have just a few lines of code, instead of all the code needed to support 50+ different reports.

I hope that this explains what we are trying to do.

Also, I am still learning about Access and I often ask questions and do experiments just to learn new things.

The folks here on AccessD have been wonderful with their help and suggestions.

Brad         

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


-----Original Message-----
From: accessd-bounces at databaseadvisors.com on behalf of Arthur Fuller
Sent: Fri 1/27/2012 6:55 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Is it Possible to Have a Variable in a VBA "CALL"Statement?
 
Why on this particular planet you would choose to write such code, I
confess, escapes me completely, not least because it totally defeats
code-walking, trace, etc. Alternatively, perhaps I'm simply too old and too
stupid to recognize the advantage(s) gained by such an arcane manouvre.
-- 
Arthur
Cell: 647.710.1314

Prediction is difficult, especially of the future.
  -- Niels Bohr
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.





More information about the AccessD mailing list