S
Scott N. Weber
We have an Access invoice application that we wrote for a customer. It has
been running ok in one location. We installed it at another location which
has 3 computers. It runs ok on one of the computers, the other two computers
get a #Error when a new line item is entered on the sub form. Basically We
have a main form bound to a table called InvoiceHeader and a subform on the
main form which is bound to a table called InvoiceFooter. We have a
Sum([extension]) in the Footer section of the subform, which we reference on
our main form to display the total of the items sold. This is what is giving
us the #Error when we ad a new line item.
We have been working with this for 72 hours (almost) straight and have
experimented extensively and have found the following:
1)It is not specific to either Access 2000 or Access 2002, same symptom
happens in both version, using both version formats (front end only)
2)It does not matter if our tables are linked to SQL 2000 Server or to
Access 2000 mdb files or are non-linked access tables, we get the same
problem.
3)If we remove all of the code from the Main and Sub forms, it works without
any problem, but obviously our application does not.
4)If we re-introduce the code back into the form one procedure at a time it
works until it hits a DoCmd.RunSQL line.
5)Thinking there maybe a problem with one of the references in VBA I checked
them all and they all were good and the actual files being used were either
consistent across the board regarding there version numbers or inconsistent
with the problem. The references are: a)Visual Basic for Applications,
b)Microsoft Access 10.0 (or 9.0) Object Library, c)Microsoft DAO 3.6 Object
Library and d)Microsoft ActiveX Data Objects 2.1 Library.
6)We have removed office completely and re-installed it into a new folder
(after deleting the previous folder). No difference.
7)Runtime being installed vs. not being installed doesn't matter.
8)We have tested other computers with it and it works fine, even over the
internet (when linked to the SQL tables).
Any ideas would be greatly appreciated. Thanks.
been running ok in one location. We installed it at another location which
has 3 computers. It runs ok on one of the computers, the other two computers
get a #Error when a new line item is entered on the sub form. Basically We
have a main form bound to a table called InvoiceHeader and a subform on the
main form which is bound to a table called InvoiceFooter. We have a
Sum([extension]) in the Footer section of the subform, which we reference on
our main form to display the total of the items sold. This is what is giving
us the #Error when we ad a new line item.
We have been working with this for 72 hours (almost) straight and have
experimented extensively and have found the following:
1)It is not specific to either Access 2000 or Access 2002, same symptom
happens in both version, using both version formats (front end only)
2)It does not matter if our tables are linked to SQL 2000 Server or to
Access 2000 mdb files or are non-linked access tables, we get the same
problem.
3)If we remove all of the code from the Main and Sub forms, it works without
any problem, but obviously our application does not.
4)If we re-introduce the code back into the form one procedure at a time it
works until it hits a DoCmd.RunSQL line.
5)Thinking there maybe a problem with one of the references in VBA I checked
them all and they all were good and the actual files being used were either
consistent across the board regarding there version numbers or inconsistent
with the problem. The references are: a)Visual Basic for Applications,
b)Microsoft Access 10.0 (or 9.0) Object Library, c)Microsoft DAO 3.6 Object
Library and d)Microsoft ActiveX Data Objects 2.1 Library.
6)We have removed office completely and re-installed it into a new folder
(after deleting the previous folder). No difference.
7)Runtime being installed vs. not being installed doesn't matter.
8)We have tested other computers with it and it works fine, even over the
internet (when linked to the SQL tables).
Any ideas would be greatly appreciated. Thanks.