Recent content by hammerite

A little johnny joke In a School science class four worms were placed into four separate jars. The first worm was put into a jar of alcohol. The second worm was put into a jar of cigarette smoke. The third worm was put into a jar of sperm. The fourth worm was put into a jar of soil. After one...

Physicians were unable to reach a consensus: Should Brexit take place? The Allergists were in favour of scratching it, but the Dermatologists advised not to make any rash moves. The Gastroenterologists had sort of a gut feeling about it, but the Neurologists thought the Brexiters had a lot of...

Thanks guys for the welcome! @isladogs, yes for all my sins I'm a West Ham fan.

BOB AND THE BLONDE He sat down next to a blonde at the bar and stared up at the TV. The 10pm News was coming on. The news-crew was covering the story of a man on the ledge of a large building preparing to jump. The blonde looked at Bob and said, "Do you think he'll jump?" Bob said, "You...

I was never going to get top poster award, looks like I’ll never get this award either. @isladogs, as you replied to my initial post; I just wanted to say a personal thank you for the sample databases that you have produced over the past few years. They have given me the opportunity to see...

Thanks......Sometimes that's the best way to learn (from a database point of view). :-) ps the handle is based on a local football team i support.

Hi everyone! I have had a AWF account since 2008 so I am not really new to the forum; but I haven't really posted. Over the 10 odd years that I have had an account I was able to find all the help and support that has been offered out through the search options. I am UK based and have been...

Hi guys, I managed to get a work around for this where rather than setting a global constant for RETURN_TYPE_ESF I set it to lookup a field from the export form, which is a drop list. Regards, Steve

Hi Bob, Thanks for your suggestion, excuse my ignorance but my vba coding isn't the best. How do I go about linking the variable field to the module? Thanks, Steve

Hi David, Thanks for your speedy reply. I tried your suggestion and cannot seem to get it to work. I am not sure I did was correct so I list below: 1. Created text file called Global_Const.txt and saved text of variable as: Global Const RETURN_TYPE_ESF = "ER04" 2. Saved your public function...

Hi, I have created a partner database for project claims use, and I am having a little difficulty with one element of it. Basically, I have a module which has a global constant value which needs to change on a monthly basis. My question is "Is there any way I can design a form where a drop...