B
Brian
I wrote a simple program in Access 2007 VBA that creates a Word document,
takes data from the form and inserts it into the Word document. In order to
do this, I open Word using the following:
Dim AppWord As New Word.Application
AppWord.Documents.Add "c:\templates\wordtemplates\fax.dot"
AppWord.ActiveDocument.ShowSpellingErrors = True
AppWord.Visible = True
AppWord.ActiveDocument.Bookmarks("ContactName").Range.Text =
StrConv(rst![str_FirstName] & " " & rst![str_LastName], vbProperCase)
AppWord.ActiveDocument.Bookmarks("CompanyName").Range.Text =
StrConv(rst![str_CompanyName], vbProperCase)
....and so on...
Problem is that my users absolutely "dislike" the new Word 2007 and have
been griping since I installed it. Does anyone know (in order of
preference)...
1) if I can make Word 2007 look like Word 2003?
1) if I can use Access 2007 with Word 2003?
2) if I can use Access 2007 to create an OpenOffice document?
Thanks to anyone that can offer any input!
takes data from the form and inserts it into the Word document. In order to
do this, I open Word using the following:
Dim AppWord As New Word.Application
AppWord.Documents.Add "c:\templates\wordtemplates\fax.dot"
AppWord.ActiveDocument.ShowSpellingErrors = True
AppWord.Visible = True
AppWord.ActiveDocument.Bookmarks("ContactName").Range.Text =
StrConv(rst![str_FirstName] & " " & rst![str_LastName], vbProperCase)
AppWord.ActiveDocument.Bookmarks("CompanyName").Range.Text =
StrConv(rst![str_CompanyName], vbProperCase)
....and so on...
Problem is that my users absolutely "dislike" the new Word 2007 and have
been griping since I installed it. Does anyone know (in order of
preference)...
1) if I can make Word 2007 look like Word 2003?
1) if I can use Access 2007 with Word 2003?
2) if I can use Access 2007 to create an OpenOffice document?
Thanks to anyone that can offer any input!