Search results

Looking at how the code works is interesting, I don’t think I would have ever have worked it out at the level I am at. Thank you very much guys, both examples work well. :)

Thanks for looking at this. What I am after is for the user to search on any of the fields and any combination of the fields. When I use any of the fields to search on, I get a ‘Compile Error / syntax Error’ and then the code comes up highlighting: StrFilter = ' ' I have uploaded a copy of...

Thanks for the detailed reply, its much appreciated. As well as filtering the report (rptTimmsImpact) on the combo box (cboProject), I am looking at filtering using a Start and End date, and 7 checkboxes. txtStartDate txtEndDate chkCharity.Value chkEducation.Value chkMagazine.Value...

I am after some help creating a Form filter for a Report, I have Form frmReportFilter that opens rptTimmsReport in the background. On frmReportFilter is a Combo Box (cboProject) that filters the records on rptTimmsReport once a project has been selected and a Button (cmdApplyFilter) has been...

Thanks Paul, this has worked great. :)

Hi Paul, Where would I put the code and what do I do with the select and from commands? Could you please provide an example bit of code that I would be able to modify.

I have created a report with a query attached that basicaly shows every record in Surname order. What I would like to be able to do is only show the records where there is a blank field/fields. * Date 1, Date 2, Date 5 could be filled out while Date 3 and Date 4 blank * Date 2, Date 5 could be...

Who thinks Schumacher will be champion again before he hangs his helmet up for good?

Keep at it Ray, you will get over the hungry stage and used to the smaller meals, it just takes a little time and motivation. :)

I have found that 'weight watchers' has been very good in loosing weight and maintaining. You are given a number of points each day, such as 28 for me, then each bit of food, drink, etc also is worth points that you take away from your daily allowance. If you do exercise then this will give...

I have managed to find the answer to the last question. I have used the code below which seems to work: If IsNull(Me.DateValidUntil) Then Me.boxDisclosure.Visible = False Else Me.boxDisclosure.Visible = (Me.DateValidUntil < Date) End If Thanks guys for your help with...

Many thanks for your help, it is nearly there. This works only if there is a date in the date field. What will I need to add if there is no date to make a warning in red? 'Out of date warning Me.boxDisclosure.Visible = (Me.DateValidUntil < Date) 'Out of date warning If...

Thanks for you help guys, its getting there but I have another error now: Microsoft Visual Basic Compile Error: Block If without End If Any ideas?

Microsoft Visual Basic Compile error: Syntax error Then the following is highlighted in blue: If Me.DateValidUntil < Date()

It fails on this line: If Me.DateValidUntil < Date() Any other ideas?

Im trying to change the fore colour (to red) of another lable based on the date as well. Would it be something like: Me.lblDateValidUntil.ForeColor=255 = (Me.DateValidUntil < Date()) Would I also need to place the code in the same location as in your last reply?

Many thanks Bob, that has worked. :)

MS Access 2002 (MS Office XP) I would like to make a label only visible (containing a warning) if a date (in a text box) is shown to be less than today’s date. Any ideas as to what code I will need and what event to put it on?