Hi all, am having a strange problem!!
Access 2010 - split into a front and back end
In an invoicing form that calcs wine sales and therefore GST and WET tax it seems that some users are adding a record and all the correct percentages etc for the calcs are being added correctly to the backend but the form and report aren't displaying the calculations and therefore the total. It seems to be a random issue but more peculiar to some users. If I take a copy of their backend and put on my laptop I get the problem but if I go into the backend datafile into the actual table and check the record is displaying it should it looks fine. The strange thing is then when I go back to the form and report to check it the calcs are appearing. It's like by opening the table its triggering something!!!! wtf lol
Has anyone ever encountered this type of peculiar behaviour?
Have imported, compacted etc etc done all the usual things that normally get any wonky things out but still doing it.
Thanks in advance, Rachael
Access 2010 - split into a front and back end
In an invoicing form that calcs wine sales and therefore GST and WET tax it seems that some users are adding a record and all the correct percentages etc for the calcs are being added correctly to the backend but the form and report aren't displaying the calculations and therefore the total. It seems to be a random issue but more peculiar to some users. If I take a copy of their backend and put on my laptop I get the problem but if I go into the backend datafile into the actual table and check the record is displaying it should it looks fine. The strange thing is then when I go back to the form and report to check it the calcs are appearing. It's like by opening the table its triggering something!!!! wtf lol
Has anyone ever encountered this type of peculiar behaviour?
Have imported, compacted etc etc done all the usual things that normally get any wonky things out but still doing it.
Thanks in advance, Rachael