Recent content by aexley

Thanks Zathras I'll give it a shot. I don't think it will help but it's a personal project to see if I can create a simple routine that simulates water evaporating from a raincloud. The idea is that the cloud begins with each droplet (cell) at a random energy value and then changes as energy...

Good afternoon, I have a simple formula to run on a number of cells. The formula references the cells next to it and, according to their values, adjusts the value of each cell in turn. What I'm having trouble with is working out a For Next loop that identifies each cell in turn in order for the...

Using Access 2000. Will look at conditional formatting, Thanks aexley P.S. Is anybody else having problems with pages not loading on this site or is it just me?

Good Morning. I need to set the backcolour of a control on a subform in 'Continuous Forms' depending on whether the value of the subform control matches the value of a control in its master form. E.g. Main Form Control Value = 226 Subform control values = 0 23 327 0 226 <---- I need the...

Alternatively, how could the formula be altered to round to the nearest 20? This would be REALLY useful. Thanks aexley

Yes would be the answer to that then. aexley

Hi cwbviper, check out this Knowledge Base Thread Article Q210271 'Sending the Current Record to Word 2000 with Automation' I'm sorry I don't know how to do a link so you'll have to go to the Microsoft site and find it. Hope it helps aexley

Hi all, Could I replace the 50 with a 20 and 49.99 with 19.99 to roundup to the nearest value divisible by 20? Thanks in advance Aexley

Wasn't using section breaks but am going to give it a go. Thanks for your help. Aexley

Morning all, I have a Word document that requires different headers at various points throughout. My problem is I can set the second header (using the 'this point forward' option) fine but when I repeat the process for the third header it changes all the previous headers back to the page where...

Ok. Update on current problem: On my main form one of my controls is a text box whose source is the Autonumber ID for the current record. If I click in this box before I change anything nothing happens, however if I change something, anything, on the current record and then click in the text...

Thanks KenReay. I'm using Access 2000 and although I do use 'bookmark' it's on a completely different control. Also I removed the Event Procedure from the 'NextCallDate' control and the error still occurs. aexley

Note: Just imported all DB objects into a new, clean DB. Problem still there. Am at wits end. aexley :-(

*!!!* !*!*!!** Blinkin' flippin' 'eck! Ok, (deep breaths) I followed Garridons suggestions and everything was working fine. Until today. Annoying as this problem is I have been able to narrow the problem down to just one control or field. My NextCallDate field. I don't think it's the code...

Interesting point. I've just checked my Primary key fields on my B-E tables and the ones that don't (for my sins) use Autonumber are set to 'Indexed (No Duplicates)'. However the queries that access these tables (and on which my forms are based on)don't have their unique properties set. I...