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 » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

exact syntax



 
 
Thread Tools Display Modes
  #1  
Old January 3rd, 2010, 02:29 PM posted to microsoft.public.access.forms
Revned
external usenet poster
 
Posts: 48
Default exact syntax

Hi,

I want to know what is the proper syntax if i am going to display a
summation result to mainform from a subform???

Thank you


  #2  
Old January 3rd, 2010, 03:48 PM posted to microsoft.public.access.forms
Al Campagna[_2_]
external usenet poster
 
Posts: 1,462
Default exact syntax

Revned,
You want the "exact" code, but you haven't given us
any information about your form, your subform, or your
totals field in that subform?

I'll use example object names... use your own in your code.

= Forms!MainFormName!SubFormName.Form!SubTotal
--
hth
Al Campagna
Microsoft Access MVP 2006-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

"Revned" wrote in message
news
Hi,

I want to know what is the proper syntax if i am going to display a
summation result to mainform from a subform???

Thank you




  #3  
Old January 4th, 2010, 05:05 AM posted to microsoft.public.access.forms
Revned
external usenet poster
 
Posts: 48
Default exact syntax

thank you for your time Al Campagna I appreciate it,

sorry for not elaborating my question so far, this is it what i have done now
i have my mainform frmOrders with a subform [qryOrders subform]
in my subform i have Amount field name

I make a summation for this field Amount under Form Footer =sum([Amount])
with a control name txtTotal
now how would I write my code to display the result in the mainform?? i try
using the one you have given me but no result is being display..

please can you help me again in figuring it out...

thanks again....

"Al Campagna" wrote:

Revned,
You want the "exact" code, but you haven't given us
any information about your form, your subform, or your
totals field in that subform?

I'll use example object names... use your own in your code.

= Forms!MainFormName!SubFormName.Form!SubTotal
--
hth
Al Campagna
Microsoft Access MVP 2006-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

"Revned" wrote in message
news
Hi,

I want to know what is the proper syntax if i am going to display a
summation result to mainform from a subform???

Thank you




.

  #4  
Old January 4th, 2010, 03:20 PM posted to microsoft.public.access.forms
Al Campagna[_2_]
external usenet poster
 
Posts: 1,462
Default exact syntax

Revned,
Given a main form named [frmOrders], and a subform named
[qryOrders Subform], and a control in that subform called [txtTotal]...

Place an unbound text control on the main form, and give it a
Control Source of...
= [Forms]![frmOrders]![qryOrders Subform].Form![txtTotal]

Note: Try to avoid names with spaces, and also try to be a bit
more descriptive with those names. It will make your coding more
efficient, and clearer. Ex. txtTotal might be txtTotalAmount, or
txtTotalOrderAmount
Also, use standard notation for your object names.
Ex. [qryOrders Subform] should be frmOrdersSubform. (without
spaces, no bracketing required)
--
hth
Al Campagna
Microsoft Access MVP 2006-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

"Revned" wrote in message
...
thank you for your time Al Campagna I appreciate it,

sorry for not elaborating my question so far, this is it what i have done
now
i have my mainform frmOrders with a subform [qryOrders subform]
in my subform i have Amount field name

I make a summation for this field Amount under Form Footer =sum([Amount])
with a control name txtTotal
now how would I write my code to display the result in the mainform?? i
try
using the one you have given me but no result is being display..

please can you help me again in figuring it out...

thanks again....

"Al Campagna" wrote:

Revned,
You want the "exact" code, but you haven't given us
any information about your form, your subform, or your
totals field in that subform?

I'll use example object names... use your own in your code.

= Forms!MainFormName!SubFormName.Form!SubTotal
--
hth
Al Campagna
Microsoft Access MVP 2006-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your
life."

"Revned" wrote in message
news
Hi,

I want to know what is the proper syntax if i am going to display a
summation result to mainform from a subform???

Thank you




.



  #5  
Old January 5th, 2010, 07:40 AM posted to microsoft.public.access.forms
Revned
external usenet poster
 
Posts: 48
Default exact syntax

Thank you very much, I take note of that advise...thanks again I really
appreciate your time

"Al Campagna" wrote:

Revned,
Given a main form named [frmOrders], and a subform named
[qryOrders Subform], and a control in that subform called [txtTotal]...

Place an unbound text control on the main form, and give it a
Control Source of...
= [Forms]![frmOrders]![qryOrders Subform].Form![txtTotal]

Note: Try to avoid names with spaces, and also try to be a bit
more descriptive with those names. It will make your coding more
efficient, and clearer. Ex. txtTotal might be txtTotalAmount, or
txtTotalOrderAmount
Also, use standard notation for your object names.
Ex. [qryOrders Subform] should be frmOrdersSubform. (without
spaces, no bracketing required)
--
hth
Al Campagna
Microsoft Access MVP 2006-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

"Revned" wrote in message
...
thank you for your time Al Campagna I appreciate it,

sorry for not elaborating my question so far, this is it what i have done
now
i have my mainform frmOrders with a subform [qryOrders subform]
in my subform i have Amount field name

I make a summation for this field Amount under Form Footer =sum([Amount])
with a control name txtTotal
now how would I write my code to display the result in the mainform?? i
try
using the one you have given me but no result is being display..

please can you help me again in figuring it out...

thanks again....

"Al Campagna" wrote:

Revned,
You want the "exact" code, but you haven't given us
any information about your form, your subform, or your
totals field in that subform?

I'll use example object names... use your own in your code.

= Forms!MainFormName!SubFormName.Form!SubTotal
--
hth
Al Campagna
Microsoft Access MVP 2006-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your
life."

"Revned" wrote in message
news Hi,

I want to know what is the proper syntax if i am going to display a
summation result to mainform from a subform???

Thank you




.



.

  #6  
Old January 5th, 2010, 02:43 PM posted to microsoft.public.access.forms
Al Campagna[_2_]
external usenet poster
 
Posts: 1,462
Default exact syntax

Revned,
Well, thanks, but... we really would like to know if that worked
for you...
--
hth
Al Campagna
Microsoft Access MVP 2006-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

"Revned" wrote in message
...
Thank you very much, I take note of that advise...thanks again I really
appreciate your time

"Al Campagna" wrote:

Revned,
Given a main form named [frmOrders], and a subform named
[qryOrders Subform], and a control in that subform called [txtTotal]...

Place an unbound text control on the main form, and give it a
Control Source of...
= [Forms]![frmOrders]![qryOrders Subform].Form![txtTotal]

Note: Try to avoid names with spaces, and also try to be a bit
more descriptive with those names. It will make your coding more
efficient, and clearer. Ex. txtTotal might be txtTotalAmount, or
txtTotalOrderAmount
Also, use standard notation for your object names.
Ex. [qryOrders Subform] should be frmOrdersSubform. (without
spaces, no bracketing required)
--
hth
Al Campagna
Microsoft Access MVP 2006-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your
life."

"Revned" wrote in message
...
thank you for your time Al Campagna I appreciate it,

sorry for not elaborating my question so far, this is it what i have
done
now
i have my mainform frmOrders with a subform [qryOrders subform]
in my subform i have Amount field name

I make a summation for this field Amount under Form Footer
=sum([Amount])
with a control name txtTotal
now how would I write my code to display the result in the mainform?? i
try
using the one you have given me but no result is being display..

please can you help me again in figuring it out...

thanks again....

"Al Campagna" wrote:

Revned,
You want the "exact" code, but you haven't given us
any information about your form, your subform, or your
totals field in that subform?

I'll use example object names... use your own in your code.

= Forms!MainFormName!SubFormName.Form!SubTotal
--
hth
Al Campagna
Microsoft Access MVP 2006-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your
life."

"Revned" wrote in message
news Hi,

I want to know what is the proper syntax if i am going to display a
summation result to mainform from a subform???

Thank you




.



.



 




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 11:15 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.