Recent content by itsmarkdavies

Many thanks for all your replies - i know it is definitely the lead from the switch to the mobo now - dismantled it all and one of the green/black twisted wires is split !. I know nothing about soldering so it looks like a hunt round PC shops to find a spare (if anyone knows a UK website i can...

Thanks Ed, i'd be happy to let the lead hang loose, but i cannot find ehere to buy ANY kind of appropriate switch / lead.

Thanks for your reply Roger, i tried using the Reset button / wire but this does not work with the power switch either (which may mean that it's the pins on the motherboard that only respond to manual shorting ? !). I have inspected all the wires and they appear to be intact and in good...

I have an older model MESH ATX Tower and recently it would not turn on - i pressed the power switch on front of case and absolutely nothing happened. I bought a new power supply and still nothing. By process of elimination i think it must be the power button / lead on front of PC, as i can short...

Hi, i have an Excel 2000 Workbook that connects to a SQL Server 2000 database and also runs quite a bit of Excel VBA behind the scenes to call Stored Procedures and run SQL against the database. The problem i have is that when 3 or 4 Users open the Workbook at the same time it seems to be...

Recently i have had the problem of having no mouse when booting Win2K SP04. It only happens occasionally but the only fix seems to be a reboot and then it appears. When it's gone, the "Hardware" tab in Mouse properties in Control Panel shows nothing (i.e. loses it's entry), but after a reboot...

Hi Skip, it looks like "txtOrgFilter_ShortNames" is just the name of a Text Box on the Worksheet, and "LoadMyView" is a Function behind the Worksheet. NB :- All the code works perfectly if run in Excel 2000, it is only when i try to run it on Excel Version 2002 or 2003 that i have these...

Thanks Skip, please find code below. The lines beginning with "XXXXX" appear to be the ones causing the problem :- ============================== Code causing RunTime Error 438 ============================== Public Function SetOrgFilter() Dim sSQL As String Dim rsOrgIDFilter As Recordset...

Hi , i have been given an Excel 2000 application to support and all our new office PC's are running Excel 2002 / 2003. The application uses quite a lot of VBA behind the scenes, and when i try to load the app on the new PC's, i get "RunTime Error 438" (and also "RunTime Error 57121" after i...

Can anyone tell me if there is a maximum DTS Package Log File Size, and if so what is it and can you change it ?. Also are there any consequences of running the Package if the Log File is already the maximum size - presumably the Package fails, or atleast does not log ? Thanks for your help...

Thanks Chance, looks good, i`d not come across "Target" before. mark.davies@npower.com

I have a Worksheet in a Workbook containing Hyperlinks to other Worksheets in the same Workbook. I want to prevent the Users using the arrow keys on the keyboard to move into the Cells containing Hyperlinks, and then typing over the Hyperlink Text. I have tried different combinations of...

Does anyone have any C#.net code to use the SQLDMO Library to obtain Job History for SQL Server Scheduled Jobs ? Thanks. mark.davies@npower.com

Apologies if this is something that I should know, but I was wondering if someone could explain to me why some Strings in SQL Server are preceeded with N'. For Example, in Books Online under "sp_addlinkedserver", the example says :- EXEC sp_addlinkedserver 'SEATTLESales', N'SQL Server' and...

I am wanting to make a copy of our VSS database available on a completely different Server, so that if our live Server goes down, we can still access up-to-date documents on the standby Server. I realise that I could just copy the main top-level folder and all it's sub-folders to the other...