Recent content by optjco

OK, I have sorted it now, i unregistered the ocx and then re-registered it and it works now. Thanks for everyones help Regards Olly

Mike, did as you suggested and you are right on the machines that work there is a control called microsoft date and time picker control 6.0 (sp4) and the ocx is located in C:\windows\system32\mscomct2.ocx so i copied the ocx on to one of the machines that was not working and then used...

PHV checked all the references on all the machines and they are all the same. This is what I don't understand Regards Olly

I wonder if someone can help me, I have a user form that has an date time picker on it and this is working fine on some machines but not others. All the machines are running XP and Office 2000 yet two of them will not load the form and giving either a run time error run-time error'-21437352573...

HarleyQuinn/PHV Thank you both for your suggestions, I will try them both tomorrow Regards Olly

Skip/PHV Thank you both for your help, code works great now Regards Olly

I am using SYSGetUserName to populate a label on a form with the appropiate username however this could be in one of three different cases i.e. JBloggs jbloggs JBLOGGS I would like to be able to convert the name to lowercase at all times This is how I populate the label now...

Skip, thanks for the reply, I tried your code but got this error message Invalid or Unqualified reference at the following lines [code] LoadObjects: .Cells(Prow, Pcol).Value = txtCust.Value .Cells(Prow, Mcol).Value = txtMB.Value & txtDash.Value & TxtItem.Value .Cells(Prow...

Hi everyone, I have inherited a spreadsheet that is pretty much controlled via VBA, it contains several forms, on one of the forms there is code so that if certain people are using it then they can do more than the ordinary user however it is quite long and cumbersome to administer and i was...

MOrac, I did as you suggested and put the positional style in the html however i did not realise that when the javascript ran that the settings in there would be offset by the amount that i entered. i.e my html position was 50px left and 20px top and my javascript settings were 200px left and...

MOrac, thanks for that it works fine apart from the fact that when the page loads initially or when the page is refreshed to image still shows in the top left hand corner until it changes to the next image and then it shows in the position i stipulate. Any Ideas on that Regards Olly

I found this piece of javascript code on the net which scrolls through images, i have tried to add top & left co-ordinates to it so I could move the position of the images however it does not seem to work could someone have a quick look to see what I am doing wrong Please This is the original...

OK,thanks that should not be a problem the server that our Intranet is on has 1GB memory. I am thinking along the lines of having one include for all my vbscript functions and one for all my javascript functions, and then doing as you suggested with the CSS by linking them. Regards Olly

Sorry Chris, just one more question, If I say add all of the functions I use for a particular subject on our intranet(which may contains up to 20 pages) into one include page even though some of the pages may only use one of the functions, will this slow down the refreshing of pages ? Regards Olly

Chris, thanks for that, it has helped me understand better the use of includes. I will start trying it tomorrow although i am sure I will be re-visiting this post for more info if need be Regards Olly