drspa44

I have a table in MS Access with two fields, JobID and VolumeNo

I want to perform a text query on the table to find out which volume a job is on.

Using this doesn't bring up any results, despite there being a record for job 543543a:

SELECT * FROM tblJobs WHERE (JobID="CONTAINS '543543a'");

Thanks in advance.

http://oi52.tinypic.com/2qcfk9l.jpg

Have I applied the correct graph transformation here? I wasn't sure whether I was supposed to flip vertically, then turn the negative values of y into positive.

Any help will be greatly appreciated!

When you run Memtest86, it shows the speeds of the L1/L2/L3 Cache in the top left corner. This is regardless of whether you get errors or not. I want to know, when Memtest is run on separate occasions, is it likely that these values will fluctuate by more than 1 or 2MB/s.

I ask because it seems that on my laptop using an i5, the cache speed would vary by 5-20% and I got errors on some occasions, but not all.

Whereas on my desktop PC with a AMD Phenom 955, the cache speed wouldn't fluctuate by more than 1MB and this seemed to coincide with the clock speed being measured at 1MHz lower. I got errors, but these were solely due to faulty RAM.

BTW, I'm not talking about fluctuation during the test, but between separate tests and a reboot.

I would be very interested whether your cache speeds fluctuate, especially if you have a Core i3 or i5. Would you mind checking? :)

When I disconnect my laptop from ac power, the frame rate drops by more than half on games. I know this is to preserve battery life, but I don't care. How do I stop my graphics chip (nvidia gt 240m) from underclocking when moving to battery power?

I've just bought an Acer Aspire 5739G, which sports a Intel Core 2 Duo 2.2GHz CPU and a nVidia GT 240M. Compared to my last laptop which was incredibly inefficient with a lot of heat and fan noise, this new one seems to be a lot better (i.e. my left knee does not get painfully hot). However, this Acer has the habit of turning itself off when it overheats, but checking the temperature using SpeedFan, it does not seem particularly hot. At about 80C, the fan reaches its maximum speed and in my CPU intensive test, the CPU reached 85C and stayed at that temperature for about 20 seconds until the laptop cut the power. This is on mains electricity btw (not battery).

My question is, is 85C a suitable cut-off temperature for a dual core CPU? How hot does your CPU get at maximum load?

Playing GTA4, the temperature is around 70-80C, which I would have expected. If there is anything blocking ventilation, even if it is not actually touching the vents, it can easily cause this to rise an extra 5C, which seems totally unacceptable for a laptop marketed as a budget gaming laptop.

I'm starting Computing A-level next term and we've been told to practice writing a few basic programs in VB. I am trying to program this ebay calculator, but there is a problem with the final output. It doesn't print the amount of commission or profit. It just prints "Your commission is" and "Your final profit is". I suspect I've written something wrong with the Console.WriteLines at the end, but I'm not sure what...

Module Module1

Sub Main()

Dim EbayPrice As Decimal

Dim EbayPostage As Decimal

Dim ActualPostage As Decimal

Dim Commission As Decimal

Dim Profit As Decimal

Console.WriteLine("enter the selling price of your eBay item w/o postage")

EbayPrice = Console.ReadLine

Console.WriteLine("enter the postage price of the eBay item")

EbayPostage = Console.ReadLine

Console.WriteLine("enter the real postage cost of the item")

ActualPostage = Console.ReadLine

Console.WriteLine()

Console.WriteLine()

Console.WriteLine()

Console.WriteLine()

Console.WriteLine()

Commission = (EbayPrice + EbayPostage) - (EbayPrice / 10) - 0.2 - (0.966 * (EbayPrice + EbayPostage))

Profit = Commission - ActualPostage

Console.WriteLine("Your commission is", Commission)

Console.WriteLine("Your final profit is", Profit)

Console.ReadLine()

End Sub

End Module

I've done it many times before. Often when there was some pesky equation or fact to remember. It's not like I'm cheating as I'm not copying it from a book or looking in the question paper early, but I was stopped this morning and told 'you can't do that'. There isn't anything in the candidates exam guidelines that forbid this, but is it an unwritten rule?

I thought it was relatively easy, especially compared to previous years. The 'grandmother' culture poems were straightforward, but there seemed to be a lot to get out of them. The A/R/C writing section was a bit out of the ordinary. Our class was told before to continually write in the third person for those questions which was impossible in today's paper! I don't see myself as having any influences, but I wrote about Ned Flanders and his ideology.

Each episode is full of its music!

http://vlc.us.com/best-media-player/vlc-media-play...

If you do a search for VLC, firefox, acrobat or any other popular free piece of software, there are always fake google sponsored links offering free downloads of 'Firefox 2010 edition' or 'Acrobat PDF reader optimised for Vista!'.

Obviously they have nothing to do with the real software makers, but why do they pay google for people downloading their dodgy spoofs. Is it adware or something or do they bundle lots of toolbars and addons to the installation? I don't really want to try it for myself!

Any ideas, please help.

I was thinking it might be a good approach to answer questions like "How well does Ralph cope at being chief (in Lord of the Flies)?", by giving individual reasons for and against as well as an introduction and conclusion. It would probably reduce the amount of waffle and repeating oneself and be quicker to plan.

I'm not sure though if this is the best method of answering though.

Thinking of selling an ebook on ebay, but it won't be worth it if I get charged 20p!

Thanks.

I bought four copies of Pokemon Platinum from ebay ( http://cgi.ebay.co.uk/ws/eBayISAPI.dll?ViewItem&it... ), which arrived and are clearly fakes. I went to Paypal for a refund and instead after over a month of waiting I get:

In order to continue with the investigation of your complaint, we must

request documentation to support your claim that the item is not authentic.

Please obtain a document from an unbiased, third-party, such as a dealer,

appraiser, or another individual or organization that is qualified in the

area of the item in question (other than yourself), which clearly

identifies the item as not authentic. If possible, the document should

include a serial number and description of the item, and must be on

letterhead that includes the name, address, and phone number of the

individual, business, or organization so that PayPal may contact them if

necessary.

The documents should be faxed to PayPal at 08707 303 196. Please include a

cover sheet with your fax that includes the email address registered on

your PayPal account and the ID number of your claim PP-803-906-351, so we

may attach the documents to your claim as quickly as possible.

We must receive your fax within 10 days from the date of this message in

order to proceed with the investigation of your claim. If we do not receive

your fax within 10 days, your claim will be cancelled. We are unable to

grant extensions to this time period. Please note that PayPal is unable to

reimburse you for any costs or fees that may be incurred in obtaining the

requested documents. Any documents you provide may also be supplied to the

seller in your dispute if necessary.

How am I going to get proof that they are fake? A high street game shop isn't going to care - what's in it for them? What should I do?

I'd greatly appreciate any help. I'm very new to PC building myself and I'm helping out a friend with a £500 budget for a new PC which is capable of doing the Sims 3, Flight Simulator X and Google Sketchup at high settings. Not totally maxed out, but good enough to make the games look good and play at 40fps. So, I'm hoping someone in the Yahoo answers community could advise me about which components I should configure.

I think that when browsing a barebones PC, I should check that the PSU has enough wattage to support a dedicated graphics card. I wondered if this would be a good choice:

http://reviews.cnet.com/barebones-pcs/asus-v-serie... or http://www.ebuyer.com/product/141522 . The asus one is priced £70-£80

I think it would be best to go for either a powerful Intel Core 2 Duo (sa E7400 2.8GHz) or weak Core 2 Quad (sa Q8200 2.33GHz). I was fishing on ebuyer and found this: http://www.ebuyer.com/product/152177 . Again, could I do better for the price? Or the same horsepower for less price? BTW, do they come with CPU fans and thermal paste or do you have to buy them separately?

Graphics cards wise, I've been eyeing 4670s on ebuyer at £54, but I think I could get something cheaper as the sims 3 and FSX aren't very needy compared to other games. I know you don't need much to run Sketchup. I'm hoping to spend about £30 to £50? ATI or Nvidia is fine. Personally I prefer Nvidias naming scheme.

I've already got lined up:

£35 for 4GB of RAM http://www.ebuyer.com/product/146049

£9 for 802.11g card http://www.ebuyer.com/product/132449

£40 for 500GB HDD http://www.ebuyer.com/product/124228

£14 for DVD drive http://www.ebuyer.com/product/97527

£90 reserved for a 19" monitor

£20 reserved for mouse, keyboard and USB speakers

£50 reserved for Windows 7

So £242 left to spend on a barebones, CPU and graphics card. I'd really love your suggestions on how to configure this PC. I want to make it future proof to last a few years and be upgradable.

I'm also looking for components that won't keep running out of stock, even if it means paying a premium. Any other PC building advice for someone new to this would be greatly appreciated. Thanks in advance.

In the UK everyone calls it an iPod Touch. I'm seeing a lot of questions here about "how do I fix my iTouch???!".

I'd be grateful if some people could tell me very quickly:

1. Which is your favourite web browser you use? And a few words why?

2. If that browser were to disappear, which would you use? And why?

Thanks very much. I only need a few words to explain why, for example:

Q1: Firefox - I like the plugins and interface

It has to have a topping such as chocolate chips or fruit and it has to be easy to memorise. I have a mock GCSE Food exam and I need to remember the ingredients and the process of making it.

Does anyone know of a simple recipe? The exam btw is below:

http://store.aqa.org.uk/qual/gcse/qp-ms/AQA-3542F-...

Is there any chance of the peripherals getting an overdose of power? Or could it damage the USB bus on the computer in any way? I have the UK version of this: http://www.amazon.com/Belkin-F5U218VMOB-USB-2-0-Th...

Thanks a bunch

Just to estimate my score... It wouldn't be cheating since the exam's all done and dusted now.