Search results

You appear to have a Control on the MAIN Form named "DiscountAmount" as well as a Control on the Subform named "Discount". Do you want to calculate the Discount in the Subform and then display this on the Main Form as well?

Hi Anelgp Very neat. Added to my things to keep. Many thanks

Many thanks theDbGuy. I see that you added the extra field with the Filepath. Works a treat. many thanks again

Hi Everyone I apologise as I have never worked with Logos previously. I have a table named "tblFSESub" with 2 fields. Field 1 is "FSE" and Field 2 is "Logo" In the field "Logo" I have entered the path to the Logos as shown. I am then trying to generate a Report so that when a Specific FSE is...

Hi Larry It is not Garments but Wardrobe Furniture that is being covered.

Attached screenshot is 3 Levels of Subform The 2 coloured controls above the Label for Level 2 Item Details are Form references to link Subform to Subform as suggested by Welshgasman

6 or even 10 subforms would be a lot of setting up.

Just out of interest, why are you not using Bound Main Form to Subform to display Product Detail in the Main Form with related Product Details in a Subform?

Can you map out an example in Excel or Word ?

Can you give me an example of which values the User would be able to select for the Group Combo ?

Hi Whenever you look at a Template provided by Microsoft it always contains Field names with spaces and characters like )(*&^%$£"!/?, which should not be used. Also, a lot of fields use Hard Coded values when these hard coded values should be listed in a sperate table. Best to use the Template...

Are you able to upload what you have currently created in Access?

I get the same error as Gasman

As suggested upload a copy of the Database.

You should not be using Lookup fields in Tables

If it is just the one item you are selecting then you use a simple Insert Into OnClick Event

Can you upload a screenshot of your Relationship Window?

Hi Anitaa You were asking for help on the Forum and they have resolved your Combobox problem. There are however numerous problems in every one of your tables. If you use Teams and would like to chat through these problems then send me an email and I will send you a Teams Invite for a chat. My...

Hi Is there any reason why there are no Table threads showing with a date greater than May?

I get the same as Gasman. I am using Office 365