First of all can I say that I'm quite competent when it comes to designing applications in Access - creating forms, queries and using VBA. However, I've been given the task of creating a Data Access Page to display some sample data. Now I have to admit that I've never uses or even looked at how Data Access Pages work so I'm looking to the users of this forum for some help and inspiration.
Basically our company has an application that's been created in a programming language - not sure which, could be C++ or something like that. Now they want to web-enable this application but want to first put everything into MS Access so that the sales people can see it's possible. I've created a Word Doc containing some screen shots of the existing standalone application which can be downloaded from my companies website by Clicking Here . The first 3 screen shots show the information displayed when each of the 3 radio buttons are selected (Household, Individual & Account Detail). The rest of the data at the top of the window is static. The last couple of screen shots on the document simply show a couple of queries I've already created to replicate the display of the data for the Household and Individual options - haven't got round to creating a query to replicate the data displayed for the Account Detail option.
I'm fairly confident that I can create the basic page to display the static information at the the top. So what I basically need is some help in the following areas:
Basically our company has an application that's been created in a programming language - not sure which, could be C++ or something like that. Now they want to web-enable this application but want to first put everything into MS Access so that the sales people can see it's possible. I've created a Word Doc containing some screen shots of the existing standalone application which can be downloaded from my companies website by Clicking Here . The first 3 screen shots show the information displayed when each of the 3 radio buttons are selected (Household, Individual & Account Detail). The rest of the data at the top of the window is static. The last couple of screen shots on the document simply show a couple of queries I've already created to replicate the display of the data for the Household and Individual options - haven't got round to creating a query to replicate the data displayed for the Account Detail option.
I'm fairly confident that I can create the basic page to display the static information at the the top. So what I basically need is some help in the following areas:
- How to have the data displayed change when one of the radio buttons is selected.
- How to create the graph as per the screen shots of the standalone application.
- How to have the graph change when one of the radio buttons is selected (please note that for the Individual and Account Detail options the graph is the same).