doh..
that is what I write on the beging but for some reason it didn't work as well so I tried ||...
now its working, thanks....
zivon
Last Activity: Mar 12 '08, 06:54 PM
Joined: Aug 28 '07
Location:
-
Case sensitive... lol..
insted of
this:Code:hid.showlim.value = R_showlim;
...Code:hid.ShowLim.value = R_showlim;
Leave a comment:
-
The file is not read-only, maybe the server managment, but I have no idea how to change it... its on my pc..
any way, when I try the line you just gave me this is what I get:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/setup.asp, line 20
this is the line:
...Code:sSQL
Leave a comment:
-
first thanks for answering.
what you gave me give me the folloing error:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only.
/setup.asp, line 42
so I tried 3, 4
and it didn't give me any error, but also didn't update the records : \
maybe this is not...Leave a comment:
-
if statment.
hello everyone!
I have a form for changing a user password, and a javascript code to check it.
it needs to check if the newpass, and the verfaction is the same..
the problam is that it always return to me that its not the same even if it is.. :\
...Code:if(R_newpass) { if(R_newpass||R_vernewpass) { mas += "Verpass does not match newpass \n"; -
update recored sql
I'm making a form for changing a user password and information
and tring to update the recoreds.
maybe the problam has nothing to do with what I'm thinking.. but that is what I tried:
when I try
rs.Open strSQL, oconn
or
rs.Open strSQL, oconn, 3
or
rs.Open strSQL, oconn, 2
or
rs.Open strSQL, oconn, 1
or
rs.Open strSQL, oconn, -1
I... -
problam solved, thanks everyone.Leave a comment:
-
Error on page on clicking button - maybe if statements problem
actully, I have no idea how to describe the problam, and I can't find it aswell...
I have a botton which call a javascript function.. and for some reasone it writes: "Error on page" when I click on the botton.
if I remove all the if statments from the function it works just fine...
I hope someone could help me out and find what the problam is..
thanks in advance,
Idan
... -
Thanks for you both :)
Have a nice week !Leave a comment:
-
how many items SQL
hello everybody!
I have an sql statment, and I want to add all the data into an array.
when I declare the array I need to write the amount of items.
how can I know before I do the loop rs.EOF = false
how many items the sql statment has ?
thanks in advance,
Idan -
thank you
it solved only one problam... the rounding of the number.
I have two types of discounts one using * and the other using -
this solve the other problam but uses two lines.. is there another options ?
If Operation = "*" Then x = (UPrice * Discount)
If Operation = "-" Then x = (UPrice - Discount)...Leave a comment:
-
calculate string+integer..
Hello everyone !
I made a price calculator for a guest house.
I have diffrent sale campaigns, all the time, I made a table with campaign name and discount, for example: name "pensioners " discount "*0.9".
10% discount, now I want calculate this with the price.
The price is integer, and the discount must be a string, because of the */-
how can I calculate them anyway... -
thanks mshmyob :) thats exactly what I needed.Leave a comment:
-
sub for record change?
is there a way to excute a command on record change ?
I used form_load to check something, but when I go to the next/previews record it doesn't recheck..
Code:Private Sub Form_Load() If RefBy.Value = "test" Then ReferredID.Enabled = True End If End Sub -
thanks FishVal ! :) its exactly what I needed....Leave a comment:
-
how many records are being displayed
Good week everyone !
I made a botton that changes the form filter.
I want to display how many records are being displayed after the new filter, is there a way to retrieve it ?
Me.LSum.Value...Code:Private Sub Refilter_Click() strFilter = "[ReferredBy] = '" & Me.Ref.Value & "'" Me.Filter = strFilter Me.FilterOn = True End Sub -
well... no.. :)
its working :)
thanks!Leave a comment:
-
Select statment, syntax problam.
I'm making a reminder, and I want to select all the notes that thier time is passed already.
this is the code I'm trying:
the problam is how to combine DateDiff('n',No w,ReminderDate ReminderTime)Code:LSQL = "select ReminderMark,ReminderDate,ReminderTime from Calls WHERE ReminderMark and DateDiff('n',Now,ReminderDate ReminderTime) < 1"
I've tried also using &
... -
thanks for the information, that was exactly what I wanted to know...
there was another problam that wouldn't let it work.. but I found it as well..Leave a comment:
-
Clearing an array.
Sorry for the stupid question... how do I clear an array ?
I'm using an OE email sending code that I found on this forum.
when I send to a second persone it tries also to send to the first one (everytime it just add a new email address to the array)
...Code:Private Sub RecipientAdd(ByVal lngType As Long, Optional ByVal strName As String, Optional ByVal strAddress As String) Dim r As MAPIRecip r.RecipClass
No activity results to display
Leave a comment: