Search results for query: *

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...

Thank you.

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...

Yes. That's the general idea. DAVE

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

We can, but the folks that I work with want the tab to be automatic. 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...

Thank you guys. That works great. DAVE

Range("A1").Select put the focus on cell A1 which I am also doing, but the scroll bars don't move from their saved location. DAVE

Hi people. I was wondering if anyone knows how to make the scroll bars adjust to the absolute top and left when a spreadsheet is opened. I know the basic usage of the ActiveWindow.SmallScroll function, but there isn't anyway to know if the last person scrolled down 100, 10, or 1 position. I...

Hi Zach. I suspected the quote. The tab has a hyphen (Proc'd) and since it is not my spreadsheet, I can't change the name. I read something that said to change the ' to " if the formula is already in ' '. DAVE

Hi good people. I am trying to pull information from one sheet and test to see if it is greater than 1300. If it is I want to put a 1 in the cell and if not, leave the cell blank. I have this so far: If('Items Proc"d by Req Code'!S6>1300,1,0). This comes up with an REF error. Any suggestions? DAVE

Hi imatracher. I did set the names for example a combo box I put combo. Wheh I Submit it, I get combo = A in the body of the email. I am not getting the objects. DAVE