HELP: Exporting from Access form to Word template and saveas word

S

sam

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top