recordssetClone.recordcount

[Guest]

Let me preface this by saying I am not very savy in Access. Someone
crateated an Access database for me in 2000. It has worked well for me until
we recently upgraded to office2003. When we converted, a page count field no
longer worked correctly. It gives the result "#Name?". I went into the form
in design mode and in that field it shows "=RecordsetClone.RecordCount". Is
there something about that statment that worked in office 2000 that no longer
works in office 2003. The result appears when I do a querry and the page
display is record 1 of "#Name?" and it should show the count of records found
in the querry. Does anyone have any suggestions on how I can resolve this?

 

[Guest]

It should work in Access 2003, I just copied your string to a form and it
worked

One question, did you type the string with double quote or you copied it
from the text box?

It shold say
=[RecordsetClone].[RecordCount]

 

[Guest]

Thanks so much for looking into this for me Ofer Cohen. The string was in
the format you noted below. Actually I didn't type it in that wasy but Acess
converted it for me automatically. Just in case, I tried typing it in that
way and it didn't make a difference. I am still getting a result of "#Name?"

It is very frustrating!...lol

It should work in Access 2003, I just copied your string to a form and it
worked

One question, did you type the string with double quote or you copied it
from the text box?

It shold say
=[RecordsetClone].[RecordCount]

--
Good Luck
BS"D

Let me preface this by saying I am not very savy in Access. Someone
crateated an Access database for me in 2000. It has worked well for me until
we recently upgraded to office2003. When we converted, a page count field no
longer worked correctly. It gives the result "#Name?". I went into the form
in design mode and in that field it shows "=RecordsetClone.RecordCount". Is
there something about that statment that worked in office 2000 that no longer
works in office 2003. The result appears when I do a querry and the page
display is record 1 of "#Name?" and it should show the count of records found
in the querry. Does anyone have any suggestions on how I can resolve this?

 

[Guest]

There are two ways to display the count of records in the query
1. If the form is ounded to this query then yo can use
=Count(*)

2. Or, to get amount of records in a query
=DCount("*","QueryName")

Mybe one of this methods will get you the count of records

--
Good Luck
BS"D

Thanks so much for looking into this for me Ofer Cohen. The string was in
the format you noted below. Actually I didn't type it in that wasy but Acess
converted it for me automatically. Just in case, I tried typing it in that
way and it didn't make a difference. I am still getting a result of "#Name?"

It is very frustrating!...lol

It should work in Access 2003, I just copied your string to a form and it
worked

One question, did you type the string with double quote or you copied it
from the text box?

It shold say
=[RecordsetClone].[RecordCount]

--
Good Luck
BS"D

Let me preface this by saying I am not very savy in Access. Someone
crateated an Access database for me in 2000. It has worked well for me until
we recently upgraded to office2003. When we converted, a page count field no
longer worked correctly. It gives the result "#Name?". I went into the form
in design mode and in that field it shows "=RecordsetClone.RecordCount". Is
there something about that statment that worked in office 2000 that no longer
works in office 2003. The result appears when I do a querry and the page
display is record 1 of "#Name?" and it should show the count of records found
in the querry. Does anyone have any suggestions on how I can resolve this?

 

[Guest]

THANK YOU SO MUCH!!!!!!!!!!!!!!!!!!!!!

The =Count(*) appears to have solved the problem. I really appreciate your
help on this matter. I have been going crazy since we upgraded trying to fix
it and getting no where becuae I have no idea what I'm doing.

Thanks again!!!!!

There are two ways to display the count of records in the query
1. If the form is ounded to this query then yo can use
=Count(*)

2. Or, to get amount of records in a query
=DCount("*","QueryName")

Mybe one of this methods will get you the count of records

--
Good Luck
BS"D

Thanks so much for looking into this for me Ofer Cohen. The string was in
the format you noted below. Actually I didn't type it in that wasy but Acess
converted it for me automatically. Just in case, I tried typing it in that
way and it didn't make a difference. I am still getting a result of "#Name?"

It is very frustrating!...lol

It should work in Access 2003, I just copied your string to a form and it
worked

One question, did you type the string with double quote or you copied it
from the text box?

It shold say
=[RecordsetClone].[RecordCount]

--
Good Luck
BS"D


:

Let me preface this by saying I am not very savy in Access. Someone
crateated an Access database for me in 2000. It has worked well for me until
we recently upgraded to office2003. When we converted, a page count field no
longer worked correctly. It gives the result "#Name?". I went into the form
in design mode and in that field it shows "=RecordsetClone.RecordCount". Is
there something about that statment that worked in office 2000 that no longer
works in office 2003. The result appears when I do a querry and the page
display is record 1 of "#Name?" and it should show the count of records found
in the querry. Does anyone have any suggestions on how I can resolve this?