Search results

  1. V

    how to get multivalue field in rows in query

    Hi, I have one multivalued column(Short text), I want to add criteria in query to get selected multivalued field in rows. example : multivalued field ( 1101, 1901, 4909, 4919) I want to add criteria in query to get value after comma. 1901 4909...
  2. V

    How to select all check box in Form by click button

    Hi, I have multiple checkbox on each row in form. I want to select all check box on single click and click "OK" on combobox and save. can you advice how I can do that on Form?
  3. V

    How to import column in Combo Box field

    Hi, I have one combo Box field in table with multiple selection option for plants. I want to Import excel file "Plant" column to ComboBox field in table. In excel file I have create column with data validation list and used VBA codes to multiple selection. When I try to import excel file to...
  4. V

    how to validate table field with another table field

    Hi, I have two tables and I want to validate the material column in two tables. Material field type is "Short text" table1 [ACT_Import_Table]![Material] table2 [ACT_Ext_Table]![Material]. I want to compare above two tables, I will enter materials in "ACT_Ext_Table" If that Material exist in...
  5. V

    How to create sequential numbers in table.

    Hi, I have created table with column "ID" as auto number. In Auto number I have seen some row numbers are missing. I want to create one column to get correct sequence of row. Example: I have created table and Form for employee details. If I enter Employee number in Form, sequence number must...
  6. V

    How to set limit of rows in Table

    Hi, Can you please guide me how to set limit of rows in table. example: I want to add only 130 rows in table. when user try to add new row 131 access should not allow him and give message "Exceeded Rows limit". Thanks,
  7. V

    How To Validate Textbox Data With Another Table Field

    Hi, I have created form and added text box and command buttons. I want to cross check the data entered in textbox is valid or not from another table. If entered data (request number) is there in table then command button is enabled otherwise it should give message "Request number is...
  8. V

    how to use check box to select items from combobox

    Hi, I have created form and I have two combo box in that form . I want to select all option from two combobox when I select check box. I create below vba codes but , when I just add one combo box in fields its work but when I add fields from both combo box its not working. please advice how i...
  9. V

    how to add select all option in combo box

    Hi, I have created Form with 2 combo box. I want to add "select all" option in combo box. Please advice how I can add the option.
  10. V

    how to disable certain fields in Form?

    Hi, can you please advice how I can disable fields in access. I want to disable fields as per combo box selection. (option-"vc";"non-vc") I tried below codes but other fields are still enabled. I want to disable that tields based on combo box option. Private Sub Mat_type_AfterUpdate() If...
  11. V

    how to add list box with multivalue selection in Form and link query or form output

    Hi, I am not expert in VBA codes. I have used below VBA codes as per my query. I have one query named "Material_List" where I have list of material(text field) and that I want to add in Form in text box with multiselect (simple) option. I have another query named "Plant_ACT" where I have all...
Back
Top Bottom