If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Call a function designated in a table
I want to provide a list of reports or pdf files that the user can generate.
Some of the reports use openreport and some will need to create an adobe form and call adobe reader. So I created a table with the Name, Type, and Action. I want to perform the Action designated in the Action part of the table. For example in the Table Name: Insurance Form Type: pdf Action: fctInsuranceForm(SalesID) OR Type: rpt Action: DoCmd.OpenReport "rptInsuranceForm" ' ...get the table into rs, then Select Case rs("Type") Case "pdf" 'This is not working, but want to call the function in Action, something like this: Call rs("Action") Case "rpt" 'This is not working, but want to call theOpenReport, something like this: rs("Action") End Select How can I call an action from a table? |
#2
|
|||
|
|||
Look at Help for the Eval() Function - I think that it is what you
need. On Wed, 29 Sep 2004 08:57:04 -0700, Cosmic wrote: I want to provide a list of reports or pdf files that the user can generate. Some of the reports use openreport and some will need to create an adobe form and call adobe reader. So I created a table with the Name, Type, and Action. I want to perform the Action designated in the Action part of the table. For example in the Table Name: Insurance Form Type: pdf Action: fctInsuranceForm(SalesID) OR Type: rpt Action: DoCmd.OpenReport "rptInsuranceForm" ' ...get the table into rs, then Select Case rs("Type") Case "pdf" 'This is not working, but want to call the function in Action, something like this: Call rs("Action") Case "rpt" 'This is not working, but want to call theOpenReport, something like this: rs("Action") End Select How can I call an action from a table? Please respond to the Newsgroup, so that others may benefit from the exchange. Peter R. Fletcher |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Can Hyperlink Call Subset of Table? | Tom | Using Forms | 8 | August 12th, 2004 12:39 PM |
Name not showing ID is | René | Setting Up & Running Reports | 11 | June 29th, 2004 01:40 AM |