Results 1 to 9 of 9
  1. #1
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Property custom fields visibility (2003)

    I don't know what "merged PropertyCustomFields" are, but if they are fields, you should be able to see the field codes by pressing Alt+F9 - this keyboard shortcut toggles field codes on/off.
    If that is not what you meant, can you give a clearer description?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Property custom fields visibility (2003)

    Thanks, I see what you mean now. Good for you that you figured it out for yourself!

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Property custom fields visibility (2003)

    Just to set terminology straight: they are not merge fields (they are not related to mailmerge), and they are called DocProperty fields, not Document CustomProperty fields.

  4. #4
    Lounger
    Join Date
    Apr 2002
    Location
    Salem, New Hampshire, USA
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: DocProperty fields visibility (2003)-SOLVE

    Never mind, this dummy figured it out by myself Sometimes it helps to talk things out, thanks to all for listening.

    I found that i just needed to use ALT-F9, like I do for "other" merge fields. This was complicated for me because field shading was turned off.

    For future reference, this can be corrected to show shading as an aide.
    From the Main Menu, select Tools/Options/View
    In the "Show" section, put a checkmark in "Field Codes", and change "Field Shading" Always.

  5. #5
    Lounger
    Join Date
    Apr 2002
    Location
    Salem, New Hampshire, USA
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: DocProperty fields visibility (2003)

    Thanks HansV. I see you were not content to help me in Access, you insist on supporting me in Word also. I do appreciate that.

    I just submitted my own solution while you were submitting your answer. We were just a few seconds apart on posting.

    Re "merged PropertyCustomFields".
    Click on File/Properties/Custom and insert your own Property Field Names
    Now use Insert/Fields.
    Select Document Information as the Category
    Now, under Field Names, select Doc Property
    Now, you can select these Properyt Custom Field names that you created.

    (Edit on 5/18/06: HansV has informed me that the correct term for these fields is "DocProperty fields").

    I am using these in Access to create a Word Document based on a template that has these fields inserted. Part of the Access code looks like this:
    ---------------------------------
    Set docs = gappWord.Documents
    docs.Add strWordTemplate

    'Write information to Word custom document properties from
    'previously created variables
    Set prps = gappWord.ActiveDocument.CustomDocumentProperties
    With prps
    ' Item("Name").Value is the name of the Custome Document Property Fields.
    ' The variable on the right is taken from the Access application.
    .Item("TodayDate").Value = dteTodayDate
    .Item("QuoteID").Value = lngQuoteID
    .Item("Customer").Value = strCustomer
    .Item("SalesRep").Value = strSalesRep
    .Item("Manager").Value = strManager
    .Item("Engineer").Value = strEngineer
    .Item("ShipToName").Value = strShipToName
    .Item("ShipToAddress1").Value = strShipToAddress1
    ' Include more fields as needed.
    End With
    ---------------------------
    This code is modified from sample code provided in Helen Feddema's book "Expert One-on-one Microsoft Access Application Development."
    The Access details are well documented, but the Word support is not included.. The text for this code, on page 410, includes one line for this: "Write information to Word custom document properties from previously created variables." It was from that line that I discovered these properties and found that they can be used as merge fields. This allows writing VB code in Access module to manipulate Word. No need to write out an export file to link to. No need to open Word and make an ODBC link or other connection to a data source. There is no external data source. The Access code writes the values to the Word document, and then saves the document, no need for the user to even open the application, Just click on a "Print Word Document" button in the Access application and continue. Very nice use of VB tools.

    But thanks again for your quick response.

  6. #6
    Lounger
    Join Date
    Apr 2002
    Location
    Salem, New Hampshire, USA
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: DocProperty fields visibility (2003)

    If I had seen the shadowed fields I would have know immediately. It was because of a "new" type of merge field, the Document PropertyCustomFields, that fhrew me off. Searched the forum first. It's always embarassing when it turns out to be something so basic. Aaargh!

  7. #7
    Lounger
    Join Date
    Apr 2002
    Location
    Salem, New Hampshire, USA
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: DocProperty fields visibility (2003)

    I have edited my postingson his thread to reflect the correct terminology to enable better Search results for future browsers.

    Thanks for the correct terminology HansV.
    I appreciate the correction, words are important and crucial to improved communications.

  8. #8
    Lounger
    Join Date
    Apr 2002
    Location
    Salem, New Hampshire, USA
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    DocProperty fields visibility (2003)SOLVED

    I have inherited a template for a form that has DocProperty fields. Most of these fields have been assigned positions on the document and in some table cells. But I have been unable to find out how to make those fields visible. They don't seem to Toggle on/off like other Merge type of fields.

    How can I make these merged DocProperty fields visible so I can modify, add, delete and work with them on this template?

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: DocProperty fields visibility (2003)

    <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •