Recent content by MrQ

Could you not change PatientDetailsGP in your query for the correct value? Hope this helps Q

Open the query in design view, right click on it and select parameters. You should be able to remove them here. Hope this helps Q

The nested suggestion above prompted me to write the following into a query field which worked perfectly so thought I'd post: Replace((Replace((Replace((Replace((Replace((Replace((Replace((Replace((Replace([Filter],"<>","Does Not Equal ")),"=","Equals ")),">","Greater Than ")),"<","Less Than...

Hi Jamos, Good for you my friend figuring it out. Well done. :) Glad I could be of help. Q :)

Hi Jamos, The only thing I can think is that you put the reports in a header of their own. Then, you would be able to set the visbility of the header itself which would solve the problem. If you're having any problems with this, if you could post a copy of your database (doesn't have to be a...

Hi Jamos, The syntax you're using for referring to your subreports is slightly incorrect. Try removing the square brackets from around your [Forms]. Also, replace [Reports]![YourSubreportName].Visible with Me.[YourSubReportName].Visible. Further to this, Google / search here for Refer to...

Totally agree with you Doc_Man. Found it hard to try and put my point across. Grateful for your input. Q :)

wjburke2, Maybe macro security? Q

Hi fibayne, Presumably, the main form is based on a table as well as your subform? Is it the case that updating cboFeeDue creates a new record? Q

Jamos, Don't fret my friend. We're all beginning at something. Open your report in design view. Right click on the Report header and select properties. Go to the third tab in, labelled Event. You will see three lines, the top one being On Format. Drop this down and select [Event Procedure]...

Hi Tibbs, How does your code currently identify new records? Q

Hi Jamos, You need to place a check in the report header... Something like.... Private Sub PageHeader_Format(Cancel As Integer, FormatCount As Integer) If Me.County = "All" Then Me.SubReport1.Visible = True Me.SubReport2.Visible = True Me.SubReport3.Visible = True Else...

Thanks Claris :) Glad I could help Q

Hi Guys, What about CStr? Q

You could try disabling your second monitor in your desktop properties. I know this works for me if, having undocked from work where I have apps on my secondary monitor, I then can't get to them at home. Q