Nice, maybe you could put a link to their websites, if they needed to contact them, or just find out more info about them?

[TC]'s is: www.city-driving.co.uk
CLC's is: www.citylifecrew.net
STCC: www.simtouringcarcup.com
UKCT: www.ukct.net
ConeDodgers: www.conedodgers.co.uk/

not sure about the Redline and [FM]

Last edited by Bradracer, Sat, 12 May 2007 23:58.

"And you can rest assured that under no circumstances will the TiSP system ever expose your privates."

"I'm having trouble installing or using TiSP.
Your internet connection should be working within one hour of GFlushing the sinker. If you still aren't online after that period of time, your toilet may be clogged. Please flush three more times, then check your online connection again. If you're still experiencing problems, drop eight mints into the bowl and add a two-liter bottle of diet soda. For further assistance, please visit the TiSP Help Group."

Lol google always give me laughs on april fools day

Quote from imthebestracerthereis :

um http://www.lfsforum.net/showthread.php?t=21768

This is about speed humps, and that is about kerbs though

I think he was trying to be sarcastic

I used to have some problems connecting to the master server a few months back, while with Virgin Media (NTL back then), but that was only very rarely, and since then its been great, its very cheap too, compared to the AOL package I had before NTL, which was just unreliable, poor customer service, expensive, so I switched to cable, and ill never regret it

Oops, sorry I figured out how to do this, this thread can be closed now if needed thanks all

Hi sorry, just very quickly, Herki, you know the attachment you posted here first, you had this code in it:

Sheet2.Visible = xlSheetVisible: Sheet2.Activate

How can i reverse this, so I can make a log-off button, so it goes back to the entry sheet, but also re-locks and hides the other worksheets?

Thanks

Brad

Yea it is... but we are doing it at AS, we do a harder project at A2 with access. And that is true, everything is about office, would be a bit more interesting I have to say, if we worked with something else, but, well thats life

Yea ive done it now, thanks alot for your help everyone, much appreciated

Ok, Ive edited the code so it goes to Sheet 2 when the correct password is entered, but I cant find a code to close the form when it gets to the new page, cos otherwise it cant be closed without me clicking cancel... which closes the whole spreadsheet down.

This is the new code:

Dim Var1 As Integer

Private Sub CommandButton1_Click()
If Text2.Text <> "hello" Then
Select Case Var1
Case Is <= 2
If MsgBox("The password is incorrect", 5, "Incorrect Password") = vbCancel Then Unload Me

Var1 = Var1 + 1
Case Else
MsgBox "You have entered the incorrect password 3 times, login denied. The program will now terminate", vbCritical, "Locked Out"
Unload Me
End Select
Else
If MsgBox("Correct password, access granted", vbOK, "Access Granted") = vbOK Then Sheets("Sheet2").Select

End If
End Sub

Private Sub CommandButton2_Click()
Unload Me
MsgBox "Login cancelled by user", vbExclamation, "Invalid Login"
End Sub

Please help me, cos the deadline is only a few weeks away.

Thanks

Brad

Hi, thanks for that link, it was very useful, but I dont know how to transfer to another sheet, if the correct password is entered. The form is working nicely, but I need a bit of help linking it to another sheet, and programming a macro to open the form when a button is pressed.

the code is:


Dim Var1 As Integer

Private Sub CommandButton1_Click()
If Text2.Text <> "hello" Then
Select Case Var1
Case Is <= 2
If MsgBox("The password is incorrect", 5, "Incorrect Password") = vbCancel Then Unload Me

Var1 = Var1 + 1
Case Else
MsgBox "You have entered the incorrect password 3 times, login denied. The program will now terminate", vbCritical, "Locked Out"
Unload Me
End Select
Else
MsgBox "Correct password, access granted"
End If
End Sub

Private Sub CommandButton2_Click()
Unload Me
MsgBox "Login cancelled by user", vbExclamation, "Invalid Login"
End Sub


Please help Thanks in advance

Brad

Last edited by Bradracer, Thu, 22 Mar 2007 16:41.

Hi, thanks for the effort, but I have already got a password prompt im happy with in my system, I was just wondering if there is a way of modifying this code, so it only allows 3 attempts, then shows a warning box saying "You do not have access to this system, goodbye" or something along those lines, then the program closes?

The current password code is below:

Sub Password()

If InputBox(" Please Enter your Password", Title) = "letterbox" Then
Sheets("Front Page").Select

Else
If MsgBox("You have entered an invalid password", vbRetryCancel) = vbRetry Then
Password
Else
End If
End If

End Sub


Also, if anyone could try the export a data range to a word template, it would be brilliant

Thanks for your responses so far

Brad

EDIT: I can send you my current system, so you could get a better picture of what I need, and any other advice you have? Thanks.

Ok, well im doing a project for my alevel course, ive already got a password code that opens when I click a button assigned to that macro, but I was looking for code that only allows 3 failed attempts, then closes MS Excel down. Thats the first thing...

Secondly, I have a sheet with a table of data in it, and I need code to export this data (by specifying the right cell range) to a MS Word template, so it can be neatly printed out, and archived.

Thats basically it, with the second request being the most urgent, because the password code I have now would be ok if I cant find a better alternative.

Thanks,

Brad

Hi all, whoever knows about Excel / VBA coding, please please add me on msn: [email protected]

There are a few functions I am having problems with, please help me

Thanks in advance

Brad

Hello everyone, everyone at [TC] are happy to announce a new website and forum . They are also hosted on an upgraded server, so it should be faster, and more reliable than .co.nr.

Our webmaster has also re-designed and updated the website, so it now looks alot more modern and up to date.

Please check it out, as alot of hard work has gone into making and setting it up. The site can be found at:

www.city-driving.com

Thanks for reading,

[TC]>Brad

To the best of my knowledge, this is done with LFS Lapper, if you go to www.lfs-database.com the program should be there somewhere, im not sure how / if you can configure it to work offline though

Ok, the explanation about phlos using BF1 in jamaica...

Phlos hosts the [TC] CityDriving USA server for us, well he pays for it anyway.
He has obviously looked in the config file for the USA server, and got the admin pass, and started using it on the other servers.

I have spoken to him about this, and hopefully it will not happen again, otherwise we will be forced to ditch the USA server host, and host it elsewhere.

Im sure it is all sorted now, sorry for any inconvenience caused to anyone

-Brad

18.... [MG] Power

Hi, we have changed our server names to the following:

[TC] CityDriving UK
[TC] CityDriving USA
[TC] CityDriving Jamaica

Please note: these are the only servers we run at present, if you wish to contact is relating to these servers, please go to

www.city-driving.co.nr and either post in forums, or contact us privately via email

Thankyou,

Brad

The poll is here, already it is pretty conclusive, please vote, thankyou all in advance

http://stewoo10.100webspace.ne ... php?topic=238.msg1273#new

Please note: you have to login / register to vote, but registering shouldnt take more than a min, because validation is disabled

Last edited by Bradracer, Tue, 6 Feb 2007 21:57.

Quote from Becky Rose :

I think that's the problem you are facing, and I think it will continue to be a thorn in your side until you choose an identity that is unique.

I do totally agree, we did think about it before, but then we thought, "why change a formula that has proved so successful", but you are right, we are having problems, and will continue to face problems untill we differentiate our servers from the rest.

So we are having a poll on ours forums and are going to decide on a new name, we will post back when / if we change the server name.

Thanks for posting (almost) everyone

Well yes, it is obvious that we cannot do anything about it, but It would be nice to raise peoples awareness of these 'imitation' servers, so they know there is a difference, and to only direct comments to us if they relate to the servers we run

Quote from Nathan_French_14 :

i personally love your citydriving servers. i think you guys have put alot of hard work into it, there is always at least one admin on your servers and you try to encourage the rules as best as you can, and, if they dont listen, you still try to give them a second chance before you get rid of them (although most of them throw this chance back in your face as they are disrespcting nOObs!)

anyway, im going to support you for this as i think that something should be done about this!!

frenchy

p.s i seen an imitation of one of your servers last night, it was called city driving florida, have a guess what track it was put on?.....Blackwood Gp!! lol!!

Thanks alot, and that is the exact server we are talking about. Hopefully the admin will kindly edit the name

Quote from [RCG]Boosted :

anyway, its not like u would get lotta money if the server is always full...
and id talk to them personally instead of posting here, i guess that will work better

If we could talk to them personally, obvsiously we would do so, but, being a dedicated server, there is no way of knowing who hosts it.

Yes, we do put alot of work into the servers, and it undermines that when we have a 'rogue' server pop-up, which, generally, as alex said, have very little control and any reputation to worry about.

Obviously not everyone is interested in CityDriving, some people prefer racing or drifting. Personally I prefer both, seeing as im a part of [MG] and TC.

So dont start a war here please, whoever is interested, please feel free to post, but please be sensible

Thanks

-Brad