Recent content by alexxmf

I have simplified the database to leave only the tables and one query. It is attached to this post. I hope this can explain my thinking better.

Thanks for your quick response. I think I understand what you are saying. My issue is that each transaction can be different due to final sale prices potentially being different according to the amount of discount etc. I have shared an image of this to help understand it. I use the dates and...

Hi, I will try my best to keep this as simple as possible but I find this very hard to explain! I am trying to create a database to control stock in my wife's shoe shop. I would like to be able to calculate the current number of each of unique item in stock but I am having issues with...

Excellent, works a treat, thank you! What is the difference between the two actions 'SetProperty -> Value' and 'SetValue'? I noticed it had a warning symbol next to SetValue when I used it. sneuberg: I will look into the VBA. I didn't go down that route as I didn't want to have to learn too...

I have zipped and attached the file. The layout of the form is a work in progress, as are the records ( I am trying to address the functionality of the database before the layout). The form where the problem lies is frmSale. I would ideally like to know the solution using macros so I can...

Hi, Sorry for the confusion. I use the macro builder to create code and there is no way to select all. I have taken a screenshot of the macro builder code and attached it. I would like the text box value of the control on the subform to be updated. Regards, Alex.

Hi all, I am new to the forum and to Access. I am building a simple database to control stock and sales at my wife's new shop. I have managed to google my way through most of my issues, but I've been banging my head against the wall over this one for a day or two now. All I want to do is set...