Search results

hi bob, here is my database you just open "Insert_data" form and insert data if you add same data that already exist in database then it will update but if you insert different data then it is not inserting values in table. For example you can try this data Type :- Laptop Supplier:- PC Corp...

hi guys, I am puting code here but here my problem is that i have used Dcount function and description field is working good but when i use both [part number] and [department] fields then not working and if i use just one from [part number] and [department] field then its working what is the...

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

if there is value grandfather on label and if you cliked button nothing should happen. thanks

thanks for reply yes if i close form and open again mother should be there.

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

Thanks I know that i have used wrong name for fields and i will change that later on. and can you please tell me waht i have done wrong in query for now.

Thanks , I am trying to change table design but i want to solve that error (to check all the fields with DCount function or any other ways)

sorry friend but i have used many places so i cant change and i also thought about that after created tables but i have created many thing so i did noot change. and for desktop and other peripherals i have different table thanks

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 bob, now i got it but if i click on dropdown box of combo35 to select item and i want that whatever value is in combo33 it should be selected as a value of combo33 what i should do? i tried on click event of combo35 me.combo33.selected = true but is did not work Thanks

hi bob, Actually I am using following code as per you told me i changed bold text but i am not getting exacly what you want to tell me about rowsource of combo33 Private Sub Combo31_AfterUpdate() If (Me.Combo31.Value = "Laptops") Then Me.Combo33.RowSource = "SELECT DISTINCT [suggested...

hi, i have removed me. combo33.value = null and i tried to write [suggested supplier] = 'Dell' instead bols text then its working but if i write following code is is giving same error Private Sub Combo31_AfterUpdate() If (Me.Combo31.Value = "Laptops") Then Me.Combo33.RowSource = "SELECT...

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 , i have following tables and in my form i have type field is combobox and i want to see option there Laptops,Licences ,peripherals . so i have written in row source sql query like (select Laptops.type,Licences.type,peripherals.type from laptops,licences,peripherals) then it showing options...

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

Thanks dear I have just changed bold text and its work perfectly that i want Private Sub Form_DblClick(Cancel As Integer) On Error Resume Next 'Incase Laptops form is already open DoCmd.OpenForm "SubLaptops" With Forms!Laptops .Filter = Me.Filter .FilterOn = True...

Thank you very much dear its works nicely but here i can see that specific record and all other data in my laptops table but i exactly want that is only that data i want to see that i find in my sub form "SubLaptops" not whole table data. if you can then great otherwise its ok

Thanks dear, but i tried that code and i put selectme() function in my laptops form but it is giving error that method or data memeber not found in bold text Public Sub SelectMe(lngID As Long) Dim rsMe As Recordset Set rsMe = Me.Recordset rsMe.Find "[serial number] = " & lngID Set...

so i have tried this code and it open that specific record but not other record in sub form have. Private Sub Form_DblClick(Cancel As Integer) On Error GoTo Err_Form_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "Laptops" stLinkCriteria = "[serial...