View a memo field with different format

[myhnews]

I have a DB where I keep all my items
I have a memo field where I keep the HTML code. I’m exporting the table and uploading it to the web.

At the moment, I’m using Front page to edit the HTML code, then I’m pasting it into the memo field.

(This is too much for me)

Is there a way to have a button next to the memo field that opens Front page with the current record on it?

If yes, is it possible to link Front page to Access so when I change the record on Front page, it will automatically change the memo field in access?

Thanks for everyone that reads this question
Joe

 

[neileg]

I don't understand why you want to store your html in Access. Why not just store a hyperlink to a normal html file in your database?

 

[FLabrecque]

Please, please, oh please, never use FrontPage. I'm not a anti-Microsoft programmer (heck, I like Access!), but FrontPage is an aberration that deserves to be dealt with. It messes up HTML like no other.

To answer your question, the answer is No. FrontPage is not a part of MS-OFFICE.

Have you considered putting directly your db on the web? I'm not sure how it's done, but you would simply have to change the DB to change the info (not sure about the format). Otherwise, you could use PHP.

 

[The_Doc_Man]

OK, you have correctly realized that Access won't do this for you. It is not an HTML engine. As such, all it can do is show you raw text. As noted in other replies, Front Page might not be the best choice because it does not integrate will with other Office products.

There is another way that is a little tedious. If the ENTIRE MEMO FIELD is what you wanted, you could write that entire field to a file, then (assuming you have the HTML extensions of Word), you can open the file with Word. Then edit the file with Word. Then save the file as HTML (which Word should allow since it read it as HTML). Then have the program read the word file back into your memo field.

However, I would never save lengthy HTML in a memo field. I would save it in a file and use some other (ANY OTHER) HTML editor. Only store the file spec in the DB. Edit the file whenever you want with your separate editor.

You can certainly launch the HTML display program to show you the page, perhaps by using a SHELL function to trigger the launch with the correct file name. Which you would generate using string concatenation of the file name and the appropriate command-line command to do the launch.