Replies

Fixed – Did an XP re-install (normal start from XP CD , let it find exisiting installation and choose R for Repair – takes ages but much less time than a reinstall

Fixed – Did an XP re-install (normal start from XP CD , let it find exisiting installation and choose R for Repair – takes ages but much less time than a reinstall

Francois; Thank you for both the speed and detail of your response.
The Union query (very clever technique) is working well but I have obviously done something wrong with the PrevBalance technique as it is not working. My final version is shown below.

PrevBalance: nz(DSum(“Balance”,”Balance”,”[ItemNumber] = ‘” & [ItemNumber] & “‘ and [Date] < #" & Format([Date],"mmmm yyyy") & "#"),0)

Rightly or wrongly I changed the date format part as I thought maybe that was the problem and my queries have the date formatted as mmmm yyyy. However all date formats I tried (including the Australian one of dd/mm/yyyy gave me a zero prev balance. I dont actually understand what this formula is doing so makes it hard to fix. Any explanation would be much appreciated
Thanks again

Francois; Thank you for both the speed and detail of your response.
The Union query (very clever technique) is working well but I have obviously done something wrong with the PrevBalance technique as it is not working. My final version is shown below.

PrevBalance: nz(DSum(“Balance”,”Balance”,”[ItemNumber] = ‘” & [ItemNumber] & “‘ and [Date] < #" & Format([Date],"mmmm yyyy") & "#"),0)

Rightly or wrongly I changed the date format part as I thought maybe that was the problem and my queries have the date formatted as mmmm yyyy. However all date formats I tried (including the Australian one of dd/mm/yyyy gave me a zero prev balance. I dont actually understand what this formula is doing so makes it hard to fix. Any explanation would be much appreciated
Thanks again

I had the same problem with ODBC data from an Accounting package and like you I was really only using it for reporting. Eventually I got to the stage that each month, I delete all the data in the tables then reimport the data into the existing tables (thus preserving relationships but being sure I had up to date data) . Means I spend 15 mins or so each month importing all the data but overcame the ODBC speed problem
Steve (holy molly an answer from me rather than a question – It will probably turn out I misunderstood the question :-0

I had the same problem with ODBC data from an Accounting package and like you I was really only using it for reporting. Eventually I got to the stage that each month, I delete all the data in the tables then reimport the data into the existing tables (thus preserving relationships but being sure I had up to date data) . Means I spend 15 mins or so each month importing all the data but overcame the ODBC speed problem
Steve (holy molly an answer from me rather than a question – It will probably turn out I misunderstood the question :-0

Thanks for your help anyway
Steve

Thanks for your help anyway
Steve

Thanks for the quick response Hans (I’ve lost track of how many beers I owe you)
I wasnt actually expecting the links to work in Access but for the format to be carried over to the pdf files and maybe work there
Steve

Thanks for the quick response Hans (I’ve lost track of how many beers I owe you)
I wasnt actually expecting the links to work in Access but for the format to be carried over to the pdf files and maybe work there
Steve

Thanks for response
Nope only 1 identity/account
No I can see the creteria components but cannot modify/select in any way

Thanks for response
Nope only 1 identity/account
No I can see the creteria components but cannot modify/select in any way

Exactly what it was – I had been a good boy and was graduating from storing words to (eg Riders Names) to the correcter !! way of RiderID etc and had forgotten I was storing the PaymentmethodID instead of the payment method word.

Thank you both again – At this point you must wake up screaming when you see my inane questions and it must be hard working out who is going get the short straw and have to help the idiot this time
It really is appreciated
Steve

Exactly what it was – I had been a good boy and was graduating from storing words to (eg Riders Names) to the correcter !! way of RiderID etc and had forgotten I was storing the PaymentmethodID instead of the payment method word.

Thank you both again – At this point you must wake up screaming when you see my inane questions and it must be hard working out who is going get the short straw and have to help the idiot this time
It really is appreciated
Steve

In Page setup, make sure you have the report going to a specific printer (and obviously choose the appropriate one), not to the default printer. This solved a similar problem I had
Steve