Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Location
    Greenville, SC
    Posts
    271

    Unanswered: Different Print messages

    This may seem a little "Mickey Mouse like" but, we print request for jobs on green paper and FREE requests on purple paper.
    I have a message on a macro that comes up now and says "enter a green sheet and hit OK" Then it exicutes the print.

    How could i could implement a 2nd message box.
    I am not sure how to write the condition?
    We have a check box for the Salesman to check if the request is free.
    Could I put something like... if request free button is Null or false then execute green sheet macro. But if that condition is not met then it would use the second macro.

    I don't know, I am pretty new to this stuff.

    Any help is greatly appreciated,
    Michael
    Gotta to do some code

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    if request free button is Null or false then execute green sheet macro. But if that condition is not met then it would use the second macro.
    There you have it.

    vba if statements have the following syntax:
    Code:
    If [condition to check] Then
       'stuff to execute if true
    else
       'stuff to execute if false
    End If
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Mar 2004
    Location
    Greenville, SC
    Posts
    271
    Thank You very much

    Sometimes things are so simple
    Michael
    Gotta to do some code

Posting Permissions

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