MS Access problem

Discussion in 'Other Software' started by HeidiLiz, Aug 11, 2018 at 8:08 PM.

  1. HeidiLiz

    HeidiLiz

    Joined:
    Saturday
    Likes Received:
    1
    I hope somebody can help with some of my Access problems.

    1.
    I have a field “OfferNo” which is primary key, auto number (format start at 300). When I create search combo box in form, it does not retrieve the result of “OfferNo”, I suspect that it is due to format 300 because if auto number starts at 1 it works fine or search on another field.
    Any tips?


    2.
    I have field’s:
    • “OfferNo” (auto number)
    • “OrderNo” (number)
    • “ActivateOrder” Yes/No Check box

    If “ActivateOrder” is Yes - “OrderNo” = “OfferNo” (automatic)
    How to do?
     
    HeidiLiz, Aug 11, 2018 at 8:08 PM
    #1
    Abraham Andres Luna likes this.
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.