I'd like to say thank you to those who helped me with questions I had on my database. Even though some of you didn't even realize that you helped. Searching the forum yields answers to many questions.

So now that the database is complete, I'd like opinions. I'm attaching it as a zip file.
A couple of notes. I forgot to remove the database password so it's "fornax".
Also, being that I work for a very large hospital I cleared out my table and removed the logos.
I hid the menus and disabled the F11 key, but there is a hidden button on the far right of the footer. A double-click will restore the menus. Also try clicking on the logo--or it's place holder.

Searching the forum yields answers to many questions.

Wow! Someone who actually used the search feature! If only more people did. Thanks for doing that.

- on the enter/view results form it looks like some of the status bar text does not match with the field in question.
- you might ask to confirm closing the database.
- you have a good warning about starting a new year. you ask if this is February. that's good as a reminder, but are you also confirming that yourself and cancelling if it isn't? make NO the default selection.
- some of the colors are a bit hard on the eyes (report menu buttons).
- nice.

- on the enter/view results form it looks like some of the status bar text does not match with the field in question.
- you might ask to confirm closing the database.
- you have a good warning about starting a new year. you ask if this is February. that's good as a reminder, but are you also confirming that yourself and cancelling if it isn't? make NO the default selection.
- some of the colors are a bit hard on the eyes (report menu buttons).
- nice.

1 I must admit that I sometime overlook things like that.
2 same as 1 and a good idea. It's going in
3 making no the default is a good idea. As for checking to see if it's really february....I think I can figure that one out. Or what if I went a new route and removed the button? In February there would be an automated archive.
4 you don't like my colors? I had my fun with the color button module. The colored buttons are coming out.
5 thanks.

automated archive sounds good if possible.

i almost didn't mention the colors because i thought you probably spent some time with that. some (most?) people will have no second thoughts about it. it could be me. :)

Not so much time. One of the things I always wanted in access was colored buttons. After a search I found a thread where a module was mentioned.
It was nice to play with, and I read the code--so it was a learning experience as well.
But the button text can't be edited and I have to keep remaking buttons.
As I said, it was fun but I'm over it now.

Okay,
I added an 'are you sure' dialog to the exit button
I am going to change the colored buttons for the standard buttons.
I also took care of the Year end routine. When the database starts it does the following:
reads the year from a label in one of my reports
compares that year with the current year
if the year on the report is less than the current year AND the current month is February a nag screen pops up giving the user the chance to press go to run the year end routine.

It's funny, I always have a clear idea of what I want but trying to code it.... One thing that frustrated me is if you start out with:

dim myyear, mymonth

why does 'mymonth = month(now())' work fine
while 'myyear=year(now())' always result in an error.

Perhaps I'll revert back to my original solution which was to check the current year and month and hide the button if it's not needed.

When assigning month and year to the variable, just use month(date) and year(date)

when used in code, the extra parentheses are not needed and if you use date instead of now, you eliminate the problem of time.

Okay, here is the final version. Well sort of.
I've been asked to make a few changes that will, most likely, take me another week.....
But what can you do?

17344