Search results

I have a shared database on a network and sometime the table and the query disapear and we have to close the application and restart it to solve the problem each time. It's only happening to 1 user each time it's happening , but not always to the same user. the tables and querys are still...

Hi, Hope someone can help with this problem. I open a database on my PC and it's opening perfectly but when I try to open the same database on an other PC I got a compile error. We have both Win98SE and MS Access 2002 and both the same VBA version. The file format is Access 2000. I've try...

I have this code when I open a form. stLinkCriteria = "[Date]=" & Format(Now(), "yy-mm-dd") stDocName = "FeuilleTemps" DoCmd.OpenForm stDocName, acFormDS, , stLinkCriteria When the form open a Filter is on and in the date criteria it's 5-9-20 And in my date field it's 05-09-20 , so the...

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

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 & "'" & _...