Search results for query: *

Hi Is it possible for EXCEL to update a access database in the scripts of an EXCEL file?

Hi all, Just wondered if its possible to put text in a cell when a row is changed to a certain colour>? gc

Hi again Is it also possible to make something.5 equal to something.95 ListPrice Pricelist.Price products.Price result 1.927 1.64 4.5 3.854 1.927 1.64 4.5 3.854 1.927 1.64 11.5 3.854 1.89175 1.61 4.5 3.7835 1.927 1.64 4.5 3.854 1.927 1.64 4.5 3.854 2.1385 1.82 4.5 4.277 2.1385 1.82 4.5 4.277...

Hi Is it possible to list a figure hence 45.61234 as 45.62, in other words reduce decimal places

Hi Next is lit up as though reserved word, can anyone spot why my quotes are doing what they should response.write "<a href=""pt_listcategoriesandproducts.asp?idCategory=" &pIdCategory& "&curPage="& curPage + 1 & "" title=""Next""><img src=""images/previous.gif"" border=0></a>

Hi Can anyone tell me the syntax for adding an image to a input type? INPUT TYPE=BUTTON VALUE= instead of text, pictures

Hi I'm dealing with large files 2 - 10 gig in size, I have a wait dailog that is blowing up on this line, is there any way around this fSize would is 3020750848 at this point d = fSize mod 100000000

Hi Is there something is .NET similar to ASP'S chr(numberofasciichar) I'm trying to list the © symbol put it puts \A in front of it

Hi folks, I need to extract data from a table using openshema, so far i have got back table names and colums but i need to loop and extract all the data but for some reason I cannot use EOF or Fields methods on the record set? any ideas

Hi I have had a working site for a while, now I ge this error? "Command text was not set for the command object" what is actually required? my code set connTemp=server.createobject("adodb.connection") set rs=server.createobject("adodb.RecordSet") connstring = "Driver={Microsoft...

Hi How do i create a control button so i can assign it to a modlue sub function? I've created the button but the option assign macro is not available

Hi Yep, Having a whirl of a time here I have a tag that i want to get the row number it is on EndRow Its at row 22 but its giving row 3776 that another tag with the same name is on.... even though i call AddSt... code below endAddRow = Worksheets("AddSt").Cells.Find("EndRow", [a1]...

Yep, me again whats wrong with this, I want to update the cell with its current contents plus value from another cell Worksheets("Sheet2").Cells(Row, RanOnceCol).Value = Worksheets("Sheet2").Cells(Row, RanOnceCol).Value + Add.Cells(InRow, 1).Value

Hi I've just upgraded to excell 2003 and get the above error on this line startStockRow = Sheet2.Cells.Find("StartRow", [a1], xlWhole, xlByRows, xlPrevious).Row + 1 does not like Cells call, has it been superceded?

Hi all, I have a very strange error, i use this formula to look up cells =VLOOKUP(TEXT(B9,"0"),Sheet2!$A$2:$C$3974,3,FALSE) I also have some VB code that runs on a button control, when i run the code I up date certain cells in sheet2 with a number (increment the number already in there)...

Hi all, I have placed a macro in my excel file and now excel crashes everytime i open it, I cannot edit the file, I dont think think the macro is running because it runs with the press of a button, how can i fix the file? I get crash error each time and excel has to be forced to close in processes

Hi folks, I hope i explain this well, 1. I have a sheet with stock that has been sold that has a box number ie: box6, so assume 3 lines of stock are listed Sheet1 SKU BOX QTY 1234 BOX6 1 4321 BOX2 1 1256 BOX3 1 Sheet2 SKU...

Hi Not a dot net person, can anyone please convert this CDONTS syntax to ASPEmail pleasE? Set mail = Server.CreateObject ("CDONTS.NewMail") mail.BodyFormat = 1 mail.MailFormat = 0 on error resume next mail.Send from, rcpt, subject, body

Hi Anyone know how i can use format with date function to return 23/3/2004 format?

Hi all, I have 2 sheets, 1 sheet does a VLOOKUP in the 2 sheet and if found i need to reduce the total on that row by one? is this possible, its so i can track stock and know exactly what is or isnt in, by the way, I use the SKU code that lookups on on the first sheet. many thxs