Search results

I don’t frequent the non-access forums anymore - I can’t be bothered responding to the activities of a certain troll with the brain of an underachieving ant who lurks here but I would like to send all my friends on the forum and the experts who have helped me so much my best wishes for the...

I got this from Crystal's forum and it works. Thanks for the suggestion though. Create a new derived field with this code if DateDiff ("d", {NVActns.StartDate}, {NVAPR.FirstRespTgt}) < 2 then "Fail" else "Pass"

Thanks I'll take a look tomorrow.

Is it possible to display a textbox if a condition is met. For example if a date diff is less than two days then display a text box in each record meeting this criterion with the text "Fail" and one showing "Pass" if greater than 2 days? Reportsmith allows this function using a macro suchas...

There is a lot of freely given help on this particular forum but I think the experts who kindly responded to you above would expect you to have actually constructed some queries so they could help you to correct any errors that you found. It is unlikely that they will write them for you from...

Sorted I found that I had to use a macro not vba to use the on enter function in the form field. PITA but there we are. Cheers

Hi Ron Thanks. Looking at it I'm not sure, it refers to Userforms which I'm not familiar with. Basically I've got a bunch of Word documents with form fields from the Forms toolbox and I need a message box when someone enters data in one of the form fields. The code below shows what I've got...

I'm reasonably competent (ahem) with Access vba but Word is giving me a headache. I know how to add a message box on opening a word doc. The doc has form fields. How do I code for a message box to pop up before or after a field is updated? Thanks

Belated Best Wishes Brian, I stay clear of the watercooler nowadays but I didn't want to miss your birthday. I'll have a glass with you tonight.

Hi Swopping from crummy Reportsmith to Crystal but can't find how to set the default save folder.

Just bear in mind that storing graphics in your database will bloat it significantly. Search here on images. OldSoftBoss has posted some great stuff on this.

Sadly Ron I've just run out of strats so it would have to be a Les. let me know if that will do. ;)

Sorry are you now saying that this is a report and not a form?

Because he doesn't want anyone else to indulge in what are his own favourite perverted practices........? Talk about a cesspit for a mind. Mind you it's very pleasant to be able to disable his contributions with the ignore list.

Let's ask Rich to post a new photo..........

It'll be good to have you around again, Vass.:)

Seconded. .

So! You worked out the devilish friend software!

Oh goody the source of all reasoned, temperate argument is back, you have been sorely missed. Unlike you with your head so far up your arse that you can probably see dinner coming, at least I can poke fun at myself and my "superstar" status. If that's pathetic what the F*** does that make you...

Hi Brian You're welcome anytime. We're just starting training for rest centre management ready for the next emergency although I'm excused as I live too far away from Pershore to be considered useful!