Search results

Dave, What you've said looks to be the solution to a similar problem I have. However, please excuse my ignorance, I've never written these sorts of code before so am not familiar with the syntax etc. I tried to set your code in the OnOpen property of the form. When I opened the code builder, it...

[No message]

Dave, What you've said looks to be the solution to a similar problem I have. However, please excuse my ignorance, I've never written these sorts of code before so am not familiar with the syntax etc. I tried to set your code in the OnOpen property of the form. When I opened the code builder, it...

I have a single row datasheet form, which, when in 'Open' view, displays several hundred records. I want to be able to have these records numbered 1-500 or whatever, in exactly the same way as the navigation bar displays which record number you're up to in the form. Essentially I just want to...

Found the answer Finally found someone else's post regarding a similar thing. Formula is: =Sum(IIf([Choice]="Bob",1,0)) This returns a 1 for everytime the choice is Bob, and a 0 for every time it's NOT Bob. Still find it strange that =count doesn't include an option for this, but this one...

How do you count how many times a specific string of text occurs in a given field within a report? For example, if a database recorded the results of a voting session, and I wanted to count how many people had recorded "Bob" in the "Choice" field, how what format would I use? Whenever I try...