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
|
|||
|
|||
From Query to Table via Form?
Using:Access 2003
(I'm not even sure how to ask this, so patient people only probably need to proceed) Situation: Portion of my database deals with preventive maintenance performed to vessels. Originally I was instructed to utilize the database to create a library of sorts dealing with equipment on a fleet of vessels. Followed by a general table for entry that the maintenance had been completed, hours at time of service etc. To keep from having to repeat Prev.Maint items for each vessel I set up the following: tblfleet tblvesselCompartment(main engines, bow Thrusters, steering etc) tblVesselEquipment(specific equipment with serial numbers, Maintenance Reference*) *tblMaintRef(Lists Maintenance Categories) tblPreventive Maintenance List(ex. 'Check Air-Box Shutdowns') tblPrev Maint Ref(ex.'pg 20 of disassembly and assembly publication # SENR2377-02) Using a query with find records by Vessel ID I can create this nifty report for a full Preventive Maintenance Systems Check for all systems per vessel. NOW, my problem. Since alot of the preventive items and references are the same for various vessels and peices of equipment I used the set up listed above, because I was told that a general service report showing service was complete was what we wanted. Now, I'm told that what we want to be able to do is follow the list using the computer and check-off each item, date, person responsible and comments. Obviously I'll need a table to hold the information and I have a handle on which fields I need. I've already copied and modified query involved. But am unsure how to use a form to pull the worklist, add the results and save ALL(?) to a table. Just typing it out is giving me a few new ideas. But time is my enemy this week and any help would be most appreciated. Thanks so much |
Thread Tools | |
Display Modes | |
|
|