Search results

What should be the help?

He is the Italian correspondent of Forms.

In the attachment you can see the example. The form that manages the student's data is poorly made.

To give a precise answer you would need to see the structure of the database. However, generally all you need to do is insert a button and use its click event to write the following code: Private sub cmdOpenFile_Click() On Error GoTo Error_cmdOpenFile Application.FollowHyperlink "full...

If you have already created something in an access file it would be better to attach it so you can view the structure.

The result of an experiment is in the tblExperiments table (ResultConclusion field) and not, as you reported, in the tblExperimentIngredients table. If the quantity of an Ingredient changes, it is a new experiment.

Perhaps the most correct structure is the following.

The thing can be done, obviously you are doing something wrong.

What you should see is the data in the mode exposed in post #11 but concerning a single Order with all the other data linked to it in order to see a real situation from start to finish and therefore be able to understand better.

To actually understand how to handle it you should show the one seen in post #11 for a single order so you can see the progress of the process starting from the order to the sale. This is because it seems that there are some inconsistencies to see in the Material Information table->Material...

You had the example in post #7.

Try this update.

Here you can see the example to show all records just clear the value in the related filter control.

In the attached file you can see an example with your normalized data and search form.

To attach a file you must use the "Attach Files".

To help concretely, it would be necessary to have a detailed description, from start to finish, of how the activity you would like to reproduce in the database takes place.

First you should tell what the List, Amount, Currency, Accounts2 columns are for.

Maybe you should attach an example file because then you can't figure out what you did.

You need to create two queries: qryMaxRev with the following predicate:SELECT tblDrwgRegisterDtls.DwgID, Max(tblDrwgRegisterDtls.DateIssued) AS MaxDiDateIssuedFROM tblDrwgRegisterDtls GROUP BY tblDrwgRegisterDtls.DwgID; qryMaxRevData with the following predicate:SELECT tblDrwgRegister.DwgID...

Maybe it's better.