Recent content by hardik_088

hi guys, I have add button so when you press it will insert data. So i want that if you click on add button it insert data it and should give a message using message box any thing that "Your data is inserted" Can anyone help me how to do? Thanks

Hi , I am getting problem with record source property. suppose i have one form that contains 4 combo box and i am trying for cascading combos. first combobox is country_name from table1 second combobox is province_name from table1 third combobox is department_name from table2 forth combo...

hi Here i am sending my database so can you check that where i am wrong. Thanks a lot

hi guys, I have two combo box and i am working with cascading combos but my problem is that when i select value of first combo box then second combobox listing the value as per first combo box but when i try to choose value of second combobox then i cant choose from list and it always display...

Hi, ya i tried it many times but it did not work. if I change any field value like location or department then it is not working. suppose i enter record 20 from table so there is location value is "AHR" and also location is "PCH" or "NLH" is available in different records in table so if i enter...

Hi , Ya you are perfectly right. If any field does not match then it should insert new data and there should be quantity 100 otherwise 104. Thanks a lot

& chr(34) & [form.combobox_name].value & it takes the exact value from the form and chr(34) is used because there is Text datatype. there is [quantity ordered] field and i want to count the stock so if there is suppose same type of laptop available in table records then it add the value of...

Hi, you can try into database then please help me if you find any solution. Thanks a lot

Hi, actually I dont want to check just one combo box I want to check whole record if whole record is match to data in form that i enter means i can say if record exist then it should update otherwise insert. not to check just one com box Thanks a lot

how to use Not_In_List event of combo box and here in which combo box i should a apply so it is possible to update or insert data. thanks a lot

Hi , My code can be complicated beacuse i am new for MS Access. So whatever i know I tried to apply that. So what I should do can you tell me little in detail. Thanks a lot

Hi, I solved type mismatch error problem but i get new problem while doing that. Here I attach my database . In the "Insert_data" form you try record 20 from laptops table and enter data in this fields date,type,supplier , description,location,department,part number here if i enter...

hi , actually I dont know how can I check dates? and i have one more problem that i have one text box and it is taking the email address that i wrote . so make table and there is field "email" and i wrote my email addresses in table but it is sending email to just first record but i want to...

hi guys, I have created automatic email but when somebody is logout or close and open database again then it is sending email so receiver can be boared from one email so i am thinking email should go just one time in a day.It doesnot matter how much time it open or close or logout . so what...

hi guys, I know here is my little mistake that i cannot find. I want that if here description is same as table data then it should check part number if it is same then it should check location if it is same then it should check department,location and if same then i want to update query. From...