Updating several tables with email collect - please help

I have built an inventory control database for a mid-size police department.
I have several tables (employee,firearms,radios,vehicles). I am working on
sending out an HTML email for updating (verifying) data that has already been
manually entered. My question is, I cannont add information from multiple
tables in the HTML email form for collecting data. What is the best way, I
created a large table with all the information from all the rest of the
tables and can send it that way but i want to make sure i can update the
other tables (how do it do that).

Please Help.

josh

Josh

Don't create another table and 'duplicate' your data.

That's what queries are for.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"jwaites-ccpd" wrote in message
...
I have built an inventory control database for a mid-size police
department.
I have several tables (employee,firearms,radios,vehicles). I am working on
sending out an HTML email for updating (verifying) data that has already
been
manually entered. My question is, I cannont add information from multiple
tables in the HTML email form for collecting data. What is the best way, I
created a large table with all the information from all the rest of the
tables and can send it that way but i want to make sure i can update the
other tables (how do it do that).

Please Help.

josh

Thank you.. but i tried the query thing and you cant make a collect email out
of it because querys are not modifiable. This is why i need the help..

"jwaites-ccpd" wrote:

I have built an inventory control database for a mid-size police department.
I have several tables (employee,firearms,radios,vehicles). I am working on
sending out an HTML email for updating (verifying) data that has already been
manually entered. My question is, I cannont add information from multiple
tables in the HTML email form for collecting data. What is the best way, I
created a large table with all the information from all the rest of the
tables and can send it that way but i want to make sure i can update the
other tables (how do it do that).

Please Help.

josh

Thank you.. but i tried the query thing and you cant make a collect email out
of it because querys are not modifiable. This is why i need the help..

"jwaites-ccpd" wrote:

I have built an inventory control database for a mid-size police department.
I have several tables (employee,firearms,radios,vehicles). I am working on
sending out an HTML email for updating (verifying) data that has already been
manually entered. My question is, I cannont add information from multiple
tables in the HTML email form for collecting data. What is the best way, I
created a large table with all the information from all the rest of the
tables and can send it that way but i want to make sure i can update the
other tables (how do it do that).

Please Help.

josh

On Tue, 7 Jul 2009 18:38:01 -0700, jwaites-ccpd
wrote:

Thank you.. but i tried the query thing and you cant make a collect email out
of it because querys are not modifiable. This is why i need the help..

SOME queries are not modifiable. Most are. Please post the SQL view of your
query and someone may be able to suggest how to make it updateable.
--

John W. Vinson [MVP]

On Tue, 7 Jul 2009 18:38:01 -0700, jwaites-ccpd
wrote:

Thank you.. but i tried the query thing and you cant make a collect email out
of it because querys are not modifiable. This is why i need the help..

SOME queries are not modifiable. Most are. Please post the SQL view of your
query and someone may be able to suggest how to make it updateable.
--

John W. Vinson [MVP]

SELECT [Employee Master Information - Master].[Emp#], [Employee Master
Information - Master].[Log Turned In], [Employee Master Information -
Master].[Last Name], [Employee Master Information - Master].[First Name],
[Employee Master Information - Master].Middle, [Employee Master Information -
Master].Division, [Employee Master Information - Master].Unit, [Employee
Master Information - Master].[Street #], [Employee Master Information -
Master].[Street Name], [Employee Master Information - Master].Bldg, [Employee
Master Information - Master].Apt, [Employee Master Information -
Master].City, [Employee Master Information - Master].State, [Employee Master
Information - Master].[Zip Code], [Employee Master Information -
Master].[home area], [Employee Master Information - Master].[home phone],
[Employee Master Information - Master].DOB, [Employee Master Information -
Master].DOE, [Employee Master Information - Master].[Cell area], [Employee
Master Information - Master].[Cell Number], [Employee Master Information -
Master].Shift, [Employee Master Information - Master].[Off Day], [Employee
Master Information - Master].Rank, [Employee Email Address].[Email Address],
[Computer Information].[Serial Number], [Computer Information].Category,
[Computer Information].Make, [Computer Information].Model, [Computer
Information].Aircard, Firearms.Make, Firearms.Model, Firearms.[Serial #],
Pager.Make, Pager.Model, Pager.serial, Pager.[telephone number], [Portable
Radio].[Serial Number], [Portable Radio].Make, [Portable Radio].Model,
[Portable Radio].[Asset Number], [Portable Radio].MDC, [Portable Radio].[Mic
Attached], [Vehicle Information].Number, [Vehicle Information].Year, [Vehicle
Information].Make, [Vehicle Information].Model, [Vehicle Information].Type,
[Vehicle Information].Assignment, [Vehicle Information].[Assigned to],
[Vehicle Information].Color, [Vehicle Information].[Take Home], [Vehicle
Information].Mileage, [Vehicle Information].Mileage
FROM ((((([Employee Master Information - Master] LEFT JOIN [Employee Email
Address] ON [Employee Master Information - Master].[Emp#] = [Employee Email
Address].[Employee Number]) LEFT JOIN [Computer Information] ON [Employee
Master Information - Master].[Emp#] = [Computer Information].[Assigned to])
LEFT JOIN Firearms ON [Employee Master Information - Master].[Emp#] =
Firearms.[Emp#]) LEFT JOIN Pager ON [Employee Master Information -
Master].[Emp#] = Pager.[assigned to]) LEFT JOIN [Portable Radio] ON [Employee
Master Information - Master].[Emp#] = [Portable Radio].[Employee assigned])
LEFT JOIN [Vehicle Information] ON [Employee Master Information -
Master].[Emp#] = [Vehicle Information].[Employee #];


"John W. Vinson" wrote:

On Tue, 7 Jul 2009 18:38:01 -0700, jwaites-ccpd
wrote:

Thank you.. but i tried the query thing and you cant make a collect email out
of it because querys are not modifiable. This is why i need the help..

SOME queries are not modifiable. Most are. Please post the SQL view of your
query and someone may be able to suggest how to make it updateable.
--

John W. Vinson [MVP]

On Wed, 8 Jul 2009 05:28:01 -0700, jwaites-ccpd
wrote:

SELECT [Employee Master Information - Master].[Emp#], [Employee Master
Information - Master].[Log Turned In], [Employee Master Information -
Master].[Last Name], [Employee Master Information - Master].[First Name],
[Employee Master Information - Master].Middle, [Employee Master Information -
Master].Division, [Employee Master Information - Master].Unit, [Employee
Master Information - Master].[Street #], [Employee Master Information -
Master].[Street Name], [Employee Master Information - Master].Bldg, [Employee
Master Information - Master].Apt, [Employee Master Information -
Master].City, [Employee Master Information - Master].State, [Employee Master
Information - Master].[Zip Code], [Employee Master Information -
Master].[home area], [Employee Master Information - Master].[home phone],
[Employee Master Information - Master].DOB, [Employee Master Information -
Master].DOE, [Employee Master Information - Master].[Cell area], [Employee
Master Information - Master].[Cell Number], [Employee Master Information -
Master].Shift, [Employee Master Information - Master].[Off Day], [Employee
Master Information - Master].Rank, [Employee Email Address].[Email Address],
[Computer Information].[Serial Number], [Computer Information].Category,
[Computer Information].Make, [Computer Information].Model, [Computer
Information].Aircard, Firearms.Make, Firearms.Model, Firearms.[Serial #],
Pager.Make, Pager.Model, Pager.serial, Pager.[telephone number], [Portable
Radio].[Serial Number], [Portable Radio].Make, [Portable Radio].Model,
[Portable Radio].[Asset Number], [Portable Radio].MDC, [Portable Radio].[Mic
Attached], [Vehicle Information].Number, [Vehicle Information].Year, [Vehicle
Information].Make, [Vehicle Information].Model, [Vehicle Information].Type,
[Vehicle Information].Assignment, [Vehicle Information].[Assigned to],
[Vehicle Information].Color, [Vehicle Information].[Take Home], [Vehicle
Information].Mileage, [Vehicle Information].Mileage
FROM ((((([Employee Master Information - Master] LEFT JOIN [Employee Email
Address] ON [Employee Master Information - Master].[Emp#] = [Employee Email
Address].[Employee Number]) LEFT JOIN [Computer Information] ON [Employee
Master Information - Master].[Emp#] = [Computer Information].[Assigned to])
LEFT JOIN Firearms ON [Employee Master Information - Master].[Emp#] =
Firearms.[Emp#]) LEFT JOIN Pager ON [Employee Master Information -
Master].[Emp#] = Pager.[assigned to]) LEFT JOIN [Portable Radio] ON [Employee
Master Information - Master].[Emp#] = [Portable Radio].[Employee assigned])
LEFT JOIN [Vehicle Information] ON [Employee Master Information -
Master].[Emp#] = [Vehicle Information].[Employee #];

g Ok... a seven table query probably WON'T be updateable. Are you in fact
collecting email information for all seven tables? If you use a maketable
query, how do you get the collected information back into the seven tables (or
do you)?
--

John W. Vinson [MVP]