472,352 Members | 1,615 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,352 software developers and data experts.

How to pass variable value...

GB
Hello:
In my MS Access project I have two objects - my form and my report.
I need to pass variable value from
Command_click procedure of my form to
Report_open procedure of my report.
How can I do that?
I tried to declare this variable as Public in my form, but it does not
work -
when I reference to this variable in my report, it does not pass the value.

Thanks,
GB
Nov 13 '05 #1
5 6970
"GB" <v7****@hotmail.com> wrote in
news:9_zKd.75550$Qb.5473@edtnps89:
Hello:
In my MS Access project I have two objects - my form and my
report. I need to pass variable value from
Command_click procedure of my form to
Report_open procedure of my report.
How can I do that?
I tried to declare this variable as Public in my form, but it
does not work -
when I reference to this variable in my report, it does not
pass the value.

Thanks,
GB


Read the help on the openreport action for the openargs parameter
--
Bob Quintal

PA is y I've altered my email address.
Nov 13 '05 #2
Although OpenForm has an OpenArgs procedure, AFAICS, OpenReport does not.

If the variable is declared as Public in a Standard Module (not a form
module), it should be visible to both the form and the report.

"Bob Quintal" <rq******@sPAmpatico.ca> wrote in message
news:1106959484.144984a48fea02f5b021342e22718772@t eranews...
"GB" <v7****@hotmail.com> wrote in
news:9_zKd.75550$Qb.5473@edtnps89:
Hello:
In my MS Access project I have two objects - my form and my
report. I need to pass variable value from
Command_click procedure of my form to
Report_open procedure of my report.
How can I do that?
I tried to declare this variable as Public in my form, but it
does not work -
when I reference to this variable in my report, it does not
pass the value.

Thanks,
GB


Read the help on the openreport action for the openargs parameter
--
Bob Quintal

PA is y I've altered my email address.

Nov 13 '05 #3
I believe it was added into Access 2002. It's definitely available in Access
2003.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"MacDermott" <ma********@nospam.com> wrote in message
news:Ll**************@newsread3.news.atl.earthlink .net...
Although OpenForm has an OpenArgs procedure, AFAICS, OpenReport does not.

If the variable is declared as Public in a Standard Module (not a form
module), it should be visible to both the form and the report.

"Bob Quintal" <rq******@sPAmpatico.ca> wrote in message
news:1106959484.144984a48fea02f5b021342e22718772@t eranews...
"GB" <v7****@hotmail.com> wrote in
news:9_zKd.75550$Qb.5473@edtnps89:
> Hello:
> In my MS Access project I have two objects - my form and my
> report. I need to pass variable value from
> Command_click procedure of my form to
> Report_open procedure of my report.
> How can I do that?
> I tried to declare this variable as Public in my form, but it
> does not work -
> when I reference to this variable in my report, it does not
> pass the value.
>
> Thanks,
> GB


Read the help on the openreport action for the openargs parameter
--
Bob Quintal

PA is y I've altered my email address.


Nov 13 '05 #4

"GB" <v7****@hotmail.com> wrote in message
news:9_zKd.75550$Qb.5473@edtnps89...
Hello:
In my MS Access project I have two objects - my form and my report.
I need to pass variable value from
Command_click procedure of my form to
Report_open procedure of my report.
How can I do that?
I tried to declare this variable as Public in my form, but it does not
work -
when I reference to this variable in my report, it does not pass the
value.


There are a number of ways to do this including through a public variable.
Note that public variables must be declared in a module.


Nov 13 '05 #5
Woops! My age is showing.
Thanks for bringing me up to speed!

- Turtle

"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
news:V_********************@rogers.com...
I believe it was added into Access 2002. It's definitely available in Access 2003.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"MacDermott" <ma********@nospam.com> wrote in message
news:Ll**************@newsread3.news.atl.earthlink .net...
Although OpenForm has an OpenArgs procedure, AFAICS, OpenReport does not.
If the variable is declared as Public in a Standard Module (not a form
module), it should be visible to both the form and the report.

"Bob Quintal" <rq******@sPAmpatico.ca> wrote in message
news:1106959484.144984a48fea02f5b021342e22718772@t eranews...
"GB" <v7****@hotmail.com> wrote in
news:9_zKd.75550$Qb.5473@edtnps89:

> Hello:
> In my MS Access project I have two objects - my form and my
> report. I need to pass variable value from
> Command_click procedure of my form to
> Report_open procedure of my report.
> How can I do that?
> I tried to declare this variable as Public in my form, but it
> does not work -
> when I reference to this variable in my report, it does not
> pass the value.
>
> Thanks,
> GB

Read the help on the openreport action for the openargs parameter
--
Bob Quintal

PA is y I've altered my email address.



Nov 13 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Seeker | last post by:
Newbie question here... I have a form with some radio buttons. To verify that at least one of the buttons was chosen I use the following code...
5
by: wilson | last post by:
Dear all, In this time, I want to pass array to function. What should I declare the parameter in the function?i int array or int array? Which...
4
by: z_learning_tester | last post by:
I'm reading the MS press C# book and there seems to be a contradiction. Please tell me which one is correct, 1 or 2. Thanks! Jeff 1. First it...
5
by: David++ | last post by:
Hi folks, I would be interested to hear peoples views on whether or not 'pass by reference' is allowed when using a Web Service method. The...
10
by: Robert Dailey | last post by:
Hi, I noticed in Python all function parameters seem to be passed by reference. This means that when I modify the value of a variable of a...
10
by: mike4722 | last post by:
I wish to have the form to be able to automatically select the radio button based on the logic of HTML/php variable. example show below: ...
6
by: lisp9000 | last post by:
I've read that C allows two ways to pass information between functions: o Pass by Value o Pass by Reference I was talking to some C...
11
by: venkatagmail | last post by:
I have problem understanding pass by value and pass by reference and want to how how they are or appear in the memory: I had to get my basics...
12
by: Bryan Parkoff | last post by:
I write my large project in C++ source code. My C++ source code contains approximate four thousand small functions. Most of them are inline. I...
12
by: raylopez99 | last post by:
Keywords: scope resolution, passing classes between parent and child forms, parameter constructor method, normal constructor, default constructor,...
0
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
0
jalbright99669
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
0
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
2
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
0
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...
0
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web...
0
by: Carina712 | last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand....
0
BLUEPANDA
by: BLUEPANDA | last post by:
At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS...
0
by: Rahul1995seven | last post by:
Introduction: In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.