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.

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...

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...

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...

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...

If I put an Iff statement into a Query such as: IIf([Table A]![FieldName] Like "A" Or [Table A]![FieldName] Like "B","Answer A", "Answer B") It works ok but as the table name is the same why do I have to repeat it. If I try: IIf([Table A]![FieldName] Like "A" Or Like "B","Answer A", "Answer...

I have designed a report based on a cross tab query that counts the number of units sold by each dealer per month. So the left hand column lists the dealer and the rows along the top list the months. There is then a total at the bottom. This worked find when I was reporting on an entire year...

I have a simple function that says: DoCmd.TransferSpreadsheet acExport, 10, "QueryName", "C:\FileName.xls", True, "TabName" I want to export 5 or 6 very similar queries and I am concerned that my database is starting to just have way too many queries to be manageable. Can I replace the query...

I have a series of 14 reports which I need to preview and then print. Rather than do them one at a time I would like to open them all in preview mode at the click of the button. All the reports preview fine if run one at a time or in batches of 3 or 4. However if I run a batch of 14 it always...

I am using: RetVal = SysCmd(acSysCmdInitMeter, "Preparing Database...", 5) in order to display custom messages on the status bar. This works fine when I test being able to display this but when queries are running then the standard Status Bar saying Running Query etc over rides my custom...

As part of a long series of import routines I use the function: DoCmd.DeleteObject acTable, "CH32310N_ImportErrors" to clean up tables. However I have to have one of these statements for each table error table. Is it possible to use wildcards within this function to say for example...

I have created a pivot chart and changed the bar colours via the properties but when I add a legend the key uses the default colours not the updated ones???? Any ideas???

I am obviously being really stupid by the query below compiles ok but when I run it I get a syntax error. Its a long query so it is split up with " & _ Any help would be appreciated.... DoCmd.RunSQL ("SELECT [Bounce Backs To Process - Imported].ID, [Bounce Backs To Process - Imported].Contents...