Search results

I'm afraid so - not just new data but historic data changes. I know this is precisely the sort of problem you get with duplicated data, but I can't change the design. :mad:

Hi all I have a process in an inherited db that rebuilds a table of about 200,000 records every week. The build bit runs fairly quickly (considering), but clearing the table out first is taking 20+ minutes. It currently uses a deleted query ("DELETE * from tblTable") which I thought would have...

Do a search on the forum for "send email" or similar - there are hundreds of posts about it. Dave

Fair point. I hadn't really realised that was what the OP wanted... Dave

You can't. Add a new field called ID (or something) of type Autonumber and set it as the primary key. Dave

"Output" & Format(Date(),"yyyymmdd") & ".xls" Dave

I'd recommend you set up a multi-field index (with no duplicates) over the three fields you have, but don't make that your primary key. Dave

Have you tried decompiling? Dave

Fair enough! :) D

SJ, Why "Case Is = 1", rather than just "Case 1"? Is there a difference or is it just a style thing so it matches things like "Is > 1"? Dave

JOB:[Type_id] & format([Number_id],"0000") Dave

Don't get this - I've just tried it myself to make sure I haven't forgotten anything and it works fine. Let me check: You have a form with a text box, and in the Default Value field under properties you have =Nz(DMax("ID","Meeting"),0) and you're getting a syntax error? You do actually have...

You need quotes around the field and table name (see my original post!): Nz(DMax("ID","Meeting"),0) ID and Meeting are just strings, not variable names - VBA doesn't know what they are. Dave

Did you put "=" in front?

Try Nz(DMax("ID","tblTable2"),<value to use if no records found on table2>) Dave

What data type are you using? If you really want to include the "-" as part of the field, it will have to be text. Dave

Thanks very much. I've noticed something odd - "Echo false" suppresses the display of the report in design mode OK, except for the Field List which pops up and disappears again! Got round it by opening the report in design mode, closing the field list and saving again, but rather an odd...

I've had a search and can't find anything along these lines... I've got some code which plays about with reports and it looks awful when it's running - is there an equivalent of Excel's "Application.ScreenUpdating = False" functionality in Access (2000)? Dave

It sounds as though the report is based on a query which uses parameters: the query will automatically prompt for parameters when it is run. Have a look at the query design for things in []s in the criteria line(s) which are not fields from the underlying tables. Dave

... and if you're using .RecordCount, make sure you do a .MoveLast first to make sure all the records are loaded. Dave