[Yoshiaki]

Oh, what I meant is how do one add the forms inside the tabbed form. Copy/Cut and paste don't seems to work for me.

[OBP]

You add the Forms to the Tabs using the Toolbox add Subform/Subreport Wizard.

[Yoshiaki]

Thanks! You helped me a lot. Will try to explore around and do some research work first!

[OBP]

If you need more help just ask.

[Yoshiaki]

^ Ya... I got a couple of questions while doing the tab forms...

1. Erm, what is the one that I have circled in red on the right?


2. I finally able to add the forms inside to the tabbed form (Cut and paste actually can also). However, there are some errors.


The error message.


3. How do I show forms in this manner like the one below?


4. Is it possible to create a combo box that when the user choose any of the lists there, he is able to link to another different form?

[OBP]

Well, I asked for that.
Question1. Those 2 fields are "ID" fields which the Users do not need to see (and shouldn't see).
The first is the Record Number Id and the second is the Aircraft Type that is used by the Aircraft Combo to store the Selection that you make.
Question2. I am not sure what the error is except that Your Fields do not appear to be on a "Form" that you made earlier and therefore do not have any "data source" (Control Source) that Access can recognise.
Question3. That form has it's "Default View" Property set ot Continuous Forms mode.
Question4. Yes it is, but it takes VBA code to do it.

The correct method to put a Sub form which you created earlier on a tab, (assuming that the data does not come from the same Table as the Mainform) is to use the Toolbox Subform/Subreport Wizard in design mode. See the attached Excel sheet showing a Screen print.

[Yoshiaki]

Thanks for the screenshot, I finally created a tabbed form similar to yours!

I create a form similar to what you have done for me (as I also want to learn how to create one) so that I can create another 5 more similar forms.

And then, I got some questions.

1. After I input data in the "Flight Audited" form, can it be updated immediately in the "Refuelling Operation" form? So that I can select the flight details. (By the way, all the data here are just dummy information)


2. Similar to the one you did for me, I did this "Operator" form. But there is this "Refuelling Checklist" when I open the form. For your info, the main form I named as Refuelling Checklist".


And when I want to edit the name, it prompt up some message.


3. Another problem is that, when I input finished the data and trying to input another new data, it also prompt up a window. And it don't allow me to carry on (I can't save nor continue and need to close the form).

Is it that the relationships I did not link properly?

4. I will be creating 5 more similar forms later on. These 5 forms are another different audit but are somewhat similar (The difference will be the operator, i.e. Marshaller, Driver, etc instead of just Refuelling Operator and different sets of questions).

Is it appropriate (or one of the best ways) to create a total of 6 main forms with their own tabbed forms within?

[OBP]

Question1, you will probably need to "requery" the Refuelling Tab, but it depends on how you have set it up.
Question2. That suggests that the data is no longer coming from the right place. You need to check the Record Source and Field List of your Refuelling Operator Form.
Question3, you are partially correct, it means that you have tried to enter something that does not have the FlightID from the Flight Audited Table.
Question4. If you are using the same Inspectors & Flight/Aircraft details I would look at adding them all to this Tabbed Mainform.

[Yoshiaki]

After few days of trying, I finally create a form something like yours. And I also added an "Organisation" table as what you previously mentioned. The one you did for me, really helped me out a lot. But I do not understand the purpose of the combo box in the "Inspector" form. Is it just a reference for the user? I can choose the name I want, but it will not be recorded into the database, unless I typed it in the "Name".

Other than that, I got some questions that are likely to happen in future.

1. For those questions that I got, it may be changed/modified in few years time. Hence, the solution is to create a new table or to add in new fields, is it? After that, then re-create a new form for it. Am i right?

2. I am creating this database for my supervisor. After I created so many tables and forms, I find it that it is not that user-friendly. As in, the relationships will seems quite complicated, and my supervisor might has a hard time to edit anything/create reports if he wants to. Is this situation normal?

And thanks for your help!

[OBP]

Did you make the Name field the Control Source for your Inspector Combo box and yes it is there to facilitate the Inspector's name rather than typing it to speed things up and possible typing errors.
Question 1, normally you can just add in new fields. However if you want to make the database more flexible you create a Questions Table so that the Users can enter nay new Questions or edit them if required. You would then have another rable for the Answers to the Questions if required.
Question2, yes it is complicated and normal, which is why the Programmer (you) has to make it as Complete and as Flexible as possible. You need to ask all the possible users what they think they might want or need in the futureand incorporate it it now. (It is called System Analysis and Design)

[Yoshiaki]

^ Ok, thanks!

I still got some questions...

1. In my Flight_Audited table, I got this 4 fields, STD, ATD, ETA and ATA. Each time the user wants to input data, he can only input either STD and ATD or ETA and ATA (i.e. he cannot input data to all 4). Hence, can I set a validation rule?

2. An off-topic question - What is Microsoft SQL server? I see it from somewhere, is it the same as Access?

[OBP]

Question 2 first, SQL server is like a very large version of Access, and it is can be used in conjunction with Access.

Question 1, I would use some simple VBA to prevent entry in ETA and ATA if STD or ATD have an entry and likewise prevent entry in STS nad ATD if ETA or ATA have an entry.
I don't know if it possible to do the same thing just using validation rules.

[Yoshiaki]

Oh okay, thanks.

I refer back to your previous post.

Originally Posted by OBP

Question 1, normally you can just add in new fields. However if you want to make the database more flexible you create a Questions Table so that the Users can enter nay new Questions or edit them if required. You would then have another rable for the Answers to the Questions if required.

If I intend to create a Questions table, is it something like below?

1.
Question
QuestionID, AuditID, Qn1, Qn2, Qn3, Qn4

For the Data Type,
QuestionID - AutoNumber
AuditID - Number
Qn1 - Yes/No
Qn2 - Yes/No
Qn3 - Yes/No
Qn4 - Yes/No

Or, it should be:

2.
Question
QuestionID, AuditID, Questions, Checked

For the Data Type,
QuestionID - AutoNumber
AuditID - Number
Questions - Text
Checked - Yes/No

Am I correct?

[OBP]

You really are learning well, it is the second option as it allows the users to enter the text for the question. Assuming that you have different questions for different Audits, if not then you don't need the AuditID or the Checked - Yes/No
What you have actually shown in your second option is the other table that you need to store the results of the actual audit itself.
So you need one table for displaying the question on a small subform in a combo and the subform itself is based on the second table (your second option) to store the results of the Audit.
You might need a bit of help implimenting it though.

[Yoshiaki]

It sounds hard for me... O.O" But I think I will not do this first as my supervisor seems to hurry me for the database...

By the way, I've started inputting data into the database, and I discovered some un-convenient things...

As you know, I got this Flight_Details, Operator and the Audit_form. Hence, each time, I will need to type data in both Flight_Details and Operator first then I choose the options (The Flight_details and Operator combo box) in the Audit_form.

Each time when the user wants to input new data, he will always need to key into the Flight_Details first, then Operator and lastly to the Audit_form. At the Audit_form, he will need to choose from the Flight_details and Operator combo box and select the ones he want.

It seems that the user will always be doing double steps, is this normal in database? Or can we actually create the Audit_form in such a way that it consists of the Flight_Details and Operator. Hence, instead of going to both the Flight_Details and Operator tabbed form, he can just straight away typed from the Audit_form.

Is it possible to do so? Or it is normal for every database...?