We went through this 6 months ago. It is a horrible interaction between Access 2000 and post W98 operating systems, or with word2002, or what every MS wants you to believe. Our only solution for future efforts was to get a hot fix from MS. Other than that, make a new file, import forms one...
I conditionally formatted the back color of a field based on the value of another field. Works fine when the form is stand alone. When the form becomes a sub form, the conditional format quits working, as if not there. Any fix or is this a fact of life for conditional formatting? (Using...
What is the limit on number of fields for an append query, or is the limit expressed in some other way? I have one that gives me the mysterious "key violation" message, but it works ok if I remove any 4 fields. I experimented making a copy of the table that is receiving data and tried to...