#Name? - Arrrggghhh - Won't Count [Text Field - Access 2007] 2

[Maillme]

Hi there,

I'm trying to get a simple count of records that are displayed in my list box - these records query 3 tables for their data (data displays correctly).

I have the following code on the control source property of my text box (participant_count):

=DCount([“attendance_id”],[“tbl_attendances”],[“session_id]=[”] & [Forms]![frm_session_check_in]![cmbsessions].[Value])

My text field only displays:

#Name?

 

[Maillme]

sorry, my text box is actually called:

participant_number

Neil

 

[GingerR]

=DCount("attendance_id","tbl_attendances","session_id=" & [Forms]![frm_session_check_in]![cmbsessions])

get rid of all the square brackets. they are in the wrong places. if you need them at all, they would go inside the quotes.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[Maillme]

Hi Ginger,

thanks for the response - unfortunatelly im now getting the following error appearing in my text box:

#Error

- any ideas?

thanks again,
Neil

 

[GingerR]

if you put in a number vs. the form reference, does it work?

=DCount("attendance_id","tbl_attendances","session_id=7")

make sure instead of the 7, you put in a valid Session_ID.
are the field names spelled correctly?
is the table name correct?

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[GKChesterton]

[blue][tt]#Error[/tt][/blue] is a wonderfully generic indicator. You need to isolate elements to find the trouble maker.

Move the DCount function to a query instead of a form and try to make it work there.

The form reference [blue][tt][Forms]![frm_session_check_in]![cmbsessions][/tt][/blue] is bound to be hazardous. Substitute in a number. If that works, then perhaps the form reference is off. But the problem could be elsewhere, for example with the comparison string (e.g., congruent data types, appropriate comparison operator).

[purple]If we knew what it was we were doing, it would not be called
research [blue]database development[/blue], would it? [tab]-- Albert Einstein[/purple]​

 

[TheAceMan1]

How are ya Maillme . . .

I'm confused! You say

[blue]I'm trying to get a simple count of records that are displayed in my list box ...[/blue]

Yet your looking at a table to thru [blue]DCount[/blue] to get your answer!

To get the number of records displayed in a listbox I'd use the following

[blue]= [[purple][B][I]YourListboxName[/I][/B][/purple]].[ListCount][/blue]

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[Maillme]

Hi Aceman,

I used your code - which gets rid of my errors, but unfortunately does not display a value (blank txt box)

any idea why?

many thanks,
Neil

 

[dhookom]

The suggestion works for me with the list box row source returning over 15,000 records (as a test).

Duane
Hook'D on Access
MS Access MVP

 

[GKChesterton]

Maillme, i suggest you post your code.

[purple]If we knew what it was we were doing, it would not be called
research [blue]database development[/blue], would it? [tab]-- Albert Einstein[/purple]​

 

[TheAceMan1]

... and where are you placing the code?

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[TheAceMan1]

[blue]?[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[GKChesterton]

A black hole took him. That explains the expanding blankness! Thanks tho for that great reminder, the ListCount property.

[purple]If we knew what it was we were doing, it would not be called
research [blue]database development[/blue], would it? [tab]-- Albert Einstein[/purple]​

 

[kjv1611]

Scary - I couldn't imagine being eaten alive by a black hole.


--

"If to err is human, then I must be some kind of human!" -Me

 

[GKChesterton]

Then never use:

Me.BlackHole(acComplete) = True

 

[Maillme]

Hi All,

sorry for delay. Internet problems.

My code is on the Control Source of the text box and is as follows:

=[session_list].[ListCount]

many thanks,
Neil

 

[PHV]

Create a function like this:

Function getParticipantCount()
getParticipantCount = Me![session_list].ListCount
End Function

And now the ControlSource:
= getParticipantCount()

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886