queries and the "create email" function

[schreima]

I have a simple database where I need people to update information via the "create email" function.

The database is essentially two tables and a query.

"TblFaculty" has "FacultyID" as a primary key. "LastName", "FirstName" and "Email".

"TblDelays" has "ID" as a primary key. "FacultyID" which is related to the other table. There are a few other fields to track information here.

The query I'd like to run the email off of (qryDelays) has "FacultyId", "Email", "name" (which is a combination field of First and Last names in TblFaculty). And a few other fields from TblDelays.

When I highlight the qry and hit Create Email, it does not give me the option of choosing whether I want to collect new data or update existing data, it's new data only which is not what I need. When I highlight either of the tables, it IS presented as an option, but the email needs to run off the qry. Any help would be appreciated, Thanks. -Matt

 

[misscrf]

I don't really understand the Create Email that you are hitting. Is that a button on a form? How does highlighting the query and hitting that button connect?

The only thing I notice is that you use "name" for the name of your concatentation of first and last. name is a reserved "name". I would change that for posterity. Maybe FullName.

HTH

misscrf

It is never too late to become what you could have been ~ George Eliot

 

[TheAceMan1]

How are ya schreima . . .

Perhaps if you post the query we could make better sense out of this. Your post origination is quite vague!

Be aware ... we don't know whats in your head, nor can we see the Db as as you see it in front of you ...

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[Lilliabeth]

You cannot use email to update existing records if You are collecting data to populate two or more tables.

See Item 5 at this link:

http://office.microsoft.com/en-us/access/HA100154271033.aspx?pid=CH100645721033

--Lilliabeth