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
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