Form For Pool Calculations

[Grayhat]

Greetings All Users:





I am a Pool Director that is trying to move from paper logging to computer logging of my chemical readings. I have lifeguards that take the readings and write them down, and they get filed away. From these readings, we also make calculations of how to change the chemistry of each pool so as to maintain "pool health". I would like to create charts and graphs in these calculations and readings so as to have a graphic of what changes with my bather load. I am wanting to add a computer to my Aquatics Area where the data can be input automatically, on site.

What I would like to do is add a computer to the aquatics area of my facility, and have it display only the form that I have created from access so that the only thing that can be done with that computer is type in the data. Then at the end of each week print out a report and graphs and make same decisions, the same thing at the end of the month, and of course annually.

I know I can publish to SharePoint some home, but I do not know where to look for information for my specific task. Once again, my concept is the following, take 7 different readings a day per pool (there are four). After the first reading is filed in the database for each pool, then another form pops up, ready for data entry.

I do not want the employees to have access to the database, only the form for entry.

Please no angry people telling me how hard this is, or eazy this is, I dont mean to insult people's intelligence by asking these questions

Thanks to all replies that are constructive

[June7]

First, set the form DataEntry property to Yes. This will not allow existing records to display on the form. Each time the form opens it will show only records input during that session. Close form and reopen for another session.

Set the Form for Single View default display.

Disable the Navigation bar that shows by default at bottom of form.

So far there is no special programming required for the process. How much and what code will be needed depends on how you want to deploy the db.