Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

HELP - Function question for Table problem

Discussion in 'Information Technology' started by Sandi, Jul 28, 2006.

  1. Sandi

    Sandi
    Expand Collapse
    Guest

    I have a database that has two forms built off of the same tables. I have
    gone in and set up validation rules and text for certain fields in the Table
    not be left blank. The only problem with this is that it affects the other
    Forms that do not require some fields to be filled out. Because I have added
    these validation rules to the table, is there some way that I can distinguish
    between the forms. There is an Inbound and Outbound Form that contain the
    same fields from the Employee Table. Most fields are required for the
    Inbound Form and not for the Outbound form. Is there an IF function that
    state if they are using the Inbound form that this fields is required and an
    IF function for the Outbound form that it's not required???
    Sandi Gardner
     
  2. Loading...


  3. strive4peace

    strive4peace
    Expand Collapse
    Guest

    Hi Sandi,

    Instead of putting the validation at the table level where
    it will be different for different forms, remove it from the
    table and put it on the respective controls in each form --
    Data tab of Properties

    Warm Regards,
    Crystal
    Microsoft Access MVP 2006

    *
    Have an awesome day ;)

    remote programming and training
    strive4peace2006 at yahoo.com

    *

    Sandi wrote:
    > I have a database that has two forms built off of the same tables. I have
    > gone in and set up validation rules and text for certain fields in the Table
    > not be left blank. The only problem with this is that it affects the other
    > Forms that do not require some fields to be filled out. Because I have added
    > these validation rules to the table, is there some way that I can distinguish
    > between the forms. There is an Inbound and Outbound Form that contain the
    > same fields from the Employee Table. Most fields are required for the
    > Inbound Form and not for the Outbound form. Is there an IF function that
    > state if they are using the Inbound form that this fields is required and an
    > IF function for the Outbound form that it's not required???
    > Sandi Gardner
     
  4. KARL DEWEY

    KARL DEWEY
    Expand Collapse
    Guest

    For the fields not required for everything remove the validation from the
    table and set the validation rule in the form text box.

    "Sandi" wrote:

    > I have a database that has two forms built off of the same tables. I have
    > gone in and set up validation rules and text for certain fields in the Table
    > not be left blank. The only problem with this is that it affects the other
    > Forms that do not require some fields to be filled out. Because I have added
    > these validation rules to the table, is there some way that I can distinguish
    > between the forms. There is an Inbound and Outbound Form that contain the
    > same fields from the Employee Table. Most fields are required for the
    > Inbound Form and not for the Outbound form. Is there an IF function that
    > state if they are using the Inbound form that this fields is required and an
    > IF function for the Outbound form that it's not required???
    > Sandi Gardner
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page