AJ,

I've just been using the wizard and getting this error.  The Date field from an accounting dataset has an incorrect date 31/12/2099.  Its been reversed but the transactions still exist...

Gery,

I was looking for same and came across an Indian crowd whose book Secrets of an Accounting package in .Net and SQL 2000 published by VK Publishers with Full Source...

Colin,

Thanks for the info - thats a great help to know when you're struggling to get to grips with the complexity of SQL. 

Is there somewhere out there where the simple...

Hi,

There are some very good examples of using Access emails in site http://www.helenfeddema.com .

Alternatively, why not use a macro "sendobject" which formulates your email and send your query as...

Hi,

I pretty new to SQL myself but I found a code snippet  (maybe on this site) that helped alot and will solve your problem.

Sub RemoveDBO()

    Dim tbl As TableDef

    For...

Hi,

I'm new to SQL myself and I was admiring the code snippet from Remi.

Should the conditions being checked be "OR" rather than "AND" as all the conditions need to agree...