Search results

Hi I took a quick look at your Database which is in fact 1 Table which you have copied from an Excel File. Points to note are as follows:- 1. that you should not use spaces in field names 2. you should not use any of the following characters in field names !"£$%^&*()_+-=][}{#'@:;?/.>,< You...

Can you upload your database so we can see your table structures/ relationships?

The OP needs to give a more detailed description of his process. At the moment we are all just guessing what it is he needs.

Hi It would help us understand if you gave us examples of actual "Stats" rather than a list of Stat1 through to Stat30

Hi If you want to be able to choose a Supervisor , then allocate a Shift and then allocate Employees to the Shift selected, then you need tables as shown in the attached screenshots. The Data Input Form allows you to select a Supervisor, Select the Shift he is responsible for and then add...

Hi If I create a Form which allows you to select a Tag what data would you then want to be able to add? The attached screenshot allows me to select a Tag, and then add details about a specific Level Transmitter and Pressure Transducer associated with the Tag selected.

From the Relationship diagram it is difficult to determine what in fact you need to do. Do you want to be able to Select a Tag and then enter details of the Pressure Transducer as well as details of the Level Transmitter?

Are you able to upload a copy of your actual database?

Hi So all 3 rows belong to 1 peice of Machinary?

Have you an example in Excel of 1 Piece of machinery with all associated Parts?

Hi Are you able to upload a screenshot of your table relationships?

Can you upload a copy of the database with no confidential data?

This just confirms that your table structure is all wrong.

Hi Bob Well Gasman gave you the solution as to how you can achieve this. All I am trying to do is point out that the structure of the Subform is wrong.

Hi Gasman Yes "Paid" would also be included but difficult to determine as we have no idea of the actual table structure.

So the Subform for entering Invoice Number information must be based on a query based on Multiple Tables. The Subform has Multiple Redundant Controls because all you actually need to enter in the Subform is the "Date", "Invoice Number" & "Amount"

Can you upload a screenshot of your Form in Design View?

So each of the Controls are Unbound and you have specific VBA Events for specific Controls.

Why have you got the label "Enter" alongside each of your Controls?

Hi Bob Are you able yo upload a copy of your database?