Search results for query: *

I don't knowm if this is the same with you, but our default is automatically set by our IT department.

my first thought is that the printers are different. if the printer you are using has different base margins this can affect your reports. not sure if there is much you can do about that.

Otherwise you are going to have to do a select duplicates query on the 5 fields and sort and compare by time. You could, of course round the date time to the nearest minute (or 2) to catch the 30 seconds. (int([Date time]*24*60*2+1)/2) if my logic serves.

Alternatively you can use strsql="select * from tcontract" Set qdf = CurrentDb.CreateQueryDef("My_Query", strSQL) Set qdf = Nothing docmd.SendObject acSendQuery,"My_Query",acformatxls,"My Recipient" docmd.deleteobject acquery, "My_query"

Binnit, Your IT department should be able to kill off any connections to the file. you should then be able to delete it. Probably got a rogue reference from somewhere when it corrupted.

I have written code to create an excel pivot table, and am trying to set the page value to one of the values in the data, but it keeps telling me that it either can't change to _default or if I try another way, that it has no access to the PivotItems. I've tried various combinations of...

I think the easiest way is probably using the Dir command. Dir(filepath) it will return the same filename if it is there.

Have you tried using an iif as the control in the subform?