Search results

:D Don't be so tough with yourself Ok thanks everyone it has been very helpfull, keep going!

I was cleaning my code : removing dead code and inserting On Err and it suddenly got to work? How is that? Maybe someone has a good explanation to that kind of magic in order to conclude that thread!

I'm sorry I thought that a procedure and an event were the same !

Anyone has any idea?

Thank you all, What could possibly happen if I name two identical procedures the same way in two seperate forms? (tell me there is only one in a billion chance for an error to happen I don't want to go all over my code again for this) And How could I name differently two procedures called...

Hi, I would like to know if there could be a problem if two subs in two different forms have the same name (in a simultaneous multiple users access database interface). And also if I can name two GoTo Err identicaly in the same form and in different forms? Thanks in advance,

it's the form : frmModifActionsCréateur I know that my code has to be improve (do all the Onerror goto) but there is work in progress.. It works when a single Dlookup (that brings back a long) is needed in the ApplyFilter: frmModifActionsResponsable.

No matter where I put the break point the vb window doesn't show up. It still doesn't do anything when I double click on the form..

No, I typed this : Private Sub Form_Open(Cancel As Integer) Dim Nom As String Dim Prénom As String Nom = DLookup("[strNom]", "tblUsers", "[strIGGID]= " & Environ("username") & "'") Prénom = DLookup("[strPrénom]", "tblUsers", "[strIGGID]= " & Environ("username") & "'") DoCmd.ApplyFilter ...

Hi, I have a form bound to a table and I try to filter the reccords in the open form event. My problem is that the field that supports the filter : "strCréateur" (creator in french) is a combination of to fields in an other table "strNom" (LastName) and "strPrénom" (LastName) In addition...