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

Well yes, I've done this, the idea was to update to .50 if price is less that .50 and .95 where prices are greater than .50

No its access and it has to be a query

Whats A1 a column.. thxs

Soorry , live db, access via a front end in ASP to run updates only

I'm afraid it needs to be an upgrade, db is live so can only use query in an ASP front end

mmmmmmh, interesting

Ah.... see but i need a query, cannot access the db physically, its live

Sorry access databases

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

Bingo cheers chops

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>

Still not working

Now i change it to code if curPage > 1 then response.write("<INPUT TYPE=IMAGE SRC='IMAGES/PREVIOUS.GIF' ALT='Previous' ONCLICK=""document.location.href='pt_searchitem.asp?strSearch=" &pstrSearch& "&curPage="& curPage - 1 & "';"">&nbsp;&nbsp;&nbsp;") end if if CInt(curPage) <>...

if curPage > 1 then response.write("<INPUT TYPE=BUTTON Value='Previous' ONCLICK=""document.location.href='pt_searchitem.asp?strSearch=" &pstrSearch& "&curPage="& curPage - 1 & "';"">&nbsp;&nbsp;&nbsp;") end if if CInt(curPage) <> CInt(totalPages) then response.write("<INPUT TYPE=BUTTON...

Good question... hang on

Any idea whats wrong with this... its wrapped in asp <INPUT TYPE=IMAGE SRC='images/next.gif' alt='Next' ONCLICK="document.location.href='pt_listcategoriesandproducts.asp?idCategory=100&curPage=2';"> this is missing last bit of url &curPage=2'

I've tried forcing data type Long but no joy