Complex Coding --> Please Help

[JFo]

Hi Rain been working since I spoke to you on what I thought was the next stage and I think I am on the right track. Would love some feedback/ advice at this stage.

I have now imported or created 6 more tables and created relationships

and created 3 more forms (including sub-forms

frmContacts
frmEquipment


frmInspections

They seem to be working quite well

In my mind this is all the forms for the main menu however completely at a loss how to implement/ initiate an Equipment Inspection even if I can get this stage working

Appreciate your feedback... am I getting this sussed slowly but surely

Thanks

[JFo]

thanks

Attachment 4898

[Rainlover]

Looking good, finally. Yea.

With State. This Control should be locked so that it cannot be Added or Edited. The States are preset in the Table.

Tidy up time. When frmInspections is opened it displays in the Top left corner of the screen "frmClients". Needs to be fixed along with a bunch of other controls. Tedious job but good practice and will help later.

Also fix the Exit Button on frmMenu.

What is the problem with frmInspections.

[Rainlover]

I want you to open the Query view of the Record Source of one of the Forms that are made up of more than one table. frmInspections will do.

Have a look at the Relationships between the Tables.

Right click on one of the Joining lines. There you will have three choices. Make sure you have the correct one selected. This is the same as Inner Join or Outer Join.

[JFo]

Looking good, finally. Yea. About time

With State. This Control should be locked so that it cannot be Added or Edited. The States are preset in the Table. Done

Tidy up time. When frmInspections is opened it displays in the Top left corner of the screen "frmClients". Needs to be fixed along with a bunch of other controls. Tedious job but good practice and will help later. Not sure what u mean by frmClients maybe already did this, cleaned up a bit anyway

Also fix the Exit Button on frmMenu. Not sure again but have done something here

What is the problem with frmInspections. No problem anymore I think

Thanks

Attachment 4900

[Rainlover]

In regard to answers on the Inspections.

Are the answers unique for each piece of equipment or each equipment type.

I am thinking each piece of equipment as there are certain Numbers etc that you need to record against each piece.

[Rainlover]

Look at the Properties for frmInspection.

Look at Caption. It reads frmClients. Should be "Inspections".

[JFo]

I want you to open the Query view of the Record Source of one of the Forms that are made up of more than one table. frmInspections will do.

Have a look at the Relationships between the Tables.

Right click on one of the Joining lines. There you will have three choices. Make sure you have the correct one selected. This is the same as Inner Join or Outer Join.

Noted this is handy to know, I will use this for sure

[JFo]

Look at the Properties for frmInspection.

Look at Caption. It reads frmClients. Should be "Inspections".

Updated, this is because it is easier to copy the form to preserve the theme for consistency, there will be a lot of this clean-up to be done renaming of controls, design, consistency, etc, however as you know how long I have been doing getting no where the functionality is my main priority

Noted

[Rainlover]

Also fix the Exit Button on frmMenu.

DoCmd.Close should be DoCmd.Quit to totally close the Database.

[JFo]

In regard to answers on the Inspections.

Are the answers unique for each piece of equipment or each equipment type.

I am thinking each piece of equipment as there are certain Numbers etc that you need to record against each piece.

Yes you are correct unique for each piece of equipment

[Rainlover]

Yes you are correct unique for each piece of equipment

Dash Bother etc

I have some ideas on how to do this but I need some time.

Will write when I need further clarification.

[JFo]

Yes you are correct unique for each piece of equipment

Dash Bother etc

I have some ideas on how to do this but I need some time.

Will write when I need further clarification.

Can we not use the same design I had before we started again in some way.

Although I didn't like the layout, navigation and it was not working in edit mode it actually did some things that I had been working the whole time to do

Once you selected the piece of equipment for an inspection

- It opened the specific check-list and dynamically populated every relevant question dependant on EquipType.
- It also stored all questions, answers and relevant data in Results Table and tblCommonAnswers,
- It also allowed me to default a specific Checklist Question Answer with the last inspection value and
- it also allowed me to use validation on any specific question /answer

[Rainlover]

If you have a solution then Go For It.

Post a copy when done.

[JFo]

Hi Rain

I have been pottering on myself and have done a few things

There are still many errors and things that don't work however I have come a long way I think

You can now inspect a piece of equipment and it should open the checklist for that equipment type, it should also default the answers to the last inspection and it also adds everything to tblResults

I have also added validation to the first question of pressure vessel so I know I can add to all questions individually

Things that I can't quite get to work at the moment
- Adding a piece of equipment to an inspection, this is difficult for me as want to use combos but can't figure out logic
- Adding the correct EquipInspectID to tblResults
- Not adding multiple instances to the same table, for example if I select the client or Inspector in table inspection or client in tblEquipment it seems to add the selection as a duplicate in the table I am selecting from
- The checklist shows random behaviour and selects too many questions at a time or if you open davit inspection it justs loops the same question over and over. I would also like to limit the amount of questions per page
- Cascading combo on addequiptoinspection issues but will figure out

Many other things to do just thought I'd show you my progress and appreciate your thoughts

Thanks

Attachment 4918