You have Access query results that you would like to publish
as an HTML page over your intranet so your employees can access the data from
their browsers. You could export the query to an HTML file, but then you
realize that the columns of data are too hard to read. For your own department,
you have created a read-only form that the employees use to navigate the query
results, where you’ve changed the field names to more meaningful captions. To
export the datasheet view of the form to an HTML page, follow these steps:
- In the
Database Window, click the Form Object button.
the form you created from the query.
HTML Documents from the Save As Type drop-down
OK to accept the default HTML template.
Note the HTML page created includes a header row with field
names (including the changed labels). It also formats the fields as formatted
in the form, making it much easier to read than an HTML document created from
the query datasheet view.
Miss a tip?
Check out the Microsoft Access archive, and catch up on our most recent Access tips.
Help users increase productivity by automatically signing up for TechRepublic’s free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.
Subscribe to the Developer Insider Newsletter
From the hottest programming languages to commentary on the Linux OS, get the developer and open source news and tips you need to know. Delivered Tuesdays and Thursdays