Search results

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'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...

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...

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...

Hi, I need to save a new record from a form before it gets printed, the vba code behind the print button at the minute just opens the report and inserts the record in it. I need to put something in before that to save the record when the button is clicked. The form in question is...

I'm creating a sales system that allows customers to place orders using a customer account. when a customer completes an order the number items in the order needs to be subtracted from the stock numbers of each of those items stored in the system. This is for a school project and to meet the...

I've been trying to wrap my head around this for a while and all the solutions I've found so far only deal with one checkbox for each textbox or weren't very clear. I'm not very good with vba and my school expects us to basically become experts and create a full system and documentation in the...

To preface my question sorry if what I'm asking is really basic the only experience I have with access is how to link tables together. And as far as VBA goes my only other experience of using it was in excel using it for closing and opening forms. One last thing my teacher in school is very bad...

I've been trying to get a query to run but I keep the "type mismatch in expression" error message. It's the Invoice-Product Query in the attached file I have tried changing the field types, the primary keys and messed around with the relationships but noting seems to work (all info in the...