VickyC
12-17-2007, 04:01 AM
Good Morning,
I am creating a template to incorporate our office address in the header.
I have created a form to open and there is a list of offices to choose. From here which ever office is choosen I want the corresponding address to be in inserted into the header and the remaining address to be inserted into the footer.
I have added a bookmark called location in the header although I am unable to get to this???? http://www.access-programmers.co.uk/forums/images/smilies/confused.gif
this is the code I have so far...>?> I would really appreciate any advise you can give me....???
Thanks, http://www.access-programmers.co.uk/forums/images/smilies/smile.gif
' Office Location editing headed paper
If cbOffice.Text = "Milton Keynes" Then
ActiveDocument.Bookmarks("location").Range.Text = "Address, Milton Keynes"
ActiveDocument.Bookmarks("tel").Range.Text = "01908 000000"
ActiveDocument.Bookmarks("Fax").Range.Text = "01908 000001"
ActiveDocument.Bookmarks("DX").Range.Text = "000 MK 0"
End If
I am creating a template to incorporate our office address in the header.
I have created a form to open and there is a list of offices to choose. From here which ever office is choosen I want the corresponding address to be in inserted into the header and the remaining address to be inserted into the footer.
I have added a bookmark called location in the header although I am unable to get to this???? http://www.access-programmers.co.uk/forums/images/smilies/confused.gif
this is the code I have so far...>?> I would really appreciate any advise you can give me....???
Thanks, http://www.access-programmers.co.uk/forums/images/smilies/smile.gif
' Office Location editing headed paper
If cbOffice.Text = "Milton Keynes" Then
ActiveDocument.Bookmarks("location").Range.Text = "Address, Milton Keynes"
ActiveDocument.Bookmarks("tel").Range.Text = "01908 000000"
ActiveDocument.Bookmarks("Fax").Range.Text = "01908 000001"
ActiveDocument.Bookmarks("DX").Range.Text = "000 MK 0"
End If