Search results

Yes that is what I am doing. There is nothing DB related just throwing text into Word via Automation

Post one shows the whole code, sorry about not highlighting the error above I highlighted it in red. It worked without the loop that I have highlighted in red, so do I have to do ADO or DAO for the loop to work because I didn't have to have that before? 'Replace Bookmarks with Values With...

As an update I tried this: 'Replace Bookmarks with Values With Wrd.ActiveDocument.Bookmarks If .Item("CurrentDate") Then .Item("CurrentDate").Range.Text = Date End If .Item("AccessAddress").Range.Text = sAccessAddress .Item("Salutation").Range.Text = Salutation End With This...

Thank you. That is what I had in mind to do but I wanted to make sure I was not overlooking something, I tend to make things more complicated than needed. :)

Anyone? I would be grateful for the help

Hi all, I have a dilemma. I have an Access form that I need to auto fill multiple forms. These forms may not have all the bookmarks so I want to use a loop but I don't know which one to use. I know about IF/THEN, IF/ELSE, FOR/NEXT, CASE but I am stuck on which on. I need the loop to go to each...

Sorry about not pointing out the error. I thought I did, but see I didn't. Here is where the error occurs: 'Open Word using template and make Word visible Wrd.Documents.Add sMergeDoc Wrd.Documents.Add sMerge <-- Here is where the error is thrown Wrd.Visible = True So would I need a loop for...

I am a newbie at VBA. I have the code for my button to do one thing and now I am stuck. How do I get one button to fill in bookmarks on different documents. Here is my code and it is not working Option Compare Database Private Sub cmd_Word_Click() 'Declare Variables Dim sAccessAddress As...

I fixed the error and found out that the bookmarks in my template did not save. Now when I have this line: .Item("AccessSalutation").Range.Text = sAccessSalutation Active the Address doesn't come over just the salutation. Heres my cleaned up code too Private Sub cmd_Word_Click() 'Declare...

Hi all, I have been using access for awhile and I tutor it along with all the other office software (Word, Excel, Powerpoint). The forum has been a great help to me. Merry Christmas!!

Thank you I copied it out my book, I will fix it post haste. On Edit: It worked, thank you. :) I want to say Merry Christmas and Happy Holidays Now I got a run time error 5914 the requested member of collection does not exist. :)

Hello, I am working on trying to get Access data from a form into Word when the person clicks a button. I got most of the kinks worked out by perusing the forums here but this one has me scratching my head. I keep getting a runtime error 424 access object required. Here is my code and I...