Search results

Last Saturday evening, I had a visit from the local police who were calling door-to-door down our street to try and gather any information they could about an incident that had occurred earlier in the week. The officer explained that elderly neighbours (in their 80's) had been victims of a...

If it helps, I have a Logitech K330 wireless keyboard and mouse package, and am very pleased with it. I bought it purely because I had the same package at work, and was very impressed with it. Battery life has been good, and it has stood up to the rigours of use much better than the Microsoft...

Deleted - was supposed to be sent by PM

Oddly, since I made some changes the other day, the problem has stopped.... I was going by the autonumber to see which records had been created/deleted, so yes it is possible that that it was an abandoned entry, however whilst this table supplies data that is in use constantly (and I do mean...

Thanks all :) I have been on site all weekend, and I am now moving toward the notion that someone, somewhere is mucking about in one of two ways - either they have found a way to edit/delete records without it showing on the audit table (goodness knows how they are doing that though!), OR they...

Thank you :) How much of a mission is it to migrate to an SQL back end?

I have an audit trail running on numerous forms throughout, which records all deletions and edits as it goes; I have had a good root through this, and cannot see any deletions on the table concerned. Our network has been so flaky that there have been instances where it has corrupted...

You sir are a genius! Works perfectly :) I really appreciate all your time, thank you :)

I've been having some problems with data going missing from one particular table, and I am firmly of the mind that the cause is a momentary drop in network connection/quality/speed that is the root cause. Our network has had significant problems over the past year to the point that often we...

Pretty much - I have changed a couple of the figures above, (thinking ahead, 0.2-20.5 for the lower range would prevent issues further along the line, and anything above 50 for the higher range. With the higher range, I think it is probably best to make it that the value is greater than or...

Some progress, but something still not playing nicely. Green only works if the value of L44 is greater than 60 (I have also tried the rules independently also), but the formatting does not change when it drops below 60. When L44 is the lower value, M44 is red regardless of the value that is...

Thank you :) I am at a different PC at the moment, but will give this a shot later on and let you know how it goes. I must admit that I haven't really used Excel for anything more than the very basic stuff, so apparently there is another thing I need to add to my learning path....

I am clearly getting something wrong here, sorry to be a pain. For red, I have: =AND(OR(AND($L$44>=1.2, $L$44<=1.5), $L$44<60),NOT(ISBLANK($L$44))) and for green, I have, =AND(OR($L$44<1.2, $L$44>=60),NOT(ISBLANK($L$44))) L44 is currently showing a value of 1.30, cell is formatted as a...

I have tried those on once cell, but it does not appear to work - I have changed A1 for the relevant cell that it should be comparing to (L44 in this case), and currently L44 has a value of 1.30. No matter what I enter in cell M44 (the cell that I have applied the rules to). the text remains...

I am trying to conditionally format a cell based on the value in another cell - however, there is a variable that will change the way I want the conditional formatting to work. The cell that the formatting is set to react to contains a number to two decimal places. If that number is a low...

I think I have worked it out to a point - it appears that the Concatrelated function doesn't want to work when referred to a query? I have a potential workaround, which is to refer it to the table instead, and filter on a Where condition - however, I would need three parameters - - is this...

I am struggling this. I already have a variable declared (Today) which returns today's date, so have set the line to look up the values as: References = ConcatRelated("ID", "EndTimeCheck", "Date=#" & Today & "#") The error I am getting is 3061 'Too Few Parameters, Expected 1' All three of...

Blimey, how embarrassing - - I actually use that elsewhere in the database and completely forgot :o

I have a query that will return a small amount of records (maybe five or six each time it is used), which is essentially to check on the contents of one particular field before a report is produced. This report is sent by email to an external body. So, I was thinking of having a sub that will...

This spreadsheet is a bit of a mess truth be told - 5mb file size was a dead giveaway for a starter. The more I am plodding through it, the more I am stripping out whilst keeping the costmetics of it the same -- as long as it looks the same to the directors, they won't have a clue what has...