Windows 7 64bit 
Access 2010 64bit
This is a hard problem to explain, but hopefully someone can give me some good ideas!
I have an Access database that we use for invoicing. When invoicing, we select several line items to be invoiced, click a "Finalise" button and then print off the invoice (which is just an Access report based on a table/query).
Less than 5% of the time, we have a situation where the invoice successfully prints but if we return to the same invoice later the same day, one of the line items is missing. Looking at the underlying table shows that the line item appears to be in an un-invoiced state, even though earlier we had successfully printed an invoice. This has me stumped, as the invoice would not print correctly unless the data was in the table, so it seems like the invoice data successfully gets into the table and then later reverts to an earlier un-invoiced state.
The users do not have access to the underlying tables etc so they are not able to fiddle around with the records.
Another weird thing is that we have been using this system for years but the problem has been cropping up regularly in the last few months.
Any ideas on how to troubleshoot this one?
Reply With Quote
Originally Posted by vicsaccess
