Search results

Hi all! Does anyone know why when I use the autofilter to filter a set of data in Excel to show lets say just records with "421" in the "Fleet Number" column, it removes thousands of blank rows aswell and then shows a blank row at row # 6023 for example? It used to just display all the 421...

Hi, I was wondering if anyone knows how to do this: Cell A1 = Sum(a1:a10) Cell A2 = sum(a11:a20) Cell A3 = sum(a21:a30) Is there anyway to drag this down so it fills in the formula automatically? Thanks very much. Ross

N Plate - Rolling Stones edition My Dad's having it so maybe I should fix it properly lol

I was given the car for nothing so I'm just trying to get it through and MOT and flog it.. Any ideas how much it would cost at a body shop to get 2 little holes patched up?

Just wondering if anyone knows the MOT rules on rust etc? I've been given a Golf thats got 2 rust holes on the NS sill, neither of them are any bigger than a 50p coin and I was just wondering if this is an MOT failure. If it is, if I filled them with some P40/P38 sanded it all down and...

I thought if the speed sensor was faulty the speedo needle dropped to zero now and again, mine has never done that. How do i test for a vacuum leak?

Is there an easy way to test if its leaking? I looked at the pipe when the engine was running and where it joins just under the inlet manifold it has kind of sucked itself together. Is that what it is supposed to do? Also..I haven't taken my battery off since replacing the ICV and TPS so...

Hi everyone! I've been having problems with my zetec focus 1800 for a few weeks now. Basically when I pull up at lights the revs go up on there own for a few seconds and then drop again - it seems to be related to whether the car is moving or not because when I come to a complete stop thats...

Can anyone please help with this? Its doing my head in! lol Thanks a lot, Ross

Hi, I'm trying to create a form which has the following fields: First Serial Number, Last Serial Number, Succeeding Letter I then want the form to automatically create records in a table where the field SerialNumber is automatically created; using the range specified and adding the...

Hello. Is it possible for a query to filter and sort the results and then just give me the first 5 results from the top of the list? Its basically an allocation database and Ive got a table with loads of serial numbers that need putting in batches of 5, so I need the next 5 that havn't been...

Hi, Can anyone help me, I need to have a form with a text box which is to be used as a search key. However the search key could exist in upto 4 fields in the table. I need the results to display all 4 fields if the key exists in any one of them? Does that make sense? Thanks a lot. Ross

Even if your past the sign that says your no longer on a motorway?

Hi all, Long time no speak. My mate broke down last night on the motorway exit slip road and his engine has ceased so there was no repairing it at the side of the road. The hard shoulder is extended up the slip road and we tucked his car as close to the kerb as possible. We were pretty much...

Hi, I have an 1994 Mk3 Astra 1.4 and a JVC bog standard cd player and when I first installed it the stereo forgot all the presets everytime the ignition was turned off and did not have any power at 1 click of the key, this morning I decided to try and fix it. I did a bit of research and found...

Having one next month to confirm Coeliacs disease - I'm so gutted I might have this means I can't even eat biscuits!!! Who cares about the endoscopy I just want my results. Anyway, I'm going for the spray, I want to be able to drive home straight after. How long does the whole process take...

Yeah there is a guy in it from my home town - he is the guy who is due in court or something.

Does that £80 include the arch or not? - I'm guessing not?

How much-ish would it cost to have a new rear arch welded on an astra mk3 1.4 and sprayed the same colour as the car (white)? Cheers, Ross.

Does anyone know how I can change a control to be visible when a certain key is pressed? The key I wanted to use was Insert but if that isn't possible no worries. Thanks in advance.