Recent content by houseofturner

I have a form with quite a lot of code connected to it which has become corrupt. If I open it in either normal view or design view it crashes. I have tried repairing the database. Any other ideas about how I can get at the code to create a new form.

Hi, that's great. Could I wildcard either side of the manufacturer field. Tried but maybe my syntax is wrong. Some of the drop downs of a similar nature may just say BMW as part of the string. Thanks!

I want to run a query that uses criteria specified in a series of fields on a form. However, not all the fields on the form will have data stored in each time the query is run. So for example, the query has the fields Manufacturer, Model, Variant. The form has has the same fields. If someone...

I have a macro which Applies a Filter to a form using the values in a combo box using the Apply Filter command. The form itself has multiple combo boxes and each has this option. It runs off the after update function on the combo box. When I select a new combo box it releases the old filter...

That's great thanks!

Hi Sorry for any confusion, no more changes - promise!

Hi That's close, but as you can see from the attached, where there are multiple records with the same year, the year is incorrectly appended. I only want to append the year if the two years are different. It's doing my head in :(

Hi, thanks for response. The attached XLS may explain it better. I simply want to update the model with the year only where there are different years for the same model. So for example: BMW 5 Series 2104 would stay as BMW 5 Series 2014 (there may be 5 rows like this for the different 5 Series...

Is there any way that I can perform a function based on a variable within a group. So for example, I have a table with Make: BMW model: 5 Series year: 2014 There might be 5 records like this (for different 5 series derivatives) and 5 where the year is 2015. I want to combine the model and...

I have a cross tab query which produces a set of results for me which analyses the status of sales opportunities. So for example it would show: Region , Manager, Sales Person as columns Open, Closed, Won, Lost etc as headings. I then have queries referencing the cross tab to produce a...

Sorry, you are right I was being dim and put the values the wrong way round - thanks for your help.

Hi thanks but I did try that and still got the same result. Any other thoughts?

I am having an issue with some code - an excerpt of which is shown below. Public Function FundedUnitsActualScore(intUnits As Single) As String Select Case intUnits Case Is < -50, Is < -59.9 FundedUnitsActualScore = 4 Case Is < -40, Is < -49.9 FundedUnitsActualScore = 5 Case 50 To 59.9...

I have created a pivot chart based on a cross tab query which gives me exactly what I want. However, the when I show the legend each entry says "sum of". The source field is for example "completed" but when this is shown in the legend it appears as "Sum of Completed". How do I get rid of the...

There is nothing like that. What I cant understand is why it always works the first time and not the second. The first part of the process deletes all the data so running it the second time is the same as running it the first. The data hasn't changed.