Recent content by Iceolate

Thank you for taking the time to provide some follow up advice. This will improve the "structure" of my code I am sure and as you say, hopefully reduce problems when I run the code. Thanks again.

Thanks vbaInet. The End If's don't usually cause me any problems but now I know I can try your suggestions if I run into similar problems. Thanks again.

Thank you vbaInet and burrina. The End If after Me.Dirty = false indeed fixed my problem. I normally place my End Ifs at the end of my code but I get this feeling that as you suggested there are times when this is not correct. Unfortunately my VBA is not strong enough to make the distinction...

Hi All, I am trying to close a form with a subform. I enter data in the main form and then the subform. The main form has a save btn with an on click event which includes at the end of code If Me.Dirty then Me.Dirty = false DoCmd.Close DoCmd.OpenForm "FormName" however the Form will only...

Hi Paul, I remembered I was provided with a solution to a multiple combo box search form which achieved the results I was looking for. The query criteria below entered into the relevant field column is what I am using. The Is Null is used on the OR line of the query. Thank you. Like "*" &...

Hi Paul, I am still not getting the results I am looking for. Current query design has one field with a criteria of the first combo box selection, another field has a criteria of the second combo selection. The third combo box i need to filter on the results of the first two combo boxes if i...

Hi Paul, thanks for the reply. Setting the Or to Null returns all the records but it ignores the filters I have from the other two combo boxes.

Hi, Any advice on how to get a third combo box on a form to be optional. I have a form with two combo boxes which filter out the results on a query. However I want the third combo box to be optional i.e. if it is blank then just the results of the first two combo boxes are shown. If the user...

Hi Galaxiom, With the help of yourself and CJ, I have managed to get it working. Thanks for your patience, much appreciated.

Hi CJ I tried again and with your and Galaxiom's help managed to get it working. I have also copied in the solution for "this" months data which works too. Really appreciate your patience. closedlastmonth: DCount("*","obsvfilterqry","Date_Closed Between DateSerial(Year(Date())...

Hi Galaxiom, Thanks for posting. I am still getting the same error..missing bracket etc or item in query expression. I am entering in a new field in the obsvfilterqry closedlastmonth: DCount("*","obsvfilterqry","Date_Closed Between DateSerial(Year(Date()), Month(Date())-1,1) And...

Thanks CJ for taking another look. I will try tomorrow. As with many things in Access there are always different ways of achieving the same thing, so I may look at other ways of counting the records in a query within the last month.

Thanks CJ but I am still getting the same error of missing brackets etc

Thank you for your reply. I have entered closedlastmonth: DCount("*","obsvfilterqry","(Date_Closed) Between DateSerial(Year(Date()), Month(Date()-1),1) And DateSerial(Year(Date()), Month(Date()),0") as as new obsvfilterqry field but I am getting am error of missing brackets or item. Could...

Hi everyone. I have looked on similar posts here and the internet but could not find the answer. I am trying to count the amount of records that were created and closed for last month but I am having problems inserting the correct criteria along with the DCOUNT syntax. Closed...