Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. murfeezlaw

    vba syntax - using date variables in SQL

    Hi all, i've been working at this for what feels like forever and my head is getting sore from banging it on the desk. Can anyone see what is wrong with this syntax? Any help would be so appreciated. I know it's long. I had it broken up but was getting errors so i put it together so it might be...
  2. murfeezlaw

    Insert blank page if document is odd number of pages

    I'm using an Access application to create a document(A) and insert many word documents(B) into it. Is there a way to count the pages of the document being inserted? And if it's an odd number of pages to add a blank page? If i just do a page count of the document in VBA it'll count the pages of...
  3. murfeezlaw

    Columns spanning onto nextpage using InsertFile

    Yeah that's exactly what I did. I thought if i changed it to 1 column before i inserted the document it would keep the whole thing 1 column but it seems to have worked. it's a big document with a lot of insertions. i need to go thru it all to see if it worked. thank you for your help
  4. murfeezlaw

    Columns spanning onto nextpage using InsertFile

    i tried it anyway. it looks like it's working. i have to go thru the whole document to make sure all titles are ok.
  5. murfeezlaw

    Columns spanning onto nextpage using InsertFile

    The inserted document does have columns but the title at the top of the page is only 1 column. i'm afraid if i turn columns off for the document it will affect the layout of the whole document.
  6. murfeezlaw

    Columns spanning onto nextpage using InsertFile

    I'm using VBA to add a new document into the current open document. The title at the top of the new document that was inserted is being formatted in columns. How can i stop this? My code is below... For Each ctrl In Me![sfmStateForms].Form.Controls If TypeOf ctrl Is CheckBox And ctrl.Tag =...
  7. murfeezlaw

    Using VBA to update Page x of y in footers

    I think i figured out how to update the footers for the First Page Footer. i basically repeated the code. So I have...(I declared objWord as Word.Application earlier in my code) Dim s As Word.Section Dim f As Word.Field Dim fcode As Word.Range For Each s In objWord.ActiveDocument.Sections With...
  8. murfeezlaw

    Using VBA to update Page x of y in footers

    AWESOME! thank you so much! Big help. The only problem i'm having and hopefully this isn't a big deal. it isn't correcting the footer to read Page 1 of SECTIONPAGES for all footers. After looking at it the only time they aren't getting updated is when the footer displays as "First Page Footer"...
  9. murfeezlaw

    Using VBA to update Page x of y in footers

    Thanks, i tried that. i'm still getting Method or data member not found at: With s.Headers(wdHeaderFooterPrimary).PageNumbers any ideas?
  10. murfeezlaw

    Using VBA to update Page x of y in footers

    Thanks, i tried that. i'm still getting Method or data member not found at: With s.Headers(wdHeaderFooterPrimary).PageNumbers any ideas on that?
  11. murfeezlaw

    Using VBA to update Page x of y in footers

    I could really use some help here. I'm using VBA in Access to open Word and dynamically create a document. At the end of this document I need to insert more documents. That is working fine. My problem is with the page numbers in the footers. The documents being inserted all have page numbers in...

Part and Inventory Search

Back
Top