Search results

Not sure if what I'm trying to do is possible, but it's worth a try. I currently have the following code, which works fine: Private Sub Closed_AfterUpdate() Me.Status = "Closed" If Me.[Closed] <= (Me.[Received] + 1) Then Me.[24Hour] = "Yes" Else If Me.[Closed] > (Me.[Received] + 1) Then...

OK, Very quick one. I have a report that lists the expiry dates of certain items. Control name = [ExpiryDate]. At present, my report works fine but lists the expiry date of every item in the database. What I want it to do is only return entries where the expiry date is 12 weeks or less from...

I have three linked tables [Regulator], [RuleBook] and [Rules] (each has a corresponding form for data entry). In the "Rules" form, when you select name of the regulator, the rule books dropdown down is filtered to show only the rulebooks for that regulator. the code I use is: Private Sub...

This should be (and probably is) fairly simple, but for some reason my brain has gone into meltdown and I can't figure it out. I have a fairly simple database (A2007) for recording accidents. I have built a report that, for a given date range, lists all the incidents within that time span. In...

By virtue of my work PC being required to talk "American" despite me being in the UK, my regional settings have to be set to English - United States. It's a pain in the you-know-where, but it can't be avoided as I work for a US company and I have to access their databases and applications. I...

I have an A2007 database with a table called ComplaintsData which contains two date fields [Complaint Received] and [Complaint Closed] I have a little search form called "ParamForm" which has two unbound text boxes "StartDate" and "EndDate" which, when used in conjunction with queries allows...

I have a fairly simple Access 2007 database. It consists of a form, called "Complaints" which, as the name suggests, is used to record customer complaints. These are saved into a table called "ComplaintData". I have another form called "Search" which has a subform called "SearchComplaintData"...