Search results

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

Hi guys, I have login form and table "tblUsers" with four field such as ID(Autonumber),Username (text),Password(text),AdminGroup(yes/no). I want that if username is suppose guest and AdminGroup is "yes" then my tab in ribbon should display if "no" then it should not display. I used this...

i have column and row i want to change view from horizontal to vertical and vice versa

hi guys, I have problem with locked propery of combobox if i set to yes then i can not choose value from drop down box I just want that user can choose value from dropdown box but it cannot write in combobox. Thanks

Hi Experts, I have table Laptops and i have description ,location,quantity ordered textbox in "Insert_Data " form. so i wan to check that if description and location textbox values are same as table value then it should update data otherwise insert new records in table and i have written...

hi friends, I have button and i want that if i clicked on button value should change for example i have label and caption is "Mother" i want if i click on button then label caption should change from Mother to Father and if i click again it should change from father to Grandfather so what can...

hi guys, i have laptops form and that has description,[quantity ordered],location,[suggested supplier] ,[part number] fields and i have form "Insert_data" that have textbox and i want to insert data and also want to check this fields descritption,[suggested supplier],[quantity ordered],[part...

hi guys, I am new here and iam getting error like syntax error (missing operator )query expression in '[suggested supplier]=' Private Sub Combo31_AfterUpdate() If (Me.Combo31.Value = "Laptops") Then Me.Combo33.Value = Null Me.Combo33.RowSource = "SELECT DISTINCT [suggested supplier]...

hi guys, i have form it contains three combobox 1 is type and it contains three option Laptop,Printer,Software 2 is description and it contains options are dell,hp,acer,intel,mac etc... 3 is part number and it ontains option are h001,d001,p005,nh902 etc... now if i select Laptops from type...

hi guys, I have SearchLaptops form that contain sub form "SubLaptops" and i have button in SerachLaptops form. when I click it it will find data and show me in SubLaptops form and when i click on record selector of SubLaptops I want to open Laptops form that is bound with Laptops table.And I...

Hi guys, I have created automatic email like when quantity is less than three in my database for some items then it will send automatic email. and there is a fixed email address it will send there only. but i am thinking that suppose administator have change his/her email address and now he/she...

hello dear, I have log out button and when i clicked on that then login form will open and another all items will close like table,forms etc... and I have close all forms and table manually in macro. but is there a any ways that i can close all itmes ? Thanks

hi guys, I have form that contain three textbox,combobox and button. I want that user must have to choose value from combobox or if combobox is empty and you clicked on button you should get message that you must have to choose value from combo box. so whata i have to do. i tried this on...

Hi , I have Form OrderLaptops and table laptops. I have fields in Laptops table like Description,[quantity ordered],Location,Department,Part number etc.... and Description is a Primary Key so you cann't enter same data. i made button in the OrderLaptops form and in click event i write...

Hi guys, I have Form OrderLaptops and table laptops. I have fields in Laptops table like Description,Quantity,Location,Department,Part number etc.... and Description is a Primary Key so you cann't enter same data. If I have Quantity(3) for Description(Dell),Location(Canada),Department(HR) and...