Re: 'Plus One' Button on Form

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Sorry, just an extra bit of info. As it stands i have the table that stores
the data and i have a simple form that i can add new records to for example:

Payments 5
Receipts 5 etc

This then saves automatically in the table. I am just looking for a way that
means they dont have to manually enter a total, like 5, but can add to it
throughout the day, adding one each time as they are meant to record their
actions as they go.


"becky250" wrote:

Im not sure what you are asking me now. I would just like a form that brings
up a new record whereby all the values are at 0 and then something to
potentially add one to the zero values (but like a counter so it would go,
click one: 1, click twice: 2). Sort of like =A2+1 on an Excel Spread***. So
if it was:

Payment 0
Receipts 0
Rpays 0

and then something that could make those values potentially increase to
different values via a button for each heading.

Basically I have been asked to make a checklist which was originally
manually done into an easily accessible database in terms of adding and
storing the information. Furthermore something that is simple to work as most
users will not have used Access before. Also they need to be able to keep
Access open throughout the day and add to their record at different times. It
would just be one record per user per day.

Regards


"John W. Vinson" wrote:

On Thu, 18 Jun 2009 15:26:01 -0700, becky250
<becky250@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Hey John,

Dont get me wrong, of course there are tables in my DB and this is where all
the records/headings etc are stored but i need to be able to input the new
data via the form (i.e so it is easy/user-friendly) and hopefully through a
button of some sort so they can add as they go along (like click once, do
another task, click again). This information is obviously then all stored in
the tables. The reason I was concentrating more on the form side of things is
that i dont have much data to begin with in the tables aside from the
headings as the data needs to be inputted by the users (although I can use
fake numbers for testing). I was thinking of making a query for the 'plus
one' and then a macro to run the query when the button was pressed, but my
Access skills arent quite up to scratch.

Hope this provides a better explanation and thanks for the reply.

Not really!

What value do you want to increment? How does the user specify which record
contains that value? What is it incremented TO? If you're incrementing a
"total", is it really a total (which presumably is a sum of existing values
and therefore cannot/should not be editable)?
--

John W. Vinson [MVP]

.

Quantcast