Count Button Clicks

[jtodd]

Hi , simple one , just need to count how many times and when a button is clicked on a form
IE When the user clicks a button on the form it writes a record to a table
Click
Date
Time

Seems quite simple but has got me foxed.

 

[My Aswer Is This]

You need to explain where exactly you want this data stored.
All you said was clicks a button on a Form. Do you mean Userform?
It writes a record to a Table
Where on a Table?

 

[jtodd]

You need to explain where exactly you want this data stored.
All you said was clicks a button on a Form. Do you mean Userform?
It writes a record to a Table
Where on a Table?

Sorry I explained that very badly - what I need is this ,

I have a form "frm_ordno" and a button "viewreport" and a table "countrpt"

the table fields are "count" "time" and "date" with "count" I am guesing would be an autonumber?

What I would like is when the user presses the button to view the report it writes a record to the countrpt table thus creating a record of how many times and when the report was accessed .

I hope this makes it clearer . I have some knowledge of VBA but am definately a beginer.

Any help would be greatly appreciated.

 

[Joe4]

All you said was clicks a button on a Form. Do you mean Userform?

My Aswer Is This,
I think you missed the fact that you are in the Access forum again, not the Excel forum. Forms are pretty standard thing in Access...

jtodd,

So, you have a table named "countrpt" that has the fields "count", "time", and "date"?
Is the form a Single Record form, or a Continuous form?
Does clicking the button add a new record to your table, or just update an existing record on a table?
Note that in updating the count, you would be updating the "count" record on a particular record, specifically the record that you are currently on.
If you just want a total count, you probably need a separate one-record table that tracks that, and we would need to update that.

Also note that you would NOT want your "count" field to be an Autonumber field. The Autonumber field is not updateable. It is automatically created whenever a new record is added. You probably would want to use something like a Long Integer.

 

[My Aswer Is This]

Your correct my mistake.

My Aswer Is This,
I think you missed the fact that you are in the Access forum again, not the Excel forum. Forms are pretty standard thing in Access...

jtodd,

So, you have a table named "countrpt" that has the fields "count", "time", and "date"?
Is the form a Single Record form, or a Continuous form?
Does clicking the button add a new record to your table, or just update an existing record on a table?
Note that in updating the count, you would be updating the "count" record on a particular record, specifically the record that you are currently on.
If you just want a total count, you probably need a separate one-record table that tracks that, and we would need to update that.

Also note that you would NOT want your "count" field to be an Autonumber field. The Autonumber field is not updateable. It is automatically created whenever a new record is added. You probably would want to use something like a Long Integer.

 

[Micron]

If you want to add a record about a button click each time it is clicked, run an append query as part of the click event and write whatever details you need.

the table fields are "count" "time" and "date" with "count"

You should NOT have fields with these names.
Suggest you read Microsoft Access tips: Problem names and reserved words in Access and MS Access Naming Conventions - Access World Forums