Vba to increment counter each time a record is deleted or added to Database

[sintek]

Hi All

I sincerely hope someone can assist. I have a Database Sample attached. I want to find out if it is possible that each time I add a New client, a counter can be incremented for current month i.e. If I add a new client today, I want Cell G5 to become 1....If I add another new client tomorrow, Cell G5 must become 2.

Same goes for if I delete a client then Cell G7 must become 1 etc.

Is something like this possible with excel.

[sintek]

Hi All

I managed to figure out the first part....incrementing by one. However, how can I check to see what date it is and add it to that particular month column.

Here is current code:

Please Login or Register  to view this content.

[sintek]

Nope, just noticed that F9 = "" so is always going to be less than F2
How can I get on auto_open the total cells with text to be populated into a cell without it changing when I make changes to dataform.

[sintek]

Something like this ?

Please Login or Register  to view this content.

[sintek]

K, well got that figured out finally:

Please Login or Register  to view this content.

[sintek]

Right, now to get the date part sorted out. I need to check current date and edit cell under that Month
Have got this so far but does not work.

Please Login or Register  to view this content.

[sintek]

I need to get Month Name out of this code:

Please Login or Register  to view this content.

[millz]

I need to get Month Name out of this code:

Please Login or Register  to view this content.

[sintek]

Hi All

Thanks for your views. Think I got it figured out.

Please Login or Register  to view this content.