Search results

  1. A

    Option Group

    Thx for your reply, Uncle Gizmo! Your assumptions are mostly correct. The option group is linked to the field called Validity. The validity field is one of the fields of the Quotation table. And please forgive my English and see if I understand correctly. Do you mean that I need to discard the...
  2. A

    Option Group

    I have a form with a field called "Validity". And there I have created an option group: 30, 60 and 90. But now I would like to add another option , which is blank for users to fill in their own custom value whenever needed (see the attached jpeg). How can I get that achieved?
  3. A

    To open a form of a specific record

    Currently, 1. I have created a button in a switchboard with embedded macro:- Close Window OpenForm (Form name: frmCustomerFind) 2. I have created a form "frmCustomerFind), in which I can select a customer name in a combo box named "CustomerName". a. The row source: SELECT...
  4. A

    Login page and Welcome note

    Thank you so much for your reply, sensetech! It does help me knowing that my Access has some problems. Regarding #1 Login page - I have done a login form which can pop up once the database is opened. After login, the form is closed and Welcome note is opened instead. That's done. But it is...
  5. A

    Login page and Welcome note

    Here're something I want to achieve in my database (Access 2010):- 1. To create a login page · The table “tblUsers” has been created. · The login page will be popped up once the database is opened. · The user1 will be set to be an administrator who has the right to edit the info and the...
  6. A

    Create a Quotation Form

    For point 2, I can partly achieve. I have linked up the quotation details table with the salesman list table and customer list table. So, whenever I input the salesman info in the form, the list of customer no will show up according to the salesman selected. But my problem is, when I input...
  7. A

    Create a Quotation Form

    Thank you so much, spikepl! :) I have followed your table design. But how can that solve my questions? Would be much appreciated if you can furnish me with more details!
  8. A

    Create a Quotation Form

    The current database has the following tables (fields):- 1. Salesman List (Salesman, Supervisor) 2. Customer List (Customer No, Customer Name, Salesman) 3. Product List (Product Name, Product No, Price) 4. Quotation list (Quotation No, Salesman, Customer No, Customer Name, Product Name...
Back
Top Bottom