Results 1 to 3 of 3
  1. #1
    dcmphi is offline Novice
    Windows 8 Access 2013
    Join Date
    Jan 2013
    Posts
    2

    Input data validation of Form

    All Access Experts please help me. I attach a access db file. please help me how to develop a db with


    following requirments.
    In
    transaction form i needs following input validation


    (1) when ACNo text field is null or filled with any number it checks existing data (Name field) from a


    tbltransaction table. If match where ACNo is equal from Name field of tbltransaction then show the name
    in txtName textbox. Otherwise txtName fields show Invalid Customer or my message and focus set to ACNo


    textfield. Cursor not moved other text field without any valid data. Cursor moved when ACNo is not


    nulled and input value is found existing data from tbltransaction.
    (2) TransType, VoucherType text field is same as like as ACNo text field. TransType checks existing


    data of tblTransType and VoucherType chechs existing data of tbl VoucherType.
    (3) If VoucherType text fields is debit by cheque or debit by voucher then Debit text field is enable


    and credit text field is disable. And If VoucherType is credit text field is enable and debit text field


    is disable.


    (4) VoucherNo text field is only checks if it is null or not. If not null not set focus VoucherNtext


    field.


    (5) Description text field is only checks if it is null or not. If not null not set focus of the field.
    (6) IN txtbalance field i want to show balance of the acount number which is equal to ACNo text field.
    (7) If VoucherType is debit then check input Debit text field amount. if Debit text field amount is < or


    = Balance text field then transaction complete otherwise not.
    (8) If VoucherType is credit then check input credit text field amount. if Credit text field amount is >


    0 then transaction complete otherwise not.
    (9) txtLastTransDate text field show the last transaction date from tbltransaction where Form ACNo is equal to tbltransaction ACNo .


    Thats all. Thanks to all access talents.....


    Here is my attachfile link:
    http://rgho.st/7Rdd4XqcD

  2. #2
    jwhite is offline Competent Performer
    Windows 10 Access 2013 32bit
    Join Date
    Dec 2012
    Location
    North Carolina
    Posts
    349
    You cross-posted this question on UtterAccess website (http://www.utteraccess.com/forum/ind...ic=2039600&hl=) and have already received an answer. Please do not cross-post...

  3. #3
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,016
    And at

    http://www.access-programmers.co.uk/...d.php?t=289651

    as well! If you simply must post in multiple forums at least let the members on each forum know about the other forums you're querying!

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

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

Similar Threads

  1. Replies: 6
    Last Post: 04-04-2015, 08:10 AM
  2. Data validation: input Thursdays only
    By dgtampa in forum Forms
    Replies: 2
    Last Post: 06-22-2012, 04:42 PM
  3. input Validation
    By injanib in forum Forms
    Replies: 4
    Last Post: 06-16-2011, 10:01 AM
  4. Input Mask/Validation rule
    By SMAlvarez in forum Access
    Replies: 0
    Last Post: 04-11-2011, 07:27 PM
  5. Validation and Input masks
    By Santi in forum Access
    Replies: 3
    Last Post: 03-26-2009, 10:53 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