counter (97)

[teiben]

I have an existing database, in whichi I've been asked to implement a counter, of sorts, which could count a store the number of times the database has been opened (including reports being viewed) , in a month. (I'm using access 97). Can this be done? How would I accomplish this?

 

[Len Boorman]

Not actually tried this but thoughts are:

create a table (tbl_Count) with single field (Useage) of Number type
create single record with value of 0 (zero)

1) Autoexec Macro. (will fire every time database is opened)
calls Update Query
Update query that Updates

tbl_Count.Useage
to
tbl_Count.Useage +1

The autoexec macro will then increare the count each time the database is opened

Probably use a similar approach to the Reports thingy except fire an Update query from whatever is calling report. Have another field in the tbl_Count called Reports Use

I normally group report selection on a single form but there is no problem I think firing the update query on each report selection.

If you want a count on individual report use then you will need a field in the tbl_Count for each report and obviously an update query for each report.

Len

 

[teiben]

Worked like a charm

 

[Len Boorman]

I might try that myself then.

Len