locked
ms access vba is not working properly RRS feed

  • Question

  • if i am trying to write a code then it not showing the full path of code,and also get red. i am unable to write codes in right manner i am using microsoft office 2013 and windows 8.1.
    Friday, February 5, 2016 6:47 AM

Answers

  • if i am trying to write a code then it not showing the full path of code,and also get red. i am unable to write codes in right manner i am using microsoft office 2013 and windows 8.1.

    I don't know what you mean by "not showing the full path of code".  If you mean that the line of code you're typing in the VB editor goes red (indicating a syntax error) before you even finish typing it, then it may be due to an open form that has a Timer event running.  This is a known problem; when the timer fires, the form temporarily steals the focus from the VB editor, and the editor then validates the code before you are ready.

    If this is the problem you're experiencing, then the solution is to close any form that has a Timer running, before you edit code.


    Dirk Goldgar, MS Access MVP
    Access tips: www.datagnostics.com/tips.html

    Friday, February 5, 2016 4:24 PM

All replies

  • if i am trying to write a code then it not showing the full path of code,and also get red. i am unable to write codes in right manner i am using microsoft office 2013 and windows 8.1.

    HI jai,

    With "red" code you have a syntax error. Can you show the exact code you have now?

    Imb.

    • Proposed as answer by André Santo Friday, February 5, 2016 12:50 PM
    Friday, February 5, 2016 6:55 AM
  • if i am trying to write a code then it not showing the full path of code,and also get red. i am unable to write codes in right manner i am using microsoft office 2013 and windows 8.1.

    I don't know what you mean by "not showing the full path of code".  If you mean that the line of code you're typing in the VB editor goes red (indicating a syntax error) before you even finish typing it, then it may be due to an open form that has a Timer event running.  This is a known problem; when the timer fires, the form temporarily steals the focus from the VB editor, and the editor then validates the code before you are ready.

    If this is the problem you're experiencing, then the solution is to close any form that has a Timer running, before you edit code.


    Dirk Goldgar, MS Access MVP
    Access tips: www.datagnostics.com/tips.html

    Friday, February 5, 2016 4:24 PM