Recent content by Starlitnight

Thank you for your time and explaining this to me! Thank for giving the work-around for it through a temp table, I am grateful.

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

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

=if(or(<Field1>=0,<Field1>="",<Field1><0.005),"TEXT","text2")

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?

Thank you very much for the help!!!

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.

YES! That worked! Thank YOU!

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

Thank you, That is VERY helpful. :)

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.

Thank you so much! I appreciate the help!

Hi John, thanks for the post! The only problem is that there are defined name I actually do want to keep. I was hoping for a something such as "if defined name = "act"&"*" but guess I'm not that lucky....I knew I should've been a drummer!

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

Thank you! I looked up nz on the internet and your definitions and examples are much more clear. Thank you again.