Hi there,

I have a application on MS Access VBA, with many tables, queries, forms and reports. I would like to switch it to web based application using php and mySQL. Probably the whole user interface will be redesigned. But that's fine.

My concern is, one of the reasons the original application chose Access was it ability to create report on the fly, visually shows the elements located on the sheet, and use predefined forms (in case of address label printing and the like). I have totally no problem to deal with database and screens, but totally incapable to create reports. Usually web report is done by creating a printer-friendly page and ask user to print the page. But the browser has too much control in printing and there is no way to control pagebreak in browser printing.

I heard PHP is NOT ONLY for web application. Is this true. I am hoping this can give me a breakthrough, or some advance html technique can help me. Of course I will never exclude any other possible solutions. Basically I need some web solution(s) that can create formatable printing reports.

Can anyone give me any advice and poin me to the right direction?

Many thanks in advance.

    I have a feature which uses CSS to control page breaks, you CAN do print-friendly things and even have one page serve dual use.

    PM me to remind me and I'll find it when I get home.

    Sam

      Have you checked out navicat? navicat.com

      Nice little GUI interface to MySQL with a nifty report generator. Makes MySQL look pretty much like Access. Has a great import tool too. So you just tell it to import your whole Access dbase and it handles all for you.

      You'll need to set indexes and fine tune afterwards though.

        Write a Reply...