Search results for query: *

Hi I have recently recieved a request from a colleague. I have a query pulling prices for products, eg. the product no is in column A, price in column B, conversion factor in column C. So I am pulling the product & Price via a query and need to add the conversion factor to column C. Data...

Hi I have a VLOOKUP that I need to use to enter info vertically =VLOOKUP($A1,cust,1,FALSE)(CUST IS A DEFINED NAME) If I fill down all is ok but I want to fill across keeping the absolute reference (A1) but allowing the lookup column to change from 1 to 2 to 3 etc. eg...

Hi I have a query that returns the following: Prod w/h cost N1141D 90 0 N1141E 90 0 N1146A 01 0.95 N1146A 90 0.95 N1146B 90 0 N1146C 01 0.6 N1146C 90 0 N1146D 90 0 N1146D 01 0 N1146E 90 0 N1146E 01 0 N1147A 01 0.13 N1147A 90 0 N1147B 90 0 N1147C 01 0.12 N1147C 90 0 N1147D 90 0 N1147D 01 0...

Hi I have a spread sheet where I want to return a value if a field equals a specific value. in the statement below you see if($EJ14="K1" then return "FERT". The thing is I idealy want to return "FERT" if the $EJ14 field equals anything ending in 1, I have tried adding a wildcard so that it is...

Hi I have a dell latitude which is all USB no PS2 The PC boots (sometimes) but although on the post I get F2 to setup, F12 boot sequence, as the keyboard and mouse are USB the drivers do not load until after the choice exits. There have been a couple of times recently when the PC partially boots...

Hi I have a desktop running XP and a laptop running Vista. The desktop is wired to a wireless router and the laptop connects wirelessly. I have a printer that has network capability. My question is how can I connect the printer so that both computers can see and print to it? Do I need to setup...

Hi I have a number of machines in a domain , but I have 8 in particular that I cannot ping. I can ping other PC's in the domain from them, but cannot ping to them from any other PC. They are showing in AD as members of the domain infact everything seems fine i.e. they can access all domain...

test AJD

I have a system running on an Oracle database which uses CLOBS and BLOBS. CLOB: Character Large object BLOB: Binary Large Object Is there any way I can access the data contained in these type of fields with Crystal. I have attempted to create a report with Crystal 8.5 & 10 and although I can...

I have a pc with 2 partitions c: (5gig) & d: (60gig) with win98 on c: and XP on d:. I have a menu choice on bootup which to choose. I wish to get rid of the win 98 install and whipe the c: drive totally and be left with just the XP install on the d: drive how can I accomplish this without...

Hi I have a IBM thinkpad T30 laptop, and for some reason after I have had it on for approx 4 hrs it just switches off , no windows is shutting down, no blue screen , nothing just bang and off it goes . Then I cannot start it back up for approx 12 hours. Anyone with any ideas on this one. :)

Hi I have a microsoft access report containing 6 columns. This report is generally opened and then e-mailed. when the report is opened in access it looks fine. I have 3 people that mail this report out to thier respective departments 2 out of the 3 can mail with no problems and no formatting...

Hi I have a microsoft access report containing 6 columns. This report is generally opened and then e-mailed. when the report is opened in access it looks fine. I have 3 people that mail this report out to thier respective departments 2 out of the 3 can mail with no problems and no formatting...

I need to write reports in Excel, Access, Crystal. I have my ODBC connection setup to a sql 2005 server but after about 5 mins in both Excel & Access the connection drops and I loose all my work. The ODBC drivers I am using are provided by Microsoft version 4.00.6304.00, the file is...

How can I change the server a query is pointing to in excel. The server it was oriiginally pointing to is no more so I can't even get into the query to edit. I need to keep the query exactly as it is but just change the source server. Can this be done? Tahnks in advance

Is there a way I can setup an ODBC connection by sending multiple users a Batch file or Automated file that I can insert/add all parameters ,and they just run it to setup the connection?

I have both win XP and Win 2000 machines that I need to run a utility from a bootable floppy.I can create a bootable floppy in XP but not in Win 2000. If I create a dos boot disk in XP will this work with Win 2000. AD

I have just passed my MCDST, and would like to know if there is an enhanced/expert version of this.

When I select "Run" from my start menu I enter what I want to run ie cmd and I get this message " D:\WINXP\system32\cmd\cmd.com D:\PROGRA~1\\Symantec\S32EVNT1.DLL. An installable Virtual Device Driver failed Dll initialization. Choose 'Close' to terminate the application." I have looked in...

Hi I have a problem where if I run any (semi)CPU intensive process i.e. defrag, scan photo, resise image , virus scan, etc the cpu runs at 100% and the system freezes. The mouse and keyboard stops responding. I am running an: Athlon 2.2 ghz XP2800+ 768 mb ram Win XP SP2 NIVIDIA GEforce4 MX440...