Recent content by Hedge01

It works on the second line I had a naming issue that I fixed thanks so much for you help!

Thanks for you input I really appreciate it. The first option returns a syntax error (missing operator) in query expression . Am i missing brackets somewhere? The second option filters "Adam," but does not return the null values.

Hi i have a subform that is a datasheet view and i want to filter the records that have "Adam" as the value plus the records that are blank in the same field. Private Sub Check45_Click() If Me.Check45.Value = True Then Me.NotEmptySubform.Form.Filter = "CTGOPP = 'Adam'" Or CTGOPP IsNull...

Thanks so much, really appreciate the help.

Hi hoping someone can help. I have a main form with a combo box on the main form with 3 options Shanghai, Ningbo, Qingdao A sub form with a combo box from an imbedded query with multiple columns Vessel, Voyage, ETA, ETDShanghai(Column3) , ETDNingbo(Column4), ETDQingdao(Column5). These date...

Guys you are the best I updated two of the Pc's and they are now linked. Can thank you enough. What a great forum.

Thank you I have spent hours on this. Only 3 computers out of 15 have this issue all the others connect ok.

I have a database that i split to be located on my work server it has worked for months now all of a sudden I am getting a message on some computes accessing the database saying could not use\......\jobflowaccdb;file already in use. I have noticed that on each desktop their is now a locked file...