Search results

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.

Hi I note in Post #23 that "you have the original DB I made several years ago". Are you able to upload a copy of this db with a few random records? As for the Report, I would think the easiest option would be to have 2 queries and 2 Reports.

Hi Because we do not have a full picture of what your business process is, we are making suggestions on what we see in your current table example. To understand your business process we need a step by step explanation of what you do from when you sign on to your shift. You mention "the Daily...

Hi June asked has the Report got to look like your original? See the amended Report in the attached. I think this layout reflects your table structure.

Here with the example for you.