Re: Count and display entries


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...


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:ml8np41fdkthe84ssseu5uocjvgsara5a7@xxxxxxxxxx
On Tue, 17 Feb 2009 20:24:10 -0800, "Charles L. Phillips"
<tptbusines_2005@xxxxxxxxxxx> wrote:

Hello,

I've created a data entry form with the following fields:

1. Address

2. City

3. State

4. Zip Code

5. Number of Entries

I want the form to count and display the number of entries of each
individual entry, and display the number in the "Number of Entries" field.

Can/will ANYBODY point me to an example/sample of this nature???



Thank you,

First off... you're starting in the middle. Data is not stored in forms,
it's
stored in Tables; a Form is *just a window*, a tool to let you edit data
in
tables.

Secondly, you should absolutely NOT store "Number of Entries" anywhere.
That
information will change every time you add or delete a record. It can be
(and
will be) calculated and displayed automatically.

It's not clear what you mean by "number of entries of each individual
entry" -
an entry is one thing; what's the number of entries of one entry???

You might want to see some of these sites for some introduction to how
Access
can be most productively used:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials
--

John W. Vinson [MVP]


.

Relevant Pages

  • Re: How to create a window showing building block organiser in 2007
    ... doesn't display a "preview". ... show any formatting that's included in the entry; ... On the plus side, if the entries are all text, ... autotext at the location of the selection. ...
    (microsoft.public.word.vba.general)
  • Re: Output to txt:
    ... Then to follow, are all the entries ... : column entry. ... To get around this for now, I format the output as html ... Word stores a file with embedded code to display it as it is seen on screen ...
    (microsoft.public.scripting.vbscript)
  • How do I save address book entires in last name, first name order?
    ... I specify the file as and display as fields in last name, ... but when I save the entry, the entry appears in the address book list in ... My goal is to have all my entries in last name, ...
    (microsoft.public.outlook.contacts)
  • Re: Threading...
    ... that entry. ... I wanted to allow multiple entries to be displayed together. ... I wanted to encapsulate the display of the form within a class (it is ... as a workaround. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Windows Mail (Vista) taking a long time to display Contacts when sending email
    ... He has not added/deleted any entries since the last time that it ... opened - If he opens the contacts list explicitly from the Windows ... but 10 seconds to display the list when it's ... exporting them as nothing will change with a simple move though it might ...
    (uk.comp.misc)
Quantcast