You need Microsoft Office 2000-Developer Tools-it has the same capabilities that microsoft used to package under Microsoft ODE Tools. Problem is that this is hard to find now since they are currently selling Microsoft Office XP and getting this older program is hard. I suggest you try E-Bay...
You can put an unbound control at the sector footer of the report and put a SQL statement in the Control Source of that control that would do a DCount on records from the table that have a criteria of StaffStatus="Full Time".
It would read something like:
=...
I cannot tell you why this would not work in 2000 but my bet is the syntax of the Criteria is the problem.
I would suggest an alternative approach. The form you want to open must be bound to a table or query. If it is bound to a table make up a query that is identical to the table. Now put...
I am deploying a Microsoft Access 2000 application with an Access2000 Runtime using Install Shield. My application has a custom tool bar that has on it the Linked Table Manager.
The data1.msi package that Microsoft provides InstallShield to use to set up the Runtime does not include the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.