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 Mike Lewis 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. afelissimo

    Help - PDF Document Keeps Typing in Chinese or other Asian Language

    I received a PDF from an outside source and it keeps typing in Chinese (or other Asian language). I tried to create a fill in form using the PDF and all the fields type one character in English and then by the second character get hijacked by some kind of Korean typing overlay. I went back to...
  2. afelissimo

    Assign Labels to Values in Table Column (MS SQL SSRS)

    jjefferson, Thanks for the reply! After a lot of research, I finally came to the same result. I put the CASE sequence in my WHERE clause of the data query. Because I wanted to use "Status" as a parameter, I also had to add it to the SELECT clause of my parameter query. I used DISTINCT in...
  3. afelissimo

    Assign Labels to Values in Table Column (MS SQL SSRS)

    I have a table column called status. Its values can only be "O" or "C." In my report, I would like it to show as "open" or "closed." How do I update my query to do this?
  4. afelissimo

    Outlook VBA Macro to Open Custom Form saved in Personal Forms Library

    I am trying to create a VBA Macro in Outlook to open a custom form I've created that is currently saved in the Personal Forms Library. I am hoping to eventually move it to the Organizational Forms library on the Exchange Server (the system engineer does that for me). I understand that there is...
  5. afelissimo

    VB Error when I run Macro from QAT (Quick Access Toolbar)

    I could probably clean up the code for the table borders, and I know that I could clean up the code for the shapes. I just have to be careful with the shapes that I don't accidentally delete something that I need. And, yes, I think this QAT issue is separate from the code, since the code is...
  6. afelissimo

    VB Error when I run Macro from QAT (Quick Access Toolbar)

    Hi Fumei! Here's the code: Sub Envelope() ' ' Envelope Macro -- Keystroke shortcut = Alt+E ' Creates 8.5 x 11 inch foldable envelope insert ' with company return address and highlighted text as addressee ' 'Copies highlighted text Selection.Copy 'Opens a new blank document...
  7. afelissimo

    VB Error when I run Macro from QAT (Quick Access Toolbar)

    The macro works just fine from the macro button on the developer tab (Word 2007), but when I put the macro on the QAT and try to run it from there I get an error message. The error message has no text, just a big red circle with a white "x". ???? Can't find anything in google or tek-tips...
  8. afelissimo

    VBA in Word Table Cells -- Horiz. Align./Text/Paragraphs

    Fumei, Your original advice about setting the cell and then using it before the command actually helped me fix a lot of the problem code: Dim aCell As Cell Set aCell = ActiveDocument.Tables(3).Cell(2,2) ' insert text aCell.Range.Text = "yadda" This little snippet of code was brilliant, and...
  9. afelissimo

    VBA in Word Table Cells -- Horiz. Align./Text/Paragraphs

    Hi Fumei, Thank you for being so responsive! It kind of is a template, but I do want it to be a macro. I guess I could create a template... At work, we use a double-windowed envelope for mailings. The secretaries print out a sheet with our return address and the mailing address. The firm...
  10. afelissimo

    VBA in Word Table Cells -- Horiz. Align./Text/Paragraphs

    Hi Fumei, Thank you for being so responsive! It kind of is a template, but I do want it to be a macro. I guess I could create a template... At work, we use a double-windowed envelope for mailings. The secretaries print out a sheet with our return address and the mailing address. The firm...
  11. afelissimo

    VBA in Word Table Cells -- Horiz. Align./Text/Paragraphs

    Thanks PHV. I started the whole thing by recording it, and I've been debugging it ever since. I had no trouble whatsoever creating a new blank document, setting the margins, creating the table, setting the vertical alignment for the rows and creating, coloring and placing two drawing shapes in...
  12. afelissimo

    VBA in Word Table Cells -- Horiz. Align./Text/Paragraphs

    Please help! How do you set horizontal alignment, insert text and insert paragraph returns inside a specific table cell. I can get all of this to work outside of a table, but I can not get this to work in the table. TIA!!! --from a beginner VBA programmer

Part and Inventory Search

Back
Top