If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Updating several tables with email collect - please help
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 |
#3
|
|||
|
|||
Updating several tables with email collect - please help
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 |
#4
|
|||
|
|||
Updating several tables with email collect - please help
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 |
#5
|
|||
|
|||
Updating several tables with email collect - please help
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] |
#6
|
|||
|
|||
Updating several tables with email collect - please help
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] |
#7
|
|||
|
|||
Updating several tables with email collect - please help
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] |
#8
|
|||
|
|||
Updating several tables with email collect - please help
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] |
Thread Tools | |
Display Modes | |
|
|