Hi
I'm trying to create a RegExp with this string so each Exp is separated, is this the correct object
X.21 V.35 G.703
...so each exp would be X.21, V.35 etc....
Hi
can anyone modify this query so it updates in a EXCEL sheet via asp
sql = "update s1 set box='"&box&"' where Eancode = '"&ean&"'"
Hi all,
I have an annoying problem, I have this forumla that looks for a value in another sheet then populates the another column in sheet1,
..this is in sheet1 ...
=VLOOKUP(B2,Sheet2!$A$1:$C$3917,3,FALSE)
I have another formula that looks up in another sheet called stockIn
...
Hi
How do i expand the first contion with and??
.... (H21>F21 and blah="on")
=IF(H21>F21,"OVER",IF(H21<F21,"UNDER",""))
Hi
Not sure if this is corect forum but here goes, I 'm trying to get the row number from a worksheet with vb at a given title
Ie;; At row 100 I have some text called 'End Row' I then want to get the row number this text s on, is this possible?
Hi
I have a problem with a popup, I use
buStartDate_Click as the link id to open a calander event but once I close the calender, THEN do something else and click the back button the event of the calender opens again? can anyone help
Hi all,
I'm using an arr out of getRows
arr = rsSplit.GetRows()
I know if i use arr(elementnumber,row) will give me the value, how do i get the column name out of the array
Many thxs inadvance
Hi all,
I want to get data back dependant on a row have two words
ie: 'Under Research' so i want the get the column data back if there is a space again this could change to
'X21 X25 X703'
How do i add a combo box to a cell in excel?
I've draw the control box and entered
Private Sub ComboBox1_Change()
'Add list entries to combo box. The value of each
'entry matches the corresponding ListIndex value
'in the combo box.
ComboBox1.AddItem "To Do"...
Hi
I'm trying to get a comma before the 300000 but with little sucess, any ideaas?
arrData(intCount) = "'300000"&Trim(arrData(intCount))&"' or sku like '*"&Trim(arrData(intCount))&"' or sku ="
Hi all,
I have a form with a TEXTAREA in it, I enter
12312,12312,1231231,
What i'd like to do is get each value out by the comma delimited.. is this possible,
How come if i run a query thus:
alter table products add COLUMN boxnumber text(25)
in the access query window it works but if i run the same query from a ASP page ie:
conn.execute("alter table products add COLUMN boxnumber text(25)") it dont work?
Hi all,
I have a default row value is 0 so I dont need any more zero's, how do i alter this code so i dont add zero's
-- does the COORD x exist?
Set @cmd = 'insert into CARRSITE.dbo.temp ([ID]) (Select [Id] from CARRSITE.DBO.GERMNFR_COORD where [name]=' + cast(@x AS VarChar) + ')'
exec(@cmd)...
Is it possible to get the text from this select with its id value?
<OPTION value=6>ABERAERON</OPTION>
<OPTION value=7>ABERCHIRDER</OPTION>
<OPTION value=8>ABERCONWY</OPTION>
<OPTION value=9>ABERCRAVE</OPTION>
<OPTION value=10>ABERCYNON</OPTION>
<OPTION value=11>ABERDARE</OPTION>
<OPTION...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.