My Assistant
Site Message
(Message will auto close in 2 seconds)
  |
 Adding Calculated Control To Access Form
|
|
 Apr 3 2012, 09:13 AM
Post
#1
|
|
|
UtterAccess Member Posts: 32  |
I need to add text box with total members . I can't get the right expression in the builder
I have tryed =count ([ totalMemebrs]) And =([tblprogram]![totalmemebrs] I keep getting error |
 |
 
|
|
Apr 3 2012, 09:15 AM
Post
#2
|
|
|
UtterAccess VIP Posts: 8,140 From: CT |
to try and offer a good solution, could you explain what you are trying to do without the code?
example: total members plus the totalmembers for a program ? |
|
|
|
|
Apr 3 2012, 09:21 AM
Post
#3
|
|
|
UtterAccess Ruler Posts: 1,090 |
If totalmemebrs field is not on your form's recordset, then you will not get what you want.
Instead. =DSum("totalmemebrs", "tblprogram") or =DCount("totalmemebrs", "tblprogram") |
|
|
|
|
Apr 3 2012, 01:20 PM
Post
#4
|
|
|
UtterAccess Member Posts: 32 |
I did that now it blank on and off it's something I have done. Please any more solutions
|
|
|
|
|
Apr 3 2012, 01:33 PM
Post
#5
|
|
|
UtterAccess Ruler Posts: 2,666 |
QUOTE (Tunya @ Apr 3 2012, 02:20 PM)  I did that now it blank on and off it's something I have done. Please any more solutions You did what now? Your original post QUOTE (Tunya @ Apr 3 2012, 02:20 PM) =count ([ totalMemebrs]) And =([tblprogram]![totalmemebrs] doesn't even make enough sense for anyone here to guess exactly what you're trying to do! What are you trying to do with "And =([tblprogram]![totalmemebrs]" Also, is totalmemebrs a typo on your post here, or a typo in your actual code, or is it the way the Field name is actually spelled? Misspelling a Field name doesn't matter, as long as you always use the misspelling when writing code. You simply have to explain, in clear language, what you're attempting to do, in order for us to help you! Linq ;0)> This post has been edited by missinglinq: Apr 3 2012, 01:44 PM |
|
|
|
|
Apr 3 2012, 02:09 PM
Post
#6
|
|
|
UtterAccess Member Posts: 32 |
On access form I need add a calculated control for Total of members
|
|
|
|
|
Apr 3 2012, 05:01 PM
Post
#7
|
|
|
UtterAccess Member Posts: 32 |
The calculated control display the total number of records that appear in the subform. Set the calculated control's ControlTip Text property to Total number of memberss in this program
Attached File(s)
|
|
|
|
|
Apr 3 2012, 07:01 PM
Post
#8
|
|
|
UtterAccess Member Posts: 32 |
i Resubmit it again i hope you understand it
|
|
|
|
 |
|
Jump To Forum:
|
Go to Top · Lo-Fi Version | Time is now: 24th May 2013 - 12:48 PM |