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...
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...
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...
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...
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
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
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.