Printing results of function to screen

  • Thread starter Thread starter AScriptGuy
  • Start date Start date
A

AScriptGuy

I have written a function that queries a remote PC for patches. I
want the results to be printed to the screen. I have two issues.

1) I need to get the name of the PC from the current record to the
function, or to a form. I can pass the field name for the PC to a
function, no problem. What I cannot do is figure out how to pass the
field name to a form, or to create a public variable for the message
text to be printed.

2) I need to print the results of the function to the screen. I'd use
MsgBox, but there is too much data. What I'd like is a textbox with a
vert scroll bar and vbokonly.

VBA and Access are driving me nuts! Thanks for the help.

A
 
If you want to call a function MyFunc, passing a parameter "my prm", and
display the (text) results of the function in a text windown on the screen,
you would:
- create a form with a bix textbox;
- set the ScrollBars attributes of that box to whatever you want, and
- set the Controlsource property of the textbox, to: =MyFunc("my prm")

Is that what you want?

HTH,
TC
 
Back
Top