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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by dprayner

  1. dprayner

    Teradata SQL Assistant query - Condition in WHERE statement

    Good afternoon experts. I am trying to filter out some extraneous records, and I need to put conditionA or conditionB in a WHERE statement, and being relatively new to Teradata I am unsure how to handle it in SQL. For example: SELECT [field1], [field2], [field3] FROM tblABC WHERE IF...
  2. dprayner

    VBA Excel Find / Find Next

    Good morning good people. I find that what I need MS find is not sufficient for my needs. I want to find a number of text in a Excel cell and make the cell bold. I can do this with the first one, but I am having trouble do this for each one in the spreadsheet. With the following code I can use...
  3. dprayner

    MS Word TextBox object (tabbing)

    Yes. That's the general idea. DAVE
  4. dprayner

    MS Word TextBox object (tabbing)

    Good afternoon good people. I have a Word Document with several objects (TextBoxes, ComboBox, command Buttons, etc.). What I am trying to do is setup the Textboxes to Autotab after 1 character is keyed. I am using TextBox ojects and not the Text form field or HTML textboxes. This is working...
  5. dprayner

    MS Word Application.Clean?

    Hi good people. I when I populate a ActiveX text box with a 0 (Zero) on a Word Doc, I get a little black square box (new line character?) in the Text and Value Properties. Is there any Application.Clean option in Word, or similar feature. I always get .Text and .Value mixed up. Which one...
  6. dprayner

    MS Word VBA tabbing

    Hi guys. I tried using the AutoTab property which seems to work well. I had forgotten that the Document works differently when not protected. When I protected it, it worked find with the MaxLength property set. Thank you for your help. DAVE
  7. dprayner

    MS Word VBA tabbing

    Great tip guy. I tried to added ActiveX controls and they work well, except there doesn't seem to be a way to .SetFocus to a control as on VB forms and it won't manually tab now. Any suggestions? DAVE
  8. dprayner

    MS Word VBA tabbing

    We can, but the folks that I work with want the tab to be automatic. DAVE
  9. dprayner

    MS Word VBA tabbing

    Hi good people. I have a Word Document with a drop-down box and about a dozen free form text fields. I was wondering if the was a way to programatically tab to the next field after the field limit has been reached. I am having trouble referencing the "objects" by their bookmark names. This is...
  10. dprayner

    InfoPath submit form to Mail Recipient

    Hi people. I have an InfoPath form that will be stored on a SharePoint site. The users will complete the form populating the information and attaching files to be emailed when the form is submitted. I was wondering where I might find some VBScript or other (J) script to send an InfoPath form...
  11. dprayner

    InfoPath Scripting send for through email

    Hi people. I have an InfoPath form that will be stored on a SharePoint site. The users will complete the form populating the information and attaching files to be emailed when the form is submitted. I was wondering where I might find some VBScript or other script to send an InfoPath form...
  12. dprayner

    VBA Excel Select Cells in R1C1 type method

    Hi People. I was wondering why the following code is erroring out: For I = 2 To 8 For J = 3 To LastRowColA If PBNum = Sheet1.Range(Cells(I, J), Cells(I, J)) Then 'ERROR LINE Counter = Counter + 1 End If Next J Next I I am trying to...
  13. dprayner

    VBA Excel Auto Sub

    Hi good people. I want to set up a formula in VBA to auto sum a column of amounts. I have a for loop so that I can count the number of rows (which changes day to day). I set up the variable num to store the number of rows. The beginning row is E3. What formula would I use to auto sum the...
  14. dprayner

    VBA Excel setting scroll bars

    Thank you guys. That works great. DAVE

Part and Inventory Search

Back
Top