mysterybks
11-26-2008, 02:14 PM
I wrote VBA code to take the data from my web site and put it into an Access DB so I can quit creating pages by hand. I have over 1000 pages on my site now. It's been working great. Now I'm writing the code to take the data in the database and create the pages so I can easily change them and add new pages without having to do it all by hand.
My problem is that I just discovered that when I set up my Memo fields, I didn't realize I needed to change them to Plain Text so that it would store my html code in them as well so that when I write the code taking that data and creating my web pages, everything works great.
How can I now write a VBA program to open up each record, take each field in that record, and copy it into a new table. In that it'll need to convert the Rich Text data to Plain Text data showing that HTML coding now.
Thanks.
Dawn
My problem is that I just discovered that when I set up my Memo fields, I didn't realize I needed to change them to Plain Text so that it would store my html code in them as well so that when I write the code taking that data and creating my web pages, everything works great.
How can I now write a VBA program to open up each record, take each field in that record, and copy it into a new table. In that it'll need to convert the Rich Text data to Plain Text data showing that HTML coding now.
Thanks.
Dawn