Generate Html page from access

chanchal

New member
Local time
Tomorrow, 03:11
Joined
Dec 4, 2003
Messages
5
I have made an application which can generate html page from access. The html codes are stored in table import and field name like L1,L2,L3.........
these field keep the html code. i have made a form called export which has a button name cmdExport. Export button can generate html page but the problem is when it create a html page it add some "" in the tag which is not needed in the html page.

can some one tell me how can I remove this "" (double quotes) from the html pages.

export buttons code:

Private Sub Export_Click()
DoCmd.TransferText acExportDelim, "", "import", "c:\file\test.htm", False
End Sub

which line i have to modify? or i have to write some additional codes here.
 

Attachments

I find that creating HTML is easier by placing the fields into one textbox in a report and then outputting the report as a text file calling it in your case test.html

NOTE: When creating the report, remove the label associated with the textbox then in the textbox paste the following into the Control Source:

=[L1] & [L2] & [L3] & [L4] & [L5] & [L6] & [L7]


HTH
 

Users who are viewing this thread

Back
Top Bottom