merge

  • Thread starter Thread starter Amir
  • Start date Start date
A

Amir

Hi guys,
I got a new project and i got stuck on few things,,, I was
hoping for some help.
I'm merging current record from Access97 into Word97
template. i got it to merge all fields into word template
but when I merge checkbox into a word I get -1 value when
box is check marked and 0 when not. I would like to get
that to place x into a check box in Word template...
And second problem is when I merge JPG;
I have a table with about 30 signatures and user can
select any one of those signatures when filling out a
form. Merge will actualy pass the signature to a word
template but I can't seem to be controling a position of
that JPG. Even though I got a text form field(textbox)
position for signature in a middle of the .dot file the
signature will be always placed all the way to left of
page and above the position that I have selected. Not sure
what is going on.
It needs to be in specific place like everything else in
document.
Thank you in advance...
 
Amir said:
Hi guys,
I got a new project and i got stuck on few things,,, I was
hoping for some help.
I'm merging current record from Access97 into Word97
template. i got it to merge all fields into word template
but when I merge checkbox into a word I get -1 value when
box is check marked and 0 when not. I would like to get
that to place x into a check box in Word template...
And second problem is when I merge JPG;
I have a table with about 30 signatures and user can
select any one of those signatures when filling out a
form. Merge will actualy pass the signature to a word
template but I can't seem to be controling a position of
that JPG. Even though I got a text form field(textbox)
position for signature in a middle of the .dot file the
signature will be always placed all the way to left of
page and above the position that I have selected. Not sure
what is going on.
It needs to be in specific place like everything else in
document.
Thank you in advance...
Click to expand...
Use a query for the record source.

txtCheck: iif(SomeField= -1,"X"," ")

When you get an answer to your second problem, let me know. I always have
to mess with the bmp's or jpg's to get them in the right place, and that
is just one
jpg file. Your problem is 30 different jpg files that are not exactly
the same.
Every time you get new signatures, you are going to have to adjust the
location.
Your table should have the location information you need so your program
can place
them where you want them. Maybe using signature fonts would be a better
solution.

Ron
 
Thank you for your reply..
I will try that fix for a check boxes...
I'm not sure about signature font.. I got 30 Judges that
might not wanna go with that. And even if they do not
really sure if it would work without trying it. I'll
see... if I find a solution I will post it here,,
Take care..
 
Back
Top