It would be a good idea too if you can put a field indicating the DATE DUE for maintenance of each item just like what I wanted to do with my ventilator DUE maintenance date in this Hospital where I work. I'll watch out for the development of your airplane database and hope I can pick-up from this.
btw.. I am new to the grp and hope to gain a lot of advise from co-members. Thanks, MrModerator for hooking me in.
--- In AccessVBACentral@yahoogroups.com, "Eric Patterson" <epatterson@...> wrote:
>
> SUBJECT: Looking for Access VBA modual programing.
>
> I have a warranty claims database for WorkOrders to repair airplanes when
> they come into for maintenance. Whenever warranty is filed a Claim is
> submitted so that the shop can be reimbursed for parts and work performed
> from the manufacture. In a claim there can be multiple line items that
> were fixed. However the data is recorded record-by- record for each item
> that was fixed. In one field is a notes text field that is filled out by
> the mechanic describing what the defect was. (Field Name: Squawk) and
> another text field that explains how the defect was repaired by the
> mechanic (Field: Action). Here is a list of fields:
>
> Field 1.) CLAIMNO; Field 2.) SQUAWKNO; Field 3.) SEQNUMBER; Field 4.)
> CODETYPE ; Field 5.) NOTETEXTS
>
> The `CODETYPE' field is coded with the letter "F" for "Failure" to
> describe the wording in the "NOTETEXT" field. A letter "A" in the
> `CODETYPE' field describe what "Action" that was taken to repair or
> correct the failure in the "NOTETEXTS" field.
>
> In some NOTETEXTS field there may be empty lines so there needs to be
> some programming to ignore empty text lines.
>
> Here is how the data is recorded now in a database:
>
> CLAIMNO SQUAWKNO SEQNUMBER CODETYPE NOTETEXTS
> 234568 1 1 F Per Sam Rogers at Williams International, comply
> 234568 1 2 F with FADEC downloads. Contact for assistance with
> 234568 1 3 F Tech Rep George Smith.
> 234568 1 4 F Williams International ref number is 23456ADS
> 234568 1 5 F
> 234568 1 6 F Download cable found to be defective.
>
> 234568 1 1 A Hooked up laptop for download. Attempted to
> 234568 1 2 A download bat software for -7 engine. Software was not
> 234568 1 3 A in laptop. Contacted Williams! He sent -4 config. files
> 234568 1 4 A for laptop. Loaded files and download EMT files
> 234568 1 5 A Everything is working fine now. Changed cable.
>
> I want to concatenate the (Failure, NOTETEXTS) field into a memo field
> and concatenate the (Action, NOTETEXTS) into a memo field then pull
> "Failure" and "Action" memo field together to form only one record like
> the example below.
>
> This is how I like the data to look afterwards:
>
> CLAIMNO SQUAWKNO NOTETEXTS
> 234568 1 Squawk: Per Sam Rogers at Williams International, comply with
> FADEC downloads. Contact for assistance with Tech Rep George Smith.
> Williams International Ref number is 23456ADS. Action: Hooked up laptop
> for download. Attempted to download Bat software for -7 engine. Software
> was not in laptop. Contacted Williams! He sent -4 configuration files for
> laptop. Loaded files and download EMT files. Everything is working fine
> now. Changed cable. EOF
>
>
>
> I have tried to find a Access example on the web but cannot find one that
> works with this many fields. I hope I have explain my problem very well.
> If please send me additional questions.
>
> Thanks
>
> Eric
>
>
>
> Eric Patterson
>
Nenhum comentário:
Postar um comentário