Hi All,
I'm trying to find out what is possible in the way of web deployment (the Access help doesn't seem to tell me enough) in MS Access 2003.
I have a make table query, and a quite complicated report that prints the table details.
I have played with the Pages feature in MS Access to make a web page that happily sits on my web server and shows the table records one at a time, but what I want is more complicated than that.
My ideal solution would be a form that sits on the web server that allows the required user parameters to be entered (lets assume they are a date and a product code). The user enters the parameters they want in their web browser, clicks the "go" button on the form. That then triggers MS Access to run the query using the user-entered parameters and then runs the report, and shows the results to the user, where they have the option of printing the report.
Is that possible with standard MS Access? I tried out the Forms option, but it didn't seem to convert it to a web page in any meaningful way. It just seems to create a static html page.
Thanks for any feedback or suggestions.