Hi John,
Can I use DCOUNT for this on my form? I've created a text box on my form
with the following ControlSOurce:
=DCount("[Skidid]","SHIPPINGDETAIL","[SO#] = 'forms!shippingdetail!so#'")
What this is supposed to do is count the number of "Skidid" entries in the
"ShippingDetail" table using the "SO#" from my "Shippingdetail" form as the
criteria.
Looks good on paper, but doesn't seem to work.
-----Original Message-----
From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of John Viescas
Sent: Monday, October 31, 2005 6:41 PM
To: ms_access@yahoogroups.com
Subject: RE: [ms_access] AutoNumber for Subform
Mike-
This is easy to do in a report - simply add a text box with Control Source
set to =1 and the Running Sum property set to Over Group or Over All. If
you actually want to generate and save this number in each new record,
you'll have to write some code in the form's Before Update event to find the
previous high number for the current sales order, add 1, and save it. If
these records have some sort of sequence, you can also generate the number
by using a subquery to count the number of rows that have a lower sequence.
If that doesn't help, need more details...
John Viescas, author
"Building Microsoft Access Applications"
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
-----Original Message-----
From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Mike Bisson
Sent: Monday, October 31, 2005 9:32 AM
To: ms_access@yahoogroups.com
Subject: [ms_access] AutoNumber for Subform
Hi All,
I have a subform that I would like to display a "record Counter" on
beginning with "1". This number doesn't need to be stored anywhere, it's
strictly for informational purposes.
The scenario is this:
The main form has fields for "Sales Order Number" and "Ship Date". These
are linked to the subform which contains an additional field called "Pallet
ID". The purpose is to have a counter that would show on the subform so
that the shipping folks can keep track of how many pallets they are loading
on a truck. The subform is in "Grid" view.
Any suggestions??? Idea's???
As always, any help is greatly appreciated :)
==================================
Mike Bisson
Manager of IT & Logistics
Carthuplas, Inc.
V: 207-985-4972 x658 F: 207-985-2105
[EMAIL PROTECTED] http://www.carthuplas.com
------------------------ Yahoo! Groups Sponsor --------------------~--> Get
Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life.
http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/q7folB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
Yahoo! Groups Links
------------------------ Yahoo! Groups Sponsor --------------------~-->
Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life.
http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/q7folB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
