Results 1 to 2 of 2
  1. 12-01-2010, 11:49 AM #1
    ppiper
    ppiper is offline Novice
    Windows XP Access 97
    Join Date
    Dec 2010
    Posts
    7

    New user Question

    Hi I guess this is the right place for this question.
    In my table I have a column named Local the entree can only be Yes or No, If Yes is chosen then Column named County can only Be Nul eg;



    if[Column local]="yes" then [Column County] ="Nul"

    Can I, and how do I code this.
    Any help welcome.
    Thanks
    Peter
    Reply With Quote Reply With Quote
  2. 12-01-2010, 11:53 AM #2
    RuralGuy's Avatar
    RuralGuy
    RuralGuy is offline Administrator
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Welcome to the Forum. There are no table level triggers in Access so you would need to enforce this requirement in the Form you develope to edit this table.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. New user with question
    By gabety in forum Access
    Replies: 9
    Last Post: 12-15-2010, 02:23 PM
  2. New User with DAP Question
    By Tdo79 in forum Access
    Replies: 0
    Last Post: 11-14-2010, 07:37 PM
  3. User-level security, split DB (FE on user comp's, BE on server)
    By evander in forum Access
    Replies: 8
    Last Post: 06-30-2010, 10:57 PM
  4. Newbie Question: User Entered Field as Query Parameter
    By AJ0424 in forum Forms
    Replies: 5
    Last Post: 08-05-2009, 12:13 PM
  5. User level security question
    By genesis in forum Security
    Replies: 1
    Last Post: 07-08-2009, 10:10 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums