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.