if it has MORE than 2 "/" it will return True
Printable View
if it has MORE than 2 "/" it will return True
It works!! Cheers Simon!
ive only use inStr once before and it was hit and miss until i got i right...
if that's about my code simon, i've got iCountslash to count how many slashes there are, same as yours, just done a different way :)
Quote:
Originally posted by CyberSurfer
It works!! Cheers Simon!
It works!!! *faints*
simon - it's actually a proper win, if you goto www.bananalotto.co.uk, they have have a draw every day, no hassle, no spam, all you've got to do is click on an advertiser's link and close it as soon as it's open
yea i know that, just showing how funny these things can be... is this the most youve won?
BTW do you know anywhere where i can get decent little graphics animated or not for my avitari?
yeah first time, although i've only been playing it for about a month
3 balls - 50p
4 balls - £5
5 balls - £100
6 balls - £100,000
6 balls + banana ball - £1,000,000 (put's little finger at the side of his mouth:))
wat do you do to enter?
nothing much. just enter your name and address and you can play every day for free
Can one of you help me with this please...
it stops at Movelast and complains there is no record!!!Code:Dim DB As Database
Dim RS As Recordset
Dim sSQL As String
Set DB = DAO.OpenDatabase(DBpath, False, False, ";pwd=" & DBpassword)
sSQL = "SELECT * FROM holidaydata WHERE employee = '" & Department & "'"
Set RS = DB.OpenRecordset(sSQL)
Dim iRecords
RS.MoveLast
RS.MoveFirst
iRecords = RS.RecordCount
dont worry i got it, the table name is employee and the field name is dept.... me just stupid.... would one of you have a look at my little program once ive finished... id like some ideas on how i could make it better... Thanks
if the recordset is not reurning any row's you can't use any of the move function's without getting an error.
Try enclosing this
If RS.BOF = False AND RS.EOF = False Then
RS.MoveLast
RS.MoveFirst
End IF
Do you suspect that Parksie might be dead?
Congratulations Ian..........buy a beer for us all?????
I sure hope parksie's not dead. He said he was going to try to make it to class today. Maybe he's learning something instead of just chatting.
I wish I could Katie, 50p = 0.736200 USD
I hate to show my ignorance (as I usually pretty good at hiding it). Isn't 50p fifty pounds?
I wish it was, 50p is 50 pence, a penny is our equivelent to you dime's and cents
What a dissappointment. I was looking forward to that beer.