Search results

Hi Sorry but you are not following what I am recommending. You cannot add data to a Continuous Form until you add a Record in the Main Form. Pat Hardman has pointed you to a solution but you need to get this First Major Step created before you can add the Multiple Items.

Hi Your tblCheckListDetails which is the many side of the Relationships contains 58 Records with no Parent Records. This is not how you would manage your process. You should initially enter a record in tblCheckList and then add related records in tblCheckListDetails. Looking at the data in...

Is this what you are after?

Hi David If you think about your process, you are trying to record information about All Games played in a specific Season. So to get you started if you look at the relationships in the revised Relationship Diagram you will see that I have removed all of your current relationships. I then...

Hi I believe you need to have Data Input Forms so that you can relate 1 Customer to 1 or More Loan Amounts and also a related Form to allow you to enter payments made. Doing your process just by entering data in two tables creates errors. The attached screenshot is what I believe your...

Can you upload a zipped copy of the database so we can see your tables structures?

Can you post a screenshot of your Relationships Diagram?

You need a field named StartHours then in the query you would use [NewHours]-[StartHours]

This will depend on how your relationships are setup Normally as CJ suggested you would have the LinkMaster & LinkChild Fields set to the PK on the Main Form and the related Child FK on the subform

In the Linked Field in the Query put a Form Reference to the Main Form PK in the Criteria Row [Forms]![NameofMainForm]![NameofSubform].[Form]![NameOfPKControl]

Hi Can you give us an example of what you are expecting to see

Here are your Forms reworked

Hi I have given you the Relationship Diagram so you can now create the tables based on this Diagram. Once you have the tables created you then need to create Forms based on the Diagram.

Hi You need to create tables as shown in the Relationship Diagram attached. This would then allow you to create a Main Form as shown in the attached screenshot based on tblCustomers, with a Subform based on tblCustomersAccounts. then another subform based on tblAccounts

Hardip You currently have an AfterUpdate Event on the Product Combobox which says:- [GGRC Price] = ProgramName.Column(2) Note the combobox would normally by named cboProduct and not ProductName. To get the Unit you just need to add "Unit" to the Combobox Row Source and then add the following...

Hi If you are going to upload your database then you need to include all of the Forms that relate to your tables.

It would be easier if you can upload a copy of the database with a few random records.

Hi John Your Form should be linked as shown in the attached.

Are the Competencies supposed to be related to the Versatility Subject? I should have asked "Does each Versatility Subject have 1 or More Competencies?"

You should not be embarrassed because at least you have made an attempt at creating the database as well as you knew how. We are only interested in seeing the whole picture and hopefully help you if necessary, to change for the better.