C
ConnerS
I have a database in Access with Parent database and
Parent volunteer event subdatabase. Data is entered into
the subdatabase using a form in frontpage. That works.
The Parent table is supposed to add up all the individual
events and show cumulative hours, which it does when you
run the query in Access. My question is either
1. How can I make the query run automatically within
Access every time the subdatasheet is updated, or
2. How do I get the data access page from Access to show
the data from the database in Internet Explorer(I can open
the page, but only the title of the page shows), or
3. How can I get the parent datasheet to show the sum of
a field in the child datasheet?
Any thoughts?
Parent volunteer event subdatabase. Data is entered into
the subdatabase using a form in frontpage. That works.
The Parent table is supposed to add up all the individual
events and show cumulative hours, which it does when you
run the query in Access. My question is either
1. How can I make the query run automatically within
Access every time the subdatasheet is updated, or
2. How do I get the data access page from Access to show
the data from the database in Internet Explorer(I can open
the page, but only the title of the page shows), or
3. How can I get the parent datasheet to show the sum of
a field in the child datasheet?
Any thoughts?