A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

From Query to Table via Form?



 
 
Thread Tools Display Modes
  #1  
Old October 3rd, 2007, 02:51 PM posted to microsoft.public.access.forms
FerryMary
external usenet poster
 
Posts: 4
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:12 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.