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!

Search results for query: *

  • Users: Starlitnight
  • Content: Threads
  • Order by date
  1. Starlitnight

    SQL Can I update a table via an array:

    Bascially I want to UPDATE a particular column Essentially I want to do the following: ALTER PROCEDURE WriteStockStatus (@asin varchar(10), @asinStockStatus varchar(15)) AS UPDATE OnSale SET StockStatus=@asinStockStatus WHERE ASIN=@asin Ok, but, I don’t want to have to call...
  2. Starlitnight

    SQL can I update a table with an array?

    Bascially I want to UPDATE a particular column Essentially I want to do the following: ALTER PROCEDURE WriteStockStatus (@asin varchar(10), @asinStockStatus varchar(15)) AS UPDATE OnSale SET StockStatus=@asinStockStatus WHERE ASIN=@asin Ok, but, I don’t want to have to call...
  3. Starlitnight

    Hopefully an Easy one. Less Than symbol NOT recognized as a field

    Hi, I have an issue while trying to put in a formula... all I need is for it to check if a field is < 0.0005 ...The problem I'm having is that Excel is reading the < as value rather than the less than symbol. Any ideas on how to fix this?
  4. Starlitnight

    How do I get a submit button to send web form inot?

    I'm trying to write code for when the submit button is clicked and everything is filled in correctly, the filled out form will be sent to my job as an attachment. Do you have any idea how to do this? I'm using the ASP server side language.
  5. Starlitnight

    If statem to search for special charecter

    Hi, I would like to know how to create a formula that would search for an asterisk *. If I write: =IF(ISNUMBER(SEARCH(""*"",A1)),"<myfield>","") Excel treats the * as a special charecter is there any way around this? Thanks
  6. Starlitnight

    How do I get a submit button to display results in Word?

    Hi, I have created a “submit” button on a form. When the button is clicked, I want the results to appear in a word document. Can I make this happen? If so, how? The form results display names for labels.
  7. Starlitnight

    excel 2003 deleting group of defined names

    Hello, Is there a fast way to delete defined names in an excel worksheet? I'd rather not go line by line in the defined name dialog box. Is there another way I can delete groups of defined names? They all start with "act".
  8. Starlitnight

    Can CInt() be summed?

    Hi, I have a query which pulls the number of people we serve by converting text to a integer via Cint(). The original value was #Served:23. The numbers after the colon were extracted and converted via the Cint() function. Now I am to create a report that contains a sum of that field. Here is...

Part and Inventory Search

Back
Top