Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2007
    Posts
    6

    Expression Builder

    Hello, (I am using Access 2000 - maybe Access 2002 too on another PC.)



    (What I can do with a 'Macro', I would like to do it directly with the 'Expression Builder').

    - I have a Button and a Textbox on a Form
    - I would like to Lock that Textbox when I click on that Button but directly with "Expression Builder".

    With Macro,

    - it uses the 'Set Value Action': (Then 2 things need to be input: Item & Expression)
    - In 'Item' : [Forms]![frmTransaction]![Normal_Client].[Locked]
    - In 'Expression': True

    With Expression Builder I tried:

    [Forms]![frmTransaction]![Normal_Client].[Locked] = True

    Unfornuately, its does not work, and it often places an '=' sign before the expression: =[Forms]![frmTransaction]![Normal_Client].[Locked] = True

    Please help me... Thanks...
    Last edited by mistaken_myst; 05-07-2008 at 08:03 AM. Reason: More accurate on my information:

  2. #2
    Join Date
    May 2008
    Posts
    8
    I would suggest using VB Code, not a macro. In the code for the button's Click Event, add: Normal_Client.Locked

  3. #3
    Join Date
    Oct 2007
    Posts
    6
    Yeah, I know how to use Vb Code, since I already hav the knowledge of Vb6 & Vb.Net 2003..

    The fact is that Microsoft Access gives '3 way' for writing events:

    Expression Builder, Macro, Vb Code.

    'Macro' and 'Vb Code' works well BUT I cannot seem to be using the Expression Builder at all.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 03-23-2010, 04:01 PM
  2. Replies: 0
    Last Post: 11-04-2006, 02:31 AM
  3. Query expression for form
    By pjacob in forum Forms
    Replies: 1
    Last Post: 10-10-2006, 09:12 PM
  4. Field gets data from Expression?
    By Willot in forum Access
    Replies: 3
    Last Post: 12-10-2005, 06:28 PM
  5. Replies: 0
    Last Post: 12-05-2005, 04:09 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums