I have been creating databases for my own purposes for a few years but have never had to make something available to other people. I created a simple database to report the cell phone overages of each user in the company and thought it would be a simple process to publish it on the intranet for managers to look at...I think I'm in over my head.Using MS Access 2007.The DB contains the following:A single table called tblOverages.
The table is actually linked to tblOverages in my WATS database (the DB I use for tracking all things related to mobile devices).qryOverages
(uses a form to allow user to input parameters)frmSearchBy
(prompts user to enter parameters such as dept number, employee name, start/end date)rptOverages
(data is displayed to the user as a report)
The idea is the managers can open this DB, the form will appear prompting them to input a dept number, an employee, date range, or leave all blank to see a full listing of overages.
At the bottom of the form is a button they click to generate the report based on the parameters they input.Now I have two hurdles to overcome:
1. The managers do not have MS Access (did not know that when I created the DB)
2. Need to make available via internal webpage
Is there a way to use a webpage as the front end where the user can input the parameters and then have the corresponding data show as a webpage?
Say John wants to see all overages for Dept 6127.
I would like for him to be able to go to an internal webpage like https://overages.hp.com
and frmSearchBy will appear with active fields for him to type in.
He would type "6127" in the Dept Number field, click the "Open Report" Button and a webpage would open showing him the report of all overages for dept 6127.
How would I do that? Is XML the way to go?