Recent content by DemonHub

Ok thnx it's work now

Hi, I have a combobox with only 1 value and this value can be change anytime and that value come from a table. When I open the form the default value for the combobox must be the only choice in the list. I've try in the DefaultValue propertie ... =[comboboxname].[ItemData](0) ... but it's...

I need to stock the # of day waiting because I'am doing report with it and It's not the Date of Today - the first date . It's not a calculated fields. The + 1 is only added when the status is "Waiting

I made a button with a click event and in this event I want to add 1 to "Days of waiting" for each rows in a table with waiting in the field "Status" , each time I click on the button. I don't know how to go in the table with VBA code and add 1 to the rows with the criteria. The button is not...

Thx lupins46 , it's work great now :)

Nop sorry that doesn't work " AND DateRecu= date'" & Me!DateRecu & "'" <- Dont work " AND DateRecu= date(" & Me!DateRecu & ")" <- Dont work

I need help with this code DoCmd.RunSQL "UPDATE CocheDivers SET Diver1 =" & div1 & ", Diver2=" & div2 & _ ", Diver3=" & div3 & ", Diver4=" & div4 & _ " WHERE NumDossier=" & "'" & Me!NumDossier & "'" & _ " AND Critere=" & "'" & Me!Criteres1 & "'" & _ " AND DateRecu=" & Me!DateRecu The...