Discussion Locked

Access DB and HTML...Access Reports

0 helpful
6 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hello, i have two questions. First, i created an HTML link to an Access 97 .mdb file. When the link is clicked, the DB is opened twice. I was wondering if anyone has encountered this problem or knows how to resolve it?

Also, i was wondering ifanyone knows how to create a report in Access, but instead of having record going from left to right in rows, have the records going up and down in columns...keep in mind that i am working with an enormous amount of data.

Thanks in advance

Justin

6 replies

by kees.valkenswaard

The first problem I have not encountered yet. Try to remove the link completely. There may be a hidden, second link. Establish a new one and hopefully your problem is over. If not just tell again.
The second issue about the report is a different game.
Supposing that you only need a big amount of data with only a few columns and no magic like subtotals, there is a relatively easy solution.
Make a query that lists the fields you need with sorting as desired. Open the quey and use Tools, office-links, publicise with Word.
In Word use columns to wrap across your pages.
Believe me, it works! You may have to adapt the size of the table in Word first and to set the gap.
Success!

by kees.valkenswaard

Perhaps your question was not clear enough. So I understand you really want to have one field in each row. If you are satisfied with the wrapping as columns in Word provided, here is your answer. Do as I said before, make a query and send the resultto Word. In Word use menu option Table to convert a table to text with the paragraph sign as divider. Set columns as described before and now you have what I believe you want.
There is an alternative. Use in Word mail-merge. Set up a catalogue witha vertical table consisting of as many rows as fields you have in the Access query. Link to the query in Access and fill-in the merge fields in the Word table. Set already the columns in Word and do the mail merge.
The advantage is that you can save the mother document in Word and use it again and again. In this case only the last step of the mail-merge is required. Also if you want some sign where a new record starts, this is easy in the Word Table where you would add one cell to the Word table [if needed with some indication].
In the other solution you would have to add a calculated field to your query.
Good luck.

by bowjangles

Sorry for having an unclear question, but i figured out the solution to my problem on my own!

This discussion is closed to new replies.