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.

Running Sum diplayed adjacent to each record in a Subform Detail

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jazflux - 15 Dec 2007 03:38 GMT
Hi:
I want to number services sequentially in a Subform Detail Record, as a
running sum. Like this:

What I have:
Cook
Clean
Go to Town

What I want:
1 Cook
2 Clean
3 Go to Town

I can use Running Sum in the Report, but don't know how to do it on a Form.
Thanks!
Allen Browne - 15 Dec 2007 04:02 GMT
See:
   http://www.lebans.com/rownumber.htm

Signature

Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Hi:
> I want to number services sequentially in a Subform Detail Record, as a
[quoted text clipped - 13 lines]
> Form.
> Thanks!
Jazflux - 15 Dec 2007 04:18 GMT
Thank you very much for the reply; I located and downloaded the file and
viewed it. However I am not sure how to implement it, sorry... Any tips
appreciated!

The RowNumber on your Form Detail is what I want to achieve.

> Hi:
> I want to number services sequentially in a Subform Detail Record, as a
[quoted text clipped - 12 lines]
> I can use Running Sum in the Report, but don't know how to do it on a Form.
> Thanks!
Allen Browne - 15 Dec 2007 15:17 GMT
We can't implement it for you.

Follow the instructions Stephen set up on his web page, and the example in
his file.

Signature

Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Thank you very much for the reply; I located and downloaded the file and
> viewed it. However I am not sure how to implement it, sorry... Any tips
[quoted text clipped - 19 lines]
>> Form.
>> Thanks
Jazflux - 16 Dec 2007 16:17 GMT
I figured it out. I imported the necessary Module into my file and it worked
perfectly. Thank you for this very useful info!

> We can't implement it for you.
>
[quoted text clipped - 24 lines]
> >> Form.
> >> Thanks
 
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.