Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2002
    Location
    Leicester - UK
    Posts
    820

    Unanswered: suspending data entry

    i was just wondering if anyone knew how to suspend data entry, ie i've got a invoce the invoice requires a customer, can you get half way through creatnig the invoice before to realise that the customer does yet excist so pause the form create the customer come back and finish the invoice, now when i tried this with a subform it wouldn't let me unless i hit esc to undo the record which is a total pain
    Definition of a Beginner, Someone who doesn't know the rules.

    Definition of an Expert, Someone who knows when to ignore the rules.

  2. #2
    Join Date
    Sep 2002
    Location
    South Wales
    Posts
    580

    Perhaps

    You could force the customer selection as the first field in the invoice - If the customer does not exist, have a pop-up to enable user to enter their details prior to returning to the invoice?

    At least they wont punch in loads of info until they find customer doesn't exist.

  3. #3
    Join Date
    Oct 2002
    Location
    Leicester - UK
    Posts
    820
    thats what i did, i just wanted to know if it was possible, and if so how
    Definition of a Beginner, Someone who doesn't know the rules.

    Definition of an Expert, Someone who knows when to ignore the rules.

  4. #4
    Join Date
    Sep 2002
    Location
    South Wales
    Posts
    580

    Hmm

    How is the customer entered?

    From a dropdown or text field?

    Perhaps code in the afterupdate of a textfield or notinlist event of dropdown could check the customer exists - if not it opens a modal popup dialog form to enter customer details before returning to the invoice?

    ...Just an idea
    Windows Server 2003-8 / Terminal Services / SQL 2000 / Access 2003 / Office 2003-7 / Exchange 2003-7 / Blackberry Enterprise Server / AutoCAD / Lambert And Butler / Red Bull

  5. #5
    Join Date
    Oct 2002
    Location
    Leicester - UK
    Posts
    820
    i just picked an example out of thin air, an actual example was a health and safty database with linked location, injury type and employee and grabbed via drop downs
    Definition of a Beginner, Someone who doesn't know the rules.

    Definition of an Expert, Someone who knows when to ignore the rules.

Posting Permissions

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