Recent content by ewan97

I changed it to option explicit and that did nothing, yes I've checked the values and nothing has changed. There are no errors when I run the code and sorry I don't know how to step through it and check things

Sorry nothing happened when I ran the VBA, also I'm putting all this behind a button would that have any effect? I just pasted all of that vba after Private Sub btnFinish_Click() Also where do I put SQL for a button? I've never had to do that before.

The combobox refers the the ProductName field and is called Combo0, heres a screenshot of the Products table.

I know this is a basic question, I have a form where there is just a combobox and a textbox, the user uses the combobox to select the record they want to change and then they enter a value in the textbox which needs to be added to a field in that record. this is the vba I tried to write with my...

Ok so I tried messing around with the links a bit and it turns out the only one I did need was between ProductName and ProductID. It worked and I couldn't be happier to finally get this sorted.

So is there a different way I can do this that just used the values in the records without the field names needing to be the same?

I thought that's what I had to do because I want to take the Quantity value away from StockNumber but clearly I'm wrong. How can I take the quantity value from the stocknumber value? That's my ultimate goal here.

These are screenshots of the tables and query design in question. And please before anyone says it I know you aren't meant to store a stocknumber value with a product and it should instead be caluculated but this is the way we have been told to do it for our school project and i have several...

Ok so I'm not really sure how to do what I want to do, I'm not sure what to google to find out how to do it. I want to update values in one table using values in another table. The table I want to be updated has a stock value for each product, I have a query that pulls the records from the most...

yes that worked, thanks for the clear explanation

Sorry I don't quite understand how to go about using the information you've given me, I'm pretty new to this.

ok where in the query do I put this code?

I need this query to return the most recently created records in a composite key field, and only the most recent ones. there is a screenshot of the composite key field attached I want to get the records with the highest InvoiceID, there can be multiple records with the same InvoiceID and I...

ok so how do I take the information about which products are ordered and put that in this proposed table which would store everything about ingoing and outgoing stock? Also how can I calculate a current stock number from this?

I'm making a very basic sales system for my school project and I'm currently working on the stock management part, as I said it's very basic. My task - When the user receives a stock delivery they need to update the stock numbers. the value they need to update is the StockNumber value in the...