Re: Count and display entries

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hello,
PLEASE, accept my apology for giving a BAD example.
If I entered the address:

218 N. Oak St.
Los Angeles, CA 90012

5 times in the database, I'd like to see how many times I've entered the
address in the database.
I'd like to see that information displayed in/on the form.
I know I can produce that information in a report, I'd like to see the
information displayed in a form view.




Thank you,


Charles L. Phillips


DISCLAIMER: This e-mail and any attachments are intended only for the
individual or company to which it is addressed and may contain information
which is privileged, confidential and prohibited from disclosure or
unauthorized use under applicable law. If you are not the intended
recipient of this e-mail, you are hereby notified that any use,
dissemination, or copying of this e-mail or the information contained in
this e-mail is strictly prohibited by the sender. If you have received this
transmission in error, please return the material received to the sender and
delete all copies from your system. The information provided in this and ALL
messages sent is provided as-is. No warranty is provided or implied. Use at
your own risk. All content on these pages has been gathered and compiled by
Charles L. Phillips.
"John W. Vinson" <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:nphop4l2k3mpqpf2ctsgi0f9e1oh13lrkp@xxxxxxxxxx
On Wed, 18 Feb 2009 08:50:40 -0800, "Charles L. Phillips"
<tptbusines_2005@xxxxxxxxxxx> wrote:


Hello,
"Thank You" for your timely response.
I know you do not store data in forms, and I know forms are used to
display
data.
I know the data stored in tables can be edited or deleted, but what I'm
asking is what I want to see displayed in form view.
If I entered ABC-123, I want to see how many times I entered ABC-123, and
have the number of entries displayed on the form.
"Thank You" for the reference to the websites.
I want to know how my request can be processed...

I'm still confused. ABC-123 does not appear to be an address, or a city,
or a
state, or any of the other fields you depict.

Do you want five different counts, one for each field on the form?
Or is there one field on the form which you're particularly interested in
counting?

The solution will be to have a textbox with a Control Source resembling

=DCount("*", "[TableName]", "[FieldName] = '" & [ControlName] & "'")

YOu would probably need to requery this textbox in the afterupdate event
of
whichever control contains the field you want counted.
--

John W. Vinson [MVP]


.

Relevant Pages

  • RE: Userform to add and update a table
    ... One of the most common scenarios in application development is to display ... the walkthrough illustrates many of the basic ... Access to a server with the Pubs SQL Server sample database. ... Creating the Windows Form. ...
    (microsoft.public.sqlserver.programming)
  • Re: Picture property for Access 2K forms
    ... and it works great...until you look at the database size involved. ... or by simply scaling down the image display in the ... > supported by those filters. ... To associate a graphic file with an OLE Server, ...
    (microsoft.public.access.devtoolkits)
  • Re: adding logged in user to text box
    ... notes part of the database. ... Right now I am able to display the time, ... add the current date, time and user, it will overwrite anything that I have ... the info previously inputted into the textbox, ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Unknown Maiden Name [WAS how-to ruin a perfectly good FGS]
    ... through at the beginning of my database, ... or display your information in the fields you intended for them. ... the names in a manner you didn't intend and the meaning has become ... If my data is on the Internet and people don't understand it, ...
    (soc.genealogy.methods)
  • Re: webviewer background image from filemaker container field
    ... It is not elegant or simple the moment you factor in how a webviewer ... passes the result back to FM to display. ... info out of the schema of the database. ... And the quality of advice in books and formal filemaker education is ...
    (comp.databases.filemaker)