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?

Gigabyte GA-945GCM-S2L i945GC Socket 775 onboard VGA 6 channel audio mATX Motherboard - Ebuyer

Hi there. I am looking to purchase a new motherboard and need one with an IDE connection on it. From looking on Ebuyer, i noticed that many of their Intel boards have IDC connections. What i was wondering was, is IDC the same as IDE?

Hi all. I am trying to use the DATEPART function on GETDATE() in the WHERE clause. I need to only show the results if GETDATE's month is not in December or January. Any ideas? Cheers

I have an application which allows the user to select multiple combo boxes and then display data in a datagrid view depending on what is selected in the combo boxes. However, one of my fields is called 'Fee'. Obviously, this is a decimal value, I am trying to use a combo box to select a range of fees (0 - 150, 151 - 200 etc). For the other 3 combo boxes on the form, the values are coming from a stored procedure, however, i cannot do this for the 'fee' field because i receive errors when it tries to convert to decimal. The text in my combo box will be like the example above (0 - 150) but the values in the database are formatted differently (150.00, 170.20). My question is, how would i be able to filter out results in my datagrid view by using a range on the 'fee' field, i thought about a case statement but at the moment it just brings back a datagrid with 'rowerrors' as a column title.

Hi there. I currently have an application where a user can select items from a combo box and then display the results in a datagrid view depending on what is selected in the combo box. This is fine because the user is selcting an exact match from what is in the sql connection but i need the user to be able to select a range from a different combo box, ie - if a field/row in the datagrid is 'Total' then i would want the user to be able to filter out all totals between '100 and 200' or '201 - 300' etc. I have tried using a case statement but am unsure if this is the right way of going about it.

Thanks Jay. I can see how this may work. How would i get the results of the sproc to appear in a datagrid view?

I am making a windows app in vb.net and am using ADO.net for my sql connections.

Hi there. I have a form with 3 combo boxes on, each with a random number of items in them. What I am trying to do is to let the user select items from the combo boxes and then generate the sql query based on what they had selected, i would then want to display the results of this query in a datagrid view. I am fairly sure i will need to use a sproc to pass parameters for the fields i will need from the app to the database but i am pretty much a vb novice and have only recently started using sql connections through it. Any help would be greatly appreciated.

HI Pashers. Thanks for the reply, what I am doing is opening this website within a CRM we use. We do not want the webpage to load in full screen. A scrollbar along the right is fine but we want to remove the scrollbar along the bottom. I think your code may work. David

Hi there. I currently have a website and on a couple of my pages there are horizontal toolbars that I wish to remove. I'm pretty sure that there is a way of removing these but am not sure how. Just wondering if anyone had any ideas? David