B
Bill Harris
I grabbed a copy of the free Tasks database (Tasks.accdb) for my
Access 2007 system. I modified it by creating a new query (Open Tasks
with Email) that linked the Contacts table and the Open Tasks query so
that I had one source with task data and the email address of the
responsible party.
Now I'd like to let people update or add to the data by email. Access
won't let me do that, because I've got more than one table linked in
that query. I have successfully let people add records to that
database.
I tried using a MakeTable query to store the query results in a new
table, but Access complains that "Multi-valued fields are not allowed
into SELECT INTO statements." (Presumably some of the lookups in that
table are multi-valued.)
Is there a way to let Access 2007 both add and update records by email
(HTML forms)?
Thanks,
Bill
Access 2007 system. I modified it by creating a new query (Open Tasks
with Email) that linked the Contacts table and the Open Tasks query so
that I had one source with task data and the email address of the
responsible party.
Now I'd like to let people update or add to the data by email. Access
won't let me do that, because I've got more than one table linked in
that query. I have successfully let people add records to that
database.
I tried using a MakeTable query to store the query results in a new
table, but Access complains that "Multi-valued fields are not allowed
into SELECT INTO statements." (Presumably some of the lookups in that
table are multi-valued.)
Is there a way to let Access 2007 both add and update records by email
(HTML forms)?
Thanks,
Bill