i have a combobox on the form and it has multiple values. But when i enter some text which is already in combo box, it does not fiter the result and display error instead.
The text you entered isn't an item in the list
how to fix?
auto expand is YES.
limit to list is YES
sub cboBox_Afterupdate()
txtBox = cboBox.column(1) 'actually col 2
end sub
Thanks for your answer. I dont want the textbox to be filled based on a combo. The student tables is linked with Class table and each class is linked to multiple students. like
Student1 = class a
student2 = class a...
I have a form that is based on a query which is taking data from three forms. I need a button on the form that that change the value of a field depending on the value of a dropdown box on the form. Its a student form and all the students are in a specific class. The thing i want to achieve is to...
I have a db in which i want to apply a fee module to specific class. The task i am trying to achieve is to add fee to a class and all the students in that class will have that fee in their account.
The fee type can be dynamic which means one class have one type of fee and other class can have...
I want to have a form in access which detects the GSM phone attached to the pc and send sps to selected entry in the databse. I dont want to use any sms sending website as the sms will be sent through mobile via access.
is it possible in any way?
yes batchid has number datatype. currently i am interested in saving the record in another form. kindly guide the process to save data from these fields to another form. thanks
yes the tables are linked and they are on a form. i want the save button to submit the data into table3 with the values present on the form (that is created by inserting values of table1 and table2)
I have two tables TABLE1 & TABLE2. Each have different elements. I have created a from with values from these two forms and want to store the data into another form. How to achieve it ?
Table1 = Name, division
Table2 = BookName, Author
Table3 is where i need to store the data from table1 and...
I want to achieve a task of multiplying a number to specific number of days based on criteria.
If the current date is more than required date. then multiply a specific value to those number of days and return a value.
due date = 22-Oct-2018
current date = 27-Oct-2018
late date charge = 5 * 150...
1: The Agent table store agent related data.
2: Passenger_Details table is storing passengers data that are related to specific agent
3: One agent can have many passengers but they need to be on same agent id (eg id 57 can have many passengers detail linked to it.)
that is the main scenario i...
i want to add record to a subform through another popup form but the id should remain same. I am attaching the db along with the post in which the agent and client tables are in relationship and i want to add client in the subform through a popup form. But when i fill the form and save it even...