Batch export problem

[OPOWELL]

Hi, hope you can help.

I need to export a html file for each indiviual record in my Access table. There are about 13,000 records, and I want the file to be named the same as the primary key for each record - eg SK4525.html, SK4526.html, etc.

The reason I want to do this is so I can hyperlink to a record from another application, using this unique ID. This is possibly not the best way of doing this, but thats what the users want!

Can you do this with a macro or an access page?



I couldnt find a way of manipulating a hyperlink to open access at a particular record, like you can with excel.....

Many thanks,

Owen

[ajetrumpet]

I need to export a html file for each indiviual record in my Access table. There are about 13,000 records, and I want the file to be named the same as the primary key for each record - eg SK4525.html, SK4526.html, etc.

Owen,

this will help: http://allenbrowne.com/AppOutputHtml.html

you can modify that to do what you want, I'm sure. Looks like you will have to do it manually via code. I doubt the interface will let you export html per one record at a time unless it finds each table with one record in it per.

[OPOWELL]

Owen,

this will help: http://allenbrowne.com/AppOutputHtml.html

you can modify that to do what you want, I'm sure. Looks like you will have to do it manually via code. I doubt the interface will let you export html per one record at a time unless it finds each table with one record in it per.

Thanks for that, but I do need to export a single file for each record.....

[ajetrumpet]

Thanks for that, but I do need to export a single file for each record.....

AS I SAID: you can MODIFY it to make it work.

more than likely, you won't be able to find code to do this through google, although I'm fairly sure it's out on the web somewhere...

[OPOWELL]

AS I SAID: you can MODIFY it to make it work.

more than likely, you won't be able to find code to do this through google, although I'm fairly sure it's out on the web somewhere...

Thanks for your help, but i don't know how to modify it! Ideally a method through the GUI would be good.

[ajetrumpet]

there is no method through the GUI sir, but there might be some tools out there.

I could help out, but I don't have time at the moment...

[OPOWELL]

Hi, for those with a similar problem I used a combination of MS Word mail merge from the access database, and then adobe acrobat to create the individual files.