count on form list

Hello

Hiw can I make count number to calculate how many post raw it is be on the
form list?
So the resoult sould looks:
No
1
2
3
4
5
6
7
8

Thanks

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...c.access.forms

Take a look here my guess is that this is what you are looking for:

http://www.allenbrowne.com/casu-10.html
--
Maurice Ausum


"Highlight between 3 fields" wrote:

Hello

Hiw can I make count number to calculate how many post raw it is be on the
form list?
So the resoult sould looks:
No
1
2
3
4
5
6
7
8

Thanks

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...c.access.forms

Hello

Thank you for your replay, but this code not give counter result that show
1
2
3
4
so on

I use Access 2007
Best regards

Hi again

Any one have idea to get count nomber that will work on Access 2007

Thanks

On Wed, 17 Mar 2010 08:01:01 -0700, Highlight between 3 fields
wrote:

Hi again

Any one have idea to get count nomber that will work on Access 2007

Thanks

Please explain the context; what are you counting, where, and what problem are
you having?

YOU can see your computer. We cannot!
--

John W. Vinson [MVP]

Thank you for your comment

I have Form with list post and filter for searching by textbox.
The scour for this form is query.
I want make count number to know how many raw are on this post list and show
with every post a number (witout number, I can't know how many raw of post
on the list)
I create a textbox and insert on it this code:

=oppp(IIF(true;1;0))

And create a modul that looks as this:

Option Compare Database
Dim aaa As Integer

Function oppp(sss) As Integer

If sss = 1 Then
aaa = aaa + 1
ElseIf sss = 0 Then
aaa = 0
End If
oppp = aaa

End Function


The problem is number work good then it starts just step increase when I
move the list up & down. Even if I close the form and restart it or update
the form, just larger number.

Is there better idea to get the counter on form on MS Access 2007 ?
So every time I make search by filter, so it show the count number like

1
2
3
4

so on with every search it will looks like it. The number have nothing with
post, just to show how many raw on the list.

Here is example of what I mean that have above code:
http://home.swipnet.se/georgedesign/db6.mdb


Thanks a lot

Hello Mr John W.

I found your replay to other people that have near to my question.
I test that you wrote and it work.

Thank you very much.

Hi Mr John W.

Your code make a sort by [ID] then it work ok, but I have the sort by [Item]

=DCount("*", "queryname", "[ID] = " & [ID])

So now it looks the number as:
5
100
14
21
25
50
So on.

Can you please make it to sort by [Item] name?

Thanks a lot

On Sun, 21 Mar 2010 23:55:01 -0700, Highlight between 3 fields
wrote:

Hi Mr John W.

Your code make a sort by [ID] then it work ok, but I have the sort by [Item]

=DCount("*", "queryname", "[ID] = " & [ID])

So now it looks the number as:
5
100
14
21
25
50
So on.

Can you please make it to sort by [Item] name?

Thanks a lot

I'm sorry, but I have no idea what you're talking about. You didn't ask for a
sort, and I didn't suggest anything to sort.

Please post some more context. The DCount() function counts records. It
doesn't do any sorting and it's not intended to do any sorting! What's the
context?

--

John W. Vinson [MVP]

Hello Mr Johan

Thank you for your replay.
I send you a sample to show you that the number is not correct growing, so
how can I make it correct.
And I still have sort by Item as(a, b, c, d .....
And DIDIDI have not sort and contain code Dcount()

Here is a picture to see:
http://home.swipnet.se/georgedesign/count123456.jpg

Here is MS access sample 2007 sd same of pictu
http://home.swipnet.se/georgedesign/autocount.accdb

Thank you very for your time.