Hello everyone.
I've created Access DB's in the past and have always been able to fight my way through problems with online research and trial and error. But I'm trying something that I've never done before and I simply can't get it to happen the way I would like.:banghead:
I have a tabbed form based on a table that is an inventory of closed-circuit TV cameras. There are many data fields in the inventory so they are broken up across several different tabs. These cameras are located in many different places, so I have some VB code that requeries all of the data about a particular camera based on the location I choose from a combo box. All works well...so far so good.
Now, the problem. I want to create a subform that would serve as a maintenance ticketing system for when one of the cameras breaks down or needs preventative maintenance...and that is where I'm having problems. I would like the subform to appear in one of the tabs.
I initially created a separate table for the maintenance ticketing with fields that are different from the fields in the inventory table. However, I wanted some of the fields from the original inventory table to show up in a report that combines the two tables (inventory and maintenance ticketing), so the report can be e-mailed to a maintenance team. So, here's how I want to combine the table data into one report:
Table 1 (Inventory)
Device ID
Location
Corridor
Mile Post
Table 2 (Maintenance)
Date
Priority
Requester
Response Number
Malfunction
Other Malfunction
Vendor Assignment
Please let me know if I need to elaborate. Any help would be GREATLY appreciated, because I'm at my wits end!
I've created Access DB's in the past and have always been able to fight my way through problems with online research and trial and error. But I'm trying something that I've never done before and I simply can't get it to happen the way I would like.:banghead:
I have a tabbed form based on a table that is an inventory of closed-circuit TV cameras. There are many data fields in the inventory so they are broken up across several different tabs. These cameras are located in many different places, so I have some VB code that requeries all of the data about a particular camera based on the location I choose from a combo box. All works well...so far so good.
Now, the problem. I want to create a subform that would serve as a maintenance ticketing system for when one of the cameras breaks down or needs preventative maintenance...and that is where I'm having problems. I would like the subform to appear in one of the tabs.
I initially created a separate table for the maintenance ticketing with fields that are different from the fields in the inventory table. However, I wanted some of the fields from the original inventory table to show up in a report that combines the two tables (inventory and maintenance ticketing), so the report can be e-mailed to a maintenance team. So, here's how I want to combine the table data into one report:
Table 1 (Inventory)
Device ID
Location
Corridor
Mile Post
Table 2 (Maintenance)
Date
Priority
Requester
Response Number
Malfunction
Other Malfunction
Vendor Assignment
Please let me know if I need to elaborate. Any help would be GREATLY appreciated, because I'm at my wits end!
