Search results

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...

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?

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...

I try to use Dcount function but If condition always go to else option. I want to check material column in table "ACT_Sub_table". can you please advice what changes I have to correct in below code. If Nz(DCount("*", "ACT_Import_Ext_Table", "[Material] = '" & Me.Material & "'"), 0) > 0 Then...

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...

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...

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...

Thanks for your help, it work.

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,

Thank you so much, its working fine.

error message- Run time error 3464 - Data Type mismatch in criteria expression.

Hi, I have tried above code. I am getting error for line . If Nz(DCount("*", "[ACT_Main_Table]", "[MDM request no] = '" & Me.Text0 & "'"), 0) > 0 Then Please advice.

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...

can you please advie how to use True/false. I got error for that line.

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...

ok thanks , If have plant column in Number format, then how I can write union query. Please advice.

thanks I tried that but I got same error message again. Do I need to add "All" word in table ?

Hi, I have tried above union query but I got error message " The value you entered isn't valid for this field." Plant column is short text. Please advice.

Hi, I tried that and create below union query and I can see list of plants in combo box. but I am not able to get select all option . SELECT [plant2] & "All" FROM [ACT_Sub_table] UNION SELECT [Plant] FROM [Plant data ACT table];

sorry, deleted other question.