Re: Turn off Auto Calculation

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I am sorted now. Thx for your help

The reason that the code I had used in the form did not work when attached to the button was because the 'Is Null' in the IIF statement had to be moved to the begining instead on being,and changed to 'IsNull', at the end. Hope that makes sense.

Thanks again

Alan




"Allen Browne" <AllenBrowne@xxxxxxxxxxxxxx> wrote in message news:OrzIqx9pJHA.996@xxxxxxxxxxxxxxxxxxxxxxx
The posted suggestion was for VBA

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Alan" <Alan@xxxxxxxx> wrote in message news:uSzfBl9pJHA.4372@xxxxxxxxxxxxxxxxxxxxxxx
It has been sugested that I should attach all my formula's to their respective fields via VB with an onClick button. Which I think is similar to what you suggested.

I am working on that idea at the minute but I am still getting code errors. Does the doubling up of quotation makes apply in VB too or should I just be able to drop my ControlSource code strait into VB with a prefix of me.Field1 (after renaming my field to Field1).


.

Relevant Pages

  • Re: If Else Statement in VBA
    ... Perth, Western Australia ... Tips for Access users - http://allenbrowne.com/tips.html ... for some reason I can't get a simple statement to work! ...
    (microsoft.public.access.modulesdaovba)
  • Re: stored procedure takes too much time to execute
    ... Yes, I could try that, but I'm not sure that this is the reason. ... But thx anyway for your help. ... >> Dim prodid As SqlParameter ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Thursdays dates between 04/16/06 - 05/15/06
    ... Thank you Peo, I just knew that you had to have a good reason but I could ... In Perth, the ancient capital of Scotland ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Problem converting byte[] to string
    ... Thx for your help in this. ... None of the decoders worked in System.Text namespace. ... > If it doesn't work for the ASCII one, then the encoding isn't ASCII. ... I was just wondering if any one new a reason as to why this ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: unicycling girl friend
    ... the reason why we broke up b4 was that she lived in ... Western Australia and me in Sydney so she's now saving up to move to a ...
    (rec.sport.unicycling)