[AccessD] Switchboard question

Arthur,

You can do it if you modify the structure of the Switchboard Items
table, but that means you can no longer use the Switchboard Manager
add-in to modify your switchboard in that particular database.  If you
add a Param field to the table,  you can use the following RunCode case
to make use of that parameter:

        ' Run code.
        Case conCmdRunCode
          If IsNull(rst![Param]) Then
            Application.Run rst![Argument]
          Else
            Application.Run rst![Argument], rst![Param]
          End If

Charlotte Foust


-----Original Message-----
From: Arthur Fuller [mailto:artful at rogers.com] 
Sent: Monday, October 13, 2003 7:27 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Switchboard question


This syntax also doesn't work within the Switchboard Manager.

A.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bob Heygood
Sent: Sunday, October 12, 2003 2:11 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Switchboard question


Usually the reason we use a function is to return a value. 
So
 X = myFunc("StrParm", intParm)
is the way to do so. Where x is the value returned by the function.

Bob Heygood




-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Arthur Fuller
Sent: Sunday, October 12, 2003 1:25 PM
To: AccessD
Subject: [AccessD] Switchboard question


When you call a function (that takes parameters) from the switchboard,
what's the correct syntax? I've tried:

myFunc "strParm", intParm
And 
myFunc( "StrParm", intParm )

Neither of which worked.

Normally I just write a sub and call it with no parms, but today I
decided to try something different and it isn't working as expected.

TIA,
Arthur

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.525 / Virus Database: 322 - Release Date: 10/9/2003
 


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.525 / Virus Database: 322 - Release Date: 10/9/2003
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.525 / Virus Database: 322 - Release Date: 10/9/2003
 


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com