Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2009

    Unanswered: Macro condition-compare w/field in table

    Hi. I am trying to use a condition in a macro to compare the value entered in a form's text box with the value in a table. I can't seem to get the correct syntax, but it can't be impossible. I really am not able to use VB and don't have time to learn it. ID10-T I guess. Any suggestions? Much appreciated.

  2. #2
    Join Date
    Mar 2009
    Provided Answers: 15
    Macros were not conceived for this kind of thing: they execute something and not a lot more. What you want to do (computing) is typically in the domain of VBA.

    If it would be possible to perform complex calculations with the macro language (I'm not sure it is possible) it would be far more complicated that to write a little piece of code in VBA. If you write a Function in VBA you can use it in a macro, though.

    Have a nice day!

  3. #3
    Join Date
    Nov 2007
    Adelaide, South Australia
    You're only hope is a DLookup function I would think. However, I really don't use macros at all, so I am not sure if it is possible or not.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!

    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts