Template in TAB Control

[sajarac]

Good Morning masters.....
I have two questions and I would like to receive some advice, here they are:

1. when you insert a "TAB CONTROL" is possible to have a button that insert a new page in the "TAB CONTROL" ?

2. In the tab control I want to insert a subform, is possible that this subform has pre-defined ites? i.e lets say the main database in an inventory of a condominium, in the tab control the page 1 is the suite 100, page 2 suite 101, page 3 suite 102, and so on. and inside every single page I want a template with a list of the house items, but pre-defined.

Is this possible?

Thank you very much for any assisstance.

Regards

Sajarac

 

[Minty]

Item 1. No this is a design function. Whilst not completely impossible, it wouldn't work in a runtime environment. Also see 2
Item 2. This sounds as if you have a poor basic database design. You shouldn't need to create a page for every suite, you should have your data stored in such a way as to display a variable number of suites that could be 1, 4 or a 100.

Can you post up a picture of your table design and relationships ?

 

[sajarac]

thank you very much for your prompt reply, even is the news are not good for me, I don't have a database yet is just and idea, I would like to do it using MS Access, I know just a little bit of access I'm not a master like you. here is the main concept.

I used to go to my customer, Customer X, could be record 1, and do an assessment, my customer can have several buildings usually from 1 to 20 buildings 20 is the maximum, that is why I want to add buildings as we need it. and in every single building a need to do a checklist is the same items, i.e number of windows, number of doors , material, status, etc.

that is why I want a template because is so many items and I don't want to miss anyone just because is not in that list.

I don't know if you get the idea?
Please let me know and thanks again for your support.

Regards

Sajarac

 

[Minty]

Okay - You need to look at normalising your data, whilst you may have 20 max buildings at the moment, as soon as you had one site with 21 you would need to redesign everything again.

I think from what you have told us you probably need a basic set of tables like;

Customers
AssementTasks
Buildings
Assesments

The Assements table would store your actual results with the customer ID, BuildingID and as many AssementTasks as you need, for as many buildings as required.

Sit down with a pen and paper and list the top level items you have , then fill out the detail against those items.

If you have anything that looks like Room1, Room2, Room3 then you need to break it down further.

This is an excellent link for help http://www.access-programmers.co.uk/forums/showthread.php?p=671226

 

[sajarac]

thank you very much again, I will start working on it, at some point would you be able to help me via teamviewer or so?

I am willing to pay for your advise.

Let me know

Regards

Sajarac

 

[Minty]

Thank you - but I'm afraid I have a full time job, that excludes me from that.
Work through the examples and go slowly. When you get stuck ask back here with the work you have done and I'm sure you will get assistance.

 

[sajarac]

Thank you, just saw the videos and donwloaded the sample also, is pretty close, but when I need to create a new record the subform start a blank subform and I want all of the items listed

see the screenshot enclosed:

http://i.imgur.com/LFptfWn.jpg