Recent content by DemonHub

It's not only on 1 table it's on all the tables and it's only happening on 1 user at a time. It's look like someone have deleted the tables and when the user restart the application all the tables are there again and working.

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

Can it be a problem with the .Net Framework?

The database is working great and it's shared on a local network , when I open it on my pc it's ok but on the other pc it can't compile the code. There missing a DLL or something like that. So there's no need to recreate the .mdb

Nope but it's not the Connection line the problem , It's the compilater who's not able to compile my code forms.

Yes and we have the same reference

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

Thx you gave me what I except , thanks alot :D

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

Yeah it's work , Thank a lot

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

Ok I've found the way " AND DateRecu=#" & Format(Me!DateRecu, "yyyy-mm-dd") & "#" Now It's working.

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