Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / December 2007

Tip: Looking for answers? Try searching our database.

Calculation

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Khurram Naseem - 15 Dec 2007 08:50 GMT
I design one form with TAB control I place sub form in tab control, the Sub
form is base on datasheet view, I add one unbound control text field which
enabled property set to NO, this control source property base on two other
column value like I have two bound(Table) fields I want to show the addition
of this field at runtime in this unbound field, every thing is perfect here
but I also want SUM of this unbound feild in datasheet view, I try many
things but It did not show sum of this unbound field, only Count function
work(Total Row option in 2007) for this field even I set format to general
number. how I achieve this functionality.

Thank you
Mark A. Sam - 15 Dec 2007 20:05 GMT
Khurram,

Do  you want to add the two bound textboxes in the unbound textbox?  If yes,
then in the ControlSource property type in "=[txtBox1] + [txtBox2]" Without
Quotes"" and using your bound textbox names.

God Bless,

Mark A. Sam

>I design one form with TAB control I place sub form in tab control, the Sub
> form is base on datasheet view, I add one unbound control text field which
[quoted text clipped - 9 lines]
>
> Thank you
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.