Adding a button to generate a Order

[ximistar]

Hi guys,

Hope you are all good. ]

I have a form showing the Toner stock list in my School.

I am planning on adding a button to my Form called "Generate Order". The logic behind this button is to grab all the printer toner names that are showing quantity at 0 or 1. into an Excel spreadsheet or even just another form that gets created.

I also want to add a equation where if the quantity is 0 then in the generated order showing the toners I want that parituclar toner that was showing 0 to show 2 as the quantity and if the quantity was 1 then I want the quantity to show 2.


I hope this makes sense, I just want to know if this is possible and if so how would I start?

Kind Regards,

Steven.

 

[CJ_London]

just want to know if this is possible

yes it is

how would I start?

create a query that filters on quantity <=1 and use this as a basis of a form that will be a subform to your order form

Your order form would be based on your suppliers for toners for things like supplier name, address, account number and use the subform as above for the toners and quantities

also want to add a equation where if the quantity is 0 then in the generated order showing the toners I want that parituclar toner that was showing 0 to show 2 as the quantity and if the quantity was 1 then I want the quantity to show 2.

this says the order quantity is always 2 so could be hardcoded

 

[arnelgp]

you can use query as a source for your export to excel or to a report:

SELECT TonerName, 2 As TonerOrder Where TonerQuantity < 2;

 

[ximistar]

Thanks for your reply guys, I have used the query and works a treat!

Thank you