Search results

Um ... like ...? (I mean just roughly, if you prefer)

This little wonder in the query does the job well. OOW: IIf(IsNull([LastJobEndDate]), DateDiff("d",[DoA],Date()), DateDiff("d",[LastJobEndDate],Date())) But if the field "RefusedWork" is marked “Yes", then the date to make the calculation is from the field, "FirstRefusalDate". Woe is me...

Happy birthday, ReAn.

Hi ReAn - That's perfect, and my first taste of an Abs Function. Thank you. It not only changes the text on the form, it's a permanent change too. I can see me using it quite a lot. Most grateful. Cheers

Thanks, Wayne, and ReAn, much appreciated. I'll take note of the advice, Wayne, and follow it. (I overlooked taking the opposite tack this time, but I can see this is perfect for it.) Cheers

I'd like to have something like this in the VBA code, but I cannot think how an Immediate If like this should appear. What it needs to do is to change a string after 14 days. Help/advice would be appreciated. Me!cboWork = IIf(Me!cboWork = “New” And (Date() – Me!txtDoA) >= 14, “Tainted”...

I was thinking of returning to 'normal' with Lost Focus, but yours has to be the way. Many thanks, MoP. Cheers

In If...Then...Else on a textbox, can I state something like "if anything at all is entered here", please? Or can I say apply this ForeColor upon enter with IF...Then...Else? I thought an If Then Else because I want the normal controls to apply for the following record(s).

Thanks, sparhawk83, I'll remember that one. I think I was using IsNull without a space between. Well, I'm not sure what it was (because I can't think why I wouldn't have used two words) - except that nothing would work at the moment it was needed. Now with Is Null as two words, all works very...

That's it, that's got it. Sorry, craftsmen, must be August or something in the air. Thanks very much for guidance.

It's the simplest query, but access won't oblige. One field has either no entry for records, IsNull - it remains blank, in other words - or it contains the word "yes". I want the query to produce everything except "yes". But access won't oblige with Not "yes", Not Like "yes", nor <>"yes"...

Well done, Ken. Thicker lines make it work right. I don't want thick lines, of course. But at least I have the choice now - thick lines and each line where it should be. Or hairline, and some here and some there. I suppose I will learn to love the thicker lines. Sorry to doubt you, craftsman...

Maxmangion Many thanks. Appreciated very much. Thanks too to Rich. Cheers, gentlemen

The main form, frmA, has general things of each record. For various specialities, there's frmB and frmC etc. The current record on the main form is Joe Bloggs. How can I have Bloggs appear when I click frmB or frmC to find specialised details about him please?

If only, UncleG. No, I know what you refer to, but not that. Lots of crashes - where would we be with Windows without them - but no homeless ldb. I was able to copy the whole db and so I do have a safety net. But I would like to know what is keeping the main table so secure.

I want to copy the main table to make changes to the fields (being safety conscious). I get this strange error message, "The Microsoft Jet Engine stopped the process because you and another user are attempting to change data at the same time." But no-one else is using the database. No matter...

That was really very generous of you, WayneRyan. We should have a star service for outstanding performers. Thanks on behalf of bissonette.

Thanks, Uncle Gizmo and Rich. I got these from another place http://www.mvps.org/access/reports/index.html http://www.microsoft-accesssolutions.co.uk/reports.htm http://www.invisibleinc.com/divFiles.cfm?divDivID=4 and they might help others. I'd forgotten about Northwind. Thanks for that...

As Google can't find any either, I guess you can be forgiven. Have a good weekend.

I'm looking for a site that gives examples of ace Access reports. Does anyone have a site to recommend please?