Shrimpersfan

Managed to sort this thanks to srochfords tips. Thanks all

ok going from the vendor device, it says the vendor is atheros, doesn't seem to be able to find the device though.Anyone hsve any idea how i upload a screenshot?

Thanks srochford At the moment when i boot my machine up it tries to install the hardware, when i ask it to automatically install the hardware and drivers it cannot find the drivers (hence the whole problem lol). Would i be able to install the hardware without the drivers? At the moment the device does not appear in my device manager. David

Cheers guys, i'm at work at the moment but i'll check later and let you know. Thanks again. David

It's a desktop, I have taken the NIC out and it's and fairly sure the manufacturer is edup but not sure what model it is.

Hi there I have recently rebuilt my machine but am not sure on what make and model of wireless NIC i have installed, Vista cannot find them automatically for me so i was wondering if anyone know's if there is a way i can find out what card is installed. Thanks in advance David

I have a printer with different trays on, tray 2 is used for headed paper and tray 1 is used for plain. Is there a way to make it so on all word documents the tray settings are the same? I would normally look at the settings on the printer but there isn't an option to select different trays for different pages. David

ok so this morning i played around again and i seemed to have this fixed. However, i need to modify the registry within a citrix environment. I have tried this but without success, the registry changes on my local machine when i log in but not when i log in to a citrix session. Both my local login and citrix login are using the same login script.

Hi there. I am currently trying to edit a login script batch file in order to change the decimal value of a registry key. This is the text for my batch file (actual server names have been replaced with ServerName):- net use p: /delete net use q: /delete net use t: /delete net use p: 'serverName' net use q: 'serverName' net use t: 'serverName' regedit /s \\128.54.12.17\netlogon\Del_disableditems.bat /**regedit.exe /s ScheduleContactManager.reg**/ ftype MSPaper.Document="C:\Program Files\Common Files\Microsoft Shared\MODI\11.0\MSPVIEW.EXE" assoc .tif=MSPaper.Document ftype MSPaper.Document="C:\Program Files\Common Files\Microsoft Shared\MODI\11.0\MSPVIEW.EXE" assoc .tiff=MSPaper.Document This login script is currently used for when certain users log in, i added the part marked with /** **/. The .reg file is saved in the same folder as the .bat file, I have gone into AD and changed my logon script to this newly created one but it doesn't seem to edit the registry when i log back in. Any ideas would be very welcome. David

Hi there I am trying to update a field in our contact table. I have a view which contains all of the contacts that i need to run the update for, my question is: How do i update a contact table but only update the contacts that are in my custom view?

Hi guys Wasn't completely sure which forum section to put this under. I am using a piece of automation software called Taskcentre, this has it's own database. This morning we were having issues with the software and it turns out that an essntial table has been cleared of all data. There are currently no backups for the database and all tasks that have been created over the past year are now gone unless i can find a way of restoring the database to 2 - 7 days ago. I was wondering if anyone had any ideas. David

Hi there, I have created an insert statement to create a new record in a database. This is used from a task automation program and the client record is mapped using that so records ARE created on the correct client but i only want 1 record to be created, at the moment if a client has 10 quotes then it will insert 10 new quotes instead of just 1. My code is below: CREATE PROCEDURE [dbo].[ietsp_CreateDODQuotes] @ContactID AS INT, @TaxYear AS INT AS SELECT @TaxYear = TaxProYear FROM FlightDeckTest.dbo.iet_TaxYears ty WHERE IsCurrent = 'T' /** Add PTM DOD Quote **/ BEGIN INSERT INTO FlightDeckTest.dbo.Lead ( ContactID, Owner, Status, EntitySubType, ietCreateDate, ietMumbaiStatus, ietTaxAdmin, ietTaxYear, ietQuoteIncl, ietQuoteExcl, ietVAT, ietProdServID, ietProdServDesc, ietPayMethod, ietCardType, ietCardHolder, ietCardNumber, ietAcctNo, ietSortCode, ietIssueNumber, ietSecurityCode, ietInstallments, ietMonthRepay, ietFinalWithIns, ietFinalInstallment, ietAcctName, ietBankName ) SELECT l.ContactID, l.Owner, 'AWAUTH', l.entitySubType, GETDATE(), 0, l.ietTaxAdmin, @TaxYear, l.ietQuoteIncl + CONVERT(DECIMAL(7,2),176.25), l.ietQuoteExcl, l.ietVAT, l.ietProdServID, 'PTM DOD - ie taxguard', 'INVTP', l.ietCardType, l.ietCardHolder, l.ietCardNumber, l.ietAcctNo, l.ietSortCode, l.ietIssueNumber, l.ietSecurityCode, l.ietInstallments, l.ietMonthRepay, l.ietFinalWithIns, l.ietFinalInstallment, l.ietAcctName, l.ietBankName FROM FlightdeckTest.dbo.Lead l INNER JOIN FlightDeckTest.dbo.Contact c ON l.ContactID = c.ContactID WHERE ((l.ietProdServDesc LIKE '%PTM%' OR l.ietProdServDesc LIKE '%Tax Return%')) AND (l.Status = 'ACT') AND (l.ietTaxYear IN (SELECT TaxProYear FROM iet_TaxYears WHERE IsCurrent = 'T')) END GO Any help would be greatly appreciated.

I have an application which uses a SQL connection and brings data into a datagridview. The app allows the user to take this data, make changes on it and then save these changes. This is fine when the user only brings back and manipulates around 100 - 1000 records, when the recordset is higher than this, all records that have been manipulated get inserted into the database apart from 1 record. The error message within the application says 'Cannot insert NULL value into column 'QuoteID', column does not insert NULL's. Insert failed. The app always brings back this error when using a large recordset, when i look in the db to see how many had been imported, every record is saved except one. Just wondering if anyone had come across something like this before.

Thanks guys. I work as a software engineer so hardware isn't really my speciality. Thanks again

ah so ATA = IDE?