Search results

I have merged a database and have produced a report based on a joint query. I need to be able to colour code the Incident numbers so that users can instantly know who to contact for a particular query. For example I have an incident number that begins with 0078 upwards and carries on for at...

Private Sub cmdrunQry_Click() Dim db As Database Dim QD As QueryDef Dim where As Variant Set db = CurrentDb On Error GoTo ErrHandler db.QueryDefs.Delete ("Dynamic_Query") 'On Error GoTo 0 where = Null where = where &...

I have created a search criteria, I want the user to get a message such as "there are no records for that particular search criteria". Would you know what code I need for this message to appear on the report. Many thanks.

I have a report that have blank pages. How do I get rid of blank pages in a report? Many thanks

If Not IsNull(Me![IncidentEndDate]) Then where = where & " AND [Incident Date] between #" + _ Me![IncidentStartDate] + "# AND #" & Me![IncidentEndDate] & "#" Else where = where & " AND [Incident Date] >= #" + Me![IncidentStartDate] _ + " #" I have typed...

where = where & " AND [Date Restriction Imposed]= #" + Me![DateRestrictionImposed] + " #" I have typed this code on my search query but cannot get it to display the information. It seems to be picking everything in the table. Is there something wrong with the syntax?

I am trying to create a report, I have a combo box with Voluntary Restriction Date, Restriction Imposed Date. The information required from this report is when the user choses a date from either of these boxes the information relevant to that date is displayed on the datasheet view. I also have...

I have a combo box as part of my search query. After a search I want to be able to clear and do a fresh search. I have called the combo box TYPE. Because of this when I set up a button and put TYPE = NULL, it won't work. Access will not accept this as it is a keyword. I do not wish to rename...