IR_Moon
Registered User.
- Local time
- Today, 22:19
- Joined
- Jun 6, 2006
- Messages
- 20
Hi there!
I've searched all over for a solution to my (well my users) recurring problem.
I have a form which holds invoice data in it. This is for incoming invoices - i.e. generated by other suppliers - stuff we pay not stuff we're paid for. On this form I have a subform that contains all of the invoice lines. Every now and again for no paticular reason (none that I can see anyhoo), when a new invoice is created this subform becomes "disconnected" from the main invoice form, locking in the line records from the previous invoice. I can't for the life of me (after months!!) see any reason for this happening and as the parent is linked to the child by the invoice number it is (in theory) impossible.
As a bit of a background I have one front end on each pc (about 10 of them) all accessing backends on the server. The database dynamically links to a particular backend mdb dependant on the client selected. Sound confusing I know, but basically think of it as typical client:server be:fe with a maximum of one user at a time.
I'm just curious if anyone has seen such behaviour before and might offer a bunch of reasons why this might happen. I'm a little loathe to share up too much in the way of code as a.) it's a serioius pain and b.) alot of the code was written by a previous (overly sensitive) developer. I'm fearing front end corruption, but as said it's been MONTHS and this problem is driving my users nuts.
Any simple suggestions at all?
I've searched all over for a solution to my (well my users) recurring problem.
I have a form which holds invoice data in it. This is for incoming invoices - i.e. generated by other suppliers - stuff we pay not stuff we're paid for. On this form I have a subform that contains all of the invoice lines. Every now and again for no paticular reason (none that I can see anyhoo), when a new invoice is created this subform becomes "disconnected" from the main invoice form, locking in the line records from the previous invoice. I can't for the life of me (after months!!) see any reason for this happening and as the parent is linked to the child by the invoice number it is (in theory) impossible.
As a bit of a background I have one front end on each pc (about 10 of them) all accessing backends on the server. The database dynamically links to a particular backend mdb dependant on the client selected. Sound confusing I know, but basically think of it as typical client:server be:fe with a maximum of one user at a time.
I'm just curious if anyone has seen such behaviour before and might offer a bunch of reasons why this might happen. I'm a little loathe to share up too much in the way of code as a.) it's a serioius pain and b.) alot of the code was written by a previous (overly sensitive) developer. I'm fearing front end corruption, but as said it's been MONTHS and this problem is driving my users nuts.
Any simple suggestions at all?
