Search results

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

that are a lot of changes :banghead::p

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

here you go

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

yes i did notice but can you explain why cliednt it is needed there instead of agent id ?:confused:

THANKS A LOT :) :) you are a life saver as always

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

the records only contain single non duplicate value. so it will work for me . thanks for suggestion.

thanks to all senior membes who also helped me. i have also learned about using the vb in code and found two vb codes to make app better.. Thanks you ALL

worked like a charm :) :) :) your comment is a life save .. had to ammed a bit but it worked. THanks a million <3 attaching the ammended macro pic

i have attached the db so you can have better idea. the form AGENT is where i have subform and search button.

MsgBox "Your Subformvalue is :" & Me.cntPassDetails.Form!sect SECT is on main form not on subform..