Form Design

[mike30x]

I am in a spot of bother I have a form which i want to use for testing devices the only problem is each device has different testing protocols. The only thing that is similar is the device details and the Test format.

What i have done so far is linked the checklists to the device name so that when you select the device the checklist and checkboxes become visible. This was working fine but now i have to stack other checkboxes on top of them and it is getting a bit messy. The plan to have one sheet seems to be a little to much to bite off.

Does anyone have any ideas how i can do this can i import a table for each device type ?? Looking for best design practice here...

 

[DCrake]

Simple Software Solutions

Can you categorise your testing procedures? If so, I suggest you use a tab control on your form. Above your tab control you place your product and in each of the tab pages you can place the check boxes. If I understand your problem properly you can have a varing amount of tests depending on the product selected. And by the way you describe it you simply want to tick a check box to indicate as to whether the test has been carried out? Why not use a combo box to select the product and list box to contain the tests and make the list box a multi select. The use can then simply hightlight the tests performed and click a save button to write the changes to a log file for that product.

CodeMaster:

 

[mike30x]

That sounds good, what i have done is linked the device type to the tab control what would be perfect if i could get the page of the tab control to open for the particular device the code i was using is below can i get the particular page of the tab to open also with out the other??

If Me.Equipment_Type.Value = "Device1" Then
TabCtl155.Visible = True
Else
TabCtl155.Visible = False
End If

 

[DCrake]

Simple Software Solutions

Each tab control has one or many pages to refer to individual pages use the .tab(nIndex) syntax. so if you pick a certain product you can state which tab page get the control first. But yes you can make individual tab pages visible.

You would put this on the AfterUpdate of the combobox.

David

 

[mike30x]

Sorry about this but my coding is at an early stage (very Early) can you give me an example using the syntax. Thanks

 

[mike30x]

I got it to work probaly could be cleaned up a bit seems a bit long winded for what it is doinf espically when i have another 15 sheets the code will be huge.

If Me.Equipment_Type.Value = "Device1" Then
TabCtl155.Visible = True
Else
TabCtl155.Visible = False
End If

If Me.Equipment_Type.Value = "Device1" Then
Page156.Visible = True
Else
Page156.Visible = False
End If

 

[DCrake]

Simple Software Solutions

The crux of the matter is that each product can have a varing amount of sub procedures link to it. And as I assume you want to record if and when certain sub procedures are/were carried out. Correct?

Another issue is that the same procedure can be performed on various products (Many products : Many procedures) and some products have procedures that are unique to that product.

So somehow you need to be able to detect which sub procedures are linked to a product. On one of your tab control pages have the common procedures and on a seperate page have the unique procedures these, will be refreshed each time you choose a different product.

So infact you only need 2 tab pages.

If I am barking up the wrong tree then you will need to clarify the situation more clearly.

David

 

[mike30x]

The only fields that are similar between products are the Equipment Details and Results fields the checklists, Test Format and electrical safety details for each device is different so i will have 15 tabs. The tabs certainly make it much easier to control