tjburdette Posted August 13, 2012 Share Posted August 13, 2012 First let me give you a background of what's going on. We have what we call a dashboard here at work that shows things regarding safety like how many days it's been since had a unreportable accident, near miss, recordable, first aid or a disabling accident. It has all been kept by printing papers and hanging them manually so far. I am tasked with the job of making this electronic. We are putting up some video screens that will show this stuff. First I built a html form and had all my custom formatting and nice looking things but the way I had it, it would need to be entered everyday. So I then built a database with access 2010. It keeps track of the dates when we last had an accident and calculates reports on that. I put a form in there so when something happens you just have to put the date and type of accident it was and it does the rest. So I know I can output that report to html pretty easily. Is there some way I can get that information into my custom formatting? If you all have a way that it could be done with just coding html then I'll scrap the access stuff I need it to display the current up to date information on my screens.... Thanks Link to comment Share on other sites More sharing options...
niche Posted August 13, 2012 Share Posted August 13, 2012 Other than a timestamp, what else do you think/need to update automatically? Link to comment Share on other sites More sharing options...
tjburdette Posted August 13, 2012 Author Share Posted August 13, 2012 Nothing. It just needs to update every morning. For instance if we had an incident that required first aid today. That will be entered in the form and the output would be "0 days since first aid". Tomorrow it would automatically go to "1 day since first aid" and so on etc..... Link to comment Share on other sites More sharing options...
niche Posted August 13, 2012 Share Posted August 13, 2012 You'll have to know either php or javascript. I'd choose php. Which do you want to use? Link to comment Share on other sites More sharing options...
tjburdette Posted August 14, 2012 Author Share Posted August 14, 2012 I dont have a preference really. Php is fine with me Link to comment Share on other sites More sharing options...
niche Posted August 14, 2012 Share Posted August 14, 2012 So, you just need to display how many days since the last accident and nothing else? Link to comment Share on other sites More sharing options...
birbal Posted August 15, 2012 Share Posted August 15, 2012 when you need to talk with database you must use to server side language like php. clientside languages cant handle databases directly. if you had not any experiance with php. reading the basic from the w3s tutorials would be best place to start. for databse handling you can check http://php.net/pdo Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now