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

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

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 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 people. I was wondering how to create a simple web form in MS Word 2003. So far I have created a new Document as web page and have added several controls including a drop-down combo box, text box, and submit button. I want to have the user be able to fill out the form, and when the click...

Good afternoon people. I am trying to create a function which selects a range (ie. a1:a10) which has integers 1-100. Some of the cells contain 0 and I want to total the cell amounts that are > 0 and count how many cells do not contain 0. I am trying to create an average for example 10 cells 5...

Hi everyone. I am trying to create a query based on responses from a user on a Access form. What I am trying to do exactly is there is a create the query from a table named WCNVACCT which has about 12 fields name, account number, etc. The first combo23 will ask form the item (ie. name) and the...

Hi people. I have a user that has trouble tabbing textbox to textbox sometimes. The tabkey behavior, enterkey behavior, and multiline are set to false. I beleive I have set the tabstop and tabindex properties correctly also. My question is, is there a way to "hard" code the tab key in the...

Hi good people. I am have an unusual problem. I am trying to compare the values in two textboxes and the less than compare is not working for some strange reason. I created a test application to see if it might be something in my larger application, but it does the same thing when I create a...

Hi good people. I used to have a problem that when people would cut and paste into a textbox, a new line character would appear at the end. When I populated an Excel cell with this, it created a small black square at the end. I beleive I have concurred this problem, but when I populate the...

Hi People. I have an application using Excel and the VB form Editor. The code is in VBA and a user completes the VB form and the responses populate the spreadsheet. My problem is some of the users get little black squares after text and/or numbers. I used the Trim function and RTrim...

HI people. I was wondering if anyone know the most probable cause for the following error: Run-time error '-214467259 (80004005)':The Operation Failed This error gets hung up on the .Send line of code. What the project does, is when the user opens the Workbook, a VB UserForm pops up. The...

Hi people. I have tons of controls (ListBoxes, textboxes, ComboBoxes, CheckBoxes, etc.) on my spreadsheet tabs. I was wondering how everyone typically handles tabbing to and from controls. I originally thought that if a certain cell is existed, one could SetFocus on the control. Unfortunately I...