Search results

I wanna know if its possible to make my field that says Low Stock Medium Stock Normal Stock represent 3 different images when in form view, the idea is to use a traffic light like this one Red for low Yellow/orange for medium Green for normal So if i was to use a combo box to search...

here is an example of the form, without any buttons u can see what im trying to achive

I cant seem to work out how to make a Product quantity change based on a sale i put though These are my current relationships from there you can see all my columns in each table, what my intial thoughts were with some advice from June was to have a Quantity in my Order Table a Quantity in my...

hello there nice to meet you, im in same boat as you :)

hello there

Is there anyway i can upload it so u can take a look at my project its pretty small and could use some advice, currently got all the changes in Update queries not sure if i can make em automatic or not

So this would do the whole stock as one? im trying to get it so that i can do it individually just cant work out how id be able to keep that field updated based on how much i sell of each product i dont want an overall product count i want an indvidual one so when 1 product goes below 5...

I have a sales Table where it consists of Product_ID Barcode Name Model Quantity(Think this is what your reffering to) Price in here basically id be able to find the total of the products and print an Invoice for the customer

Alot Clearer Only problem i have it is im trying to make it automatically update, so when it falls below say for example 10 it goes into Low on Stock then when its below 5 its Urgent, if this happens i want it to inform the user or print a recipet to reorder stock or something like that to...

Problem with my method is how would i control the quantity im selling, since i cant have a Quantity out due to not knowing how much of that stock ive already sold and i would need to keep adding it every sale i have E.g Sell 2 today then the next day if i sold 5 i would need to change the...

Im a bit confused how ive configured it atm is Have a Quantity Table and put an IIF statment on a query which i will add to my form for an update to put IF Quantity Field is below or equal to 5 then fill the Table with "LOW" else "Normal"

if anyone could help me id be greatful Basically im creating a system for a small store, and im stuck i cant remember how to make the Stock Quantity from one table go down if i put a sale though in another table For example i sell A computer which has a total of 20 Availiable how do i make...

Just come on here to learn more about access and hopefully make new friends and/or maybe work partners :) So hello to everyone and its nice to meet you all