I see you can add or export data and use a template. I guess I need a template first. Any templates out there geared toward MS Access tables?
Where does the table data go?
I see you can add or export data and use a template. I guess I need a template first. Any templates out there geared toward MS Access tables?
Where does the table data go?
Perhaps it would be easier if you could show us what you mean. For example, show us the original data, the export result, and the formatted outcome you desire.
Export the query to a text file and you have the HTML encoded data. Paste it into your main document (surrounded by the correct HTML) and you can then style it however you want with a CSS file that defines 'DataRow'.
You cannot make that data dynamic once exported to HTML. You can make the query sort and search the data prior though.
This a hobby project or for your company? This is realy a simple task with the right tools. Access isn't the right tool for a database that feeds websites though. Can you give us a big picture of who this is for--why must it be on the web?
Sounds like when you say HTML, you actually means a website. I have experience with Caspio, but I am not sure you really want to use it. What is the data going to be used for? Who will use it?
So, your customers have their own customers? Are you giving them an Access application? If so, can't they see their own data using your Access application?