Search results

  1. H

    AutoNumber VBA Question~!

    Greeting all! I have written the below codes for creating auto-number (i.e. pre_number) for data entry of a form. It runs perfectly when I used it at 1st time. However, when I exit and re-open the form, the new record's pre_number field becomes 1!!! I spent much time to surf internet but...
  2. H

    Select Case Question & Combo Box Question

    Greeting All, Thank you to this forum and all the generous teachers here, I have learned much knowledge in Access and now become an Access VBA starter. Of course, a starter always encounter problems XD My 1st question is how I can use VBA to set a combo box's width auto-fit to the longest...
  3. H

    How to give command to multiple controls in a form

    Greeting all! I am making an a form for set meal ordering~ say set meal #1 provides a choice of 3 out of 10 starters. I created 10 input boxes for user to enter 1, 2, ~ but how can I disable any further input if 3 starters are chosen already??? Of course, the chosen items must be...
  4. H

    Form Validation Problem

    Greating all! I have been requested to create a form for entering 1) Sex 2) Number of Pregnancy 3) ... How can I prohabit the user to enter value into 2) Number of Pregnancy if answer of 1) is Male :banghead: I have tried hundred times and still no idea X( Anyone would like to help this...
Back
Top Bottom