recordssetClone.recordcount

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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]
 
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

Ofer Cohen said:
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


Problem Child said:
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?
 
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


Problem Child said:
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

Ofer Cohen said:
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


Problem Child said:
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?
 
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!!!!!

Ofer Cohen said:
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


Problem Child said:
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

Ofer Cohen said:
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?
 
Back
Top