If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
HELP: Exporting from Access form to Word template and saveas word
Hi All,
I am trying to create a button on access form that would export certain information from access form to word template and save it as a word file. The issue I am having is: I have certain fields marked as hyper link in access database and when trying to export those fields from accses form to word template I am able to export the data but, I get something like this: "124 South West St#http://124 South West St#" I dont want the #http://124 South West St# part from the address.. is there a way to just display 124 South West St? Also, I get "Error! No document variable supplied." displayed on word file for the field that has no value present in Access. Is there a way to get rid of this error message and display a blank if there is no value persent for that field in access? Hope I made it clear. Thanks in advance |
#2
|
|||
|
|||
Exporting from Access form to Word template and saveas word
Change your hyperlinks to text fields. There are other added benefits, such
as you can index them, as well. You can still use the hyperlink property of a textbox to treat them as a hyperlink when they are actually text. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "sam" wrote in message ... Hi All, I am trying to create a button on access form that would export certain information from access form to word template and save it as a word file. The issue I am having is: I have certain fields marked as hyper link in access database and when trying to export those fields from accses form to word template I am able to export the data but, I get something like this: "124 South West St#http://124 South West St#" I dont want the #http://124 South West St# part from the address.. is there a way to just display 124 South West St? Also, I get "Error! No document variable supplied." displayed on word file for the field that has no value present in Access. Is there a way to get rid of this error message and display a blank if there is no value persent for that field in access? Hope I made it clear. Thanks in advance |
Thread Tools | |
Display Modes | |
|
|