Search results

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.

I have a set of 5 or 6 queries which first purge a table of all data and then append new data from a selection of excel files which are set up as linked tables. The odd thing is that if I run them once it works fine. If I then run them again I get the error: you cannot record your changes...

I have a query which simply returns Company Name and Account Number. However, because the same company can have multiple Account Numbers I want to have one row for each Company with each account number separated by a comma So instead of Company A Account Number 1 Company A Account...

I am using this: : IIf([TableName]![FieldName] Like "Criteria1*" Or Like "Criteria2*" Or Like "Criteria3*" Or Like "Criteria4*","Answer If True","Answer If False") This is not returning the expected results so I must have the syntax wrong - can anyone help? Also how would I do...

I have an Sage ACT! database which I need to connect to Access 2003 so I can use previously written reports in Access. I cant seem to do this directly but I can create a Excel workbook which use an OLE link to get the data from ACT!, I can then link this to Access using a linked table. The...

I have a query which exports to a tab delimited text file. One of the fields is created on the fly and uses the code Date(). Whilst this shows as (for example): 27/10/2011 when I view the data, when I export it and open the text file is shows as 27/10/2011 00:00:00. I have tried formatting...