Re: Saving as HTML

From: Conners (anonymous_at_discussions.microsoft.com)
Date: 06/21/04 

Date: Sun, 20 Jun 2004 20:51:34 -0700

I believe my question is related question to "K"'s
I have a database in Access with "Contact" table and
Parent volunteer event subdata*** "detail". Data is
entered into the subdata*** 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. The query is:
UPDATE Contact SET Contact.CumulativeHours = DSum
("HoursEvent","Detail","[NameID]=" & [Contact].[NameID])
WHERE EXISTS (SELECT * FROM [Detail] WHERE [Contact].
[NameID] = [Detail].[NameID]) That works within Access.

My question is either
1. How can I make the query run automatically within
Access every time the subdata*** is updated, or as it
relates to "K"'s question, how can I give the user ability
to run the query to update the Contact table? I am
using .asp pages to post and see results.
I have also tried several other methods...
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 data*** to show the sum of
a field in the child data***?
Any thoughts?

>-----Original Message-----
>Yes it is possible.
>I have not heard of anyone actually doidng it with DAPs
though.
>It is more common to use ASP code.
>Now you can use ASP.Net.
>--
>Joe Fallon
>Access MVP
>
>
>
>"K" <anonymous@discussions.microsoft.com> wrote in message
>news:1d79a01c453f8$4d1a98c0$a501280a@phx.gbl...
>> I understand how to create a Data Access Page so that my
>> users can manipulate the data over the web. But I don't
>> want just one page to be available to them - I want the
>> whole database available over the web, running queries
and
>> macros and printing reports, all on the one site with
>> everything interconnected. Is this possible?
>
>
>.
>

Loading