Converting Access 2003 to 2007

[AlanW]

I am trying to convert my database (which has been running for years without a problem) from Access 2003 to Access 2007 but have hit a problem.

I have a form with a text box with the following expression which works fine in Access 2003 but throws up ‘Error’ in 2007.

=DSum("(0+[Deposit Amount]-[Payment Amount])","Query3","[Date1]<=[CBform]![Date1] and [Bank Account Number]=[CBform]![Bank Account Number]")

Can anyone tell me why?

 

[Trevor G]

Can you upload a sample of the 2003 database, make a copy and take out any sensitive data, I can then take a look at converting and the error you are receiving.

 

[missinglinq]

When apps run fine on one machine and not on another or run fine in one version and not when run under a newer version, the first thing you have to think about are missing references.

If you haven't done this before, here are Doug Steele's detailed instructions on how to troubleshoot the problem:

http://www.accessmvp.com/DJSteele/AccessReferenceErrors.html

Also, what error message are you getting?

Linq ;0)>