A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Include control that are only in forms



 
 
Thread Tools Display Modes
  #1  
Old May 7th, 2007, 07:14 AM posted to microsoft.public.access.reports
EMILYTAN via AccessMonster.com
external usenet poster
 
Posts: 47
Default Include control that are only in forms

I want to include a text box value that is calculated based on forms
programming in report. This textbox does not exist in table nor query. I want
it to be included in the report with other table data...
How?

--
Message posted via http://www.accessmonster.com

  #2  
Old May 7th, 2007, 11:13 PM posted to microsoft.public.access.reports
Carl Rapson
external usenet poster
 
Posts: 517
Default Include control that are only in forms

You can do programming in reports too. Add an unbound textbox control to the
report and in the Format event of the section that contains the control add
the code to calculate the value.

Carl Rapson

"EMILYTAN via AccessMonster.com" u33296@uwe wrote in message
news:71ce91c322e52@uwe...
I want to include a text box value that is calculated based on forms
programming in report. This textbox does not exist in table nor query. I
want
it to be included in the report with other table data...
How?

--
Message posted via http://www.accessmonster.com



  #3  
Old May 8th, 2007, 01:58 AM posted to microsoft.public.access.reports
EMILYTAN via AccessMonster.com
external usenet poster
 
Posts: 47
Default Include control that are only in forms

I tried already. It simply can't work...


Carl Rapson wrote:
You can do programming in reports too. Add an unbound textbox control to the
report and in the Format event of the section that contains the control add
the code to calculate the value.

Carl Rapson

I want to include a text box value that is calculated based on forms
programming in report. This textbox does not exist in table nor query. I
want
it to be included in the report with other table data...
How?


--
Message posted via http://www.accessmonster.com

  #4  
Old May 8th, 2007, 05:10 PM posted to microsoft.public.access.reports
Carl Rapson
external usenet poster
 
Posts: 517
Default Include control that are only in forms

What is the code for the value you are calculating, and what problem do you
have when you try to put it on the report? If the report is based on a
query, you could add the calculation to the query as a calculated field and
place it on the report that way.

Carl Rapson

"EMILYTAN via AccessMonster.com" u33296@uwe wrote in message
news:71d86387a691e@uwe...
I tried already. It simply can't work...


Carl Rapson wrote:
You can do programming in reports too. Add an unbound textbox control to
the
report and in the Format event of the section that contains the control
add
the code to calculate the value.

Carl Rapson

I want to include a text box value that is calculated based on forms
programming in report. This textbox does not exist in table nor query. I
want
it to be included in the report with other table data...
How?


--
Message posted via http://www.accessmonster.com



  #5  
Old May 9th, 2007, 01:16 AM posted to microsoft.public.access.reports
EMILYTAN via AccessMonster.com
external usenet poster
 
Posts: 47
Default Include control that are only in forms

Thanks for your solution. I can get it done already...
Carl Rapson wrote:
What is the code for the value you are calculating, and what problem do you
have when you try to put it on the report? If the report is based on a
query, you could add the calculation to the query as a calculated field and
place it on the report that way.

Carl Rapson

I tried already. It simply can't work...

[quoted text clipped - 11 lines]
it to be included in the report with other table data...
How?


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/200705/1

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:05 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.