Example Needed for Access VB

[boy3696]

Hi Everyone:
I'm wondering if anyone has a simple example of vb code in Access 2007 that reads a query and outputs to a text file. I actually have 2 tables shown below which should be self explanatory.
I need to do this to build html pages with tags and all, which is why I want to output to a txt format. I used Mail Merge for 5 different types of static pages already which works great, but now I have to generate HTML with entries underneath the main info (ie: repeated lines or iterate)...

ie: Tabel names: AlbumsMaster & AlbumsTracks

Album Name: xxxxxxxx
Album Release: Date: xxxx-xx-xx
Album Country: xxxxxxxxxxxx

Tracks:
1. xxxxxxxxxxxxxxxxx by: xxxxxxxxxxxxxxxxx
2. xxxxxxxxxxxxxxxxx by: xxxxxxxxxxxxxxxxx
3. xxxxxxxxxxxxxxxxx by: xxxxxxxxxxxxxxxxx
4. xxxxxxxxxxxxxxxxx by: xxxxxxxxxxxxxxxxx
5. xxxxxxxxxxxxxxxxx by: xxxxxxxxxxxxxxxxx


.
.
.
14. xxxxxxxxxxxxxxxxx by: xxxxxxxxxxxxxxxxx

I would greatly appreciate it if someone could help me out.
Thanking you in advance.
D.

[ajetrumpet]

have you ever considered establishing a DSN and simply displaying your Access tables on your webpages AS IS?

[boy3696]

Hi Adam:
I'm doing this for a friend and he doesn't want the information posted like a table.
He basically wants the master information to show above, then the tracks from the track table to follow. That's why I need to see an example of how to read a query, loop through it and output to text. He gave me the format it has to be in, but my vb skills suck.

[ajetrumpet]

post an image of the format of how it should look. compare it to what you've tried.

Also, have you explored the output formats of right clicking on a query and outputting that way? To text? Have you tried the docmd.transfertext method in vb to see how it outputs as well? Give those a whirl and see how you make out with them.

Which html editor are you using? I use DW and I know that it can format data a few different ways as well. If you're using something simple like WYSWYG though, I don't know if those kind of programs have the capabilities that sophisticated ones like DW have.

[boy3696]

Thanks to everyone who looked at this.
I figured out how to read a table, then output to text file.
Everything is working as planned.
Cheers.