peskywinnets
Registered User.
- Local time
- Today, 14:08
- Joined
- Feb 4, 2014
- Messages
- 582
I'm a small time trader, slowly building up an access database towards helping me be more efficient & prevent human errors.
To date, I've learnt how to 'go fetch/parse' XML (orders) using VBA within Access & to populate an Access database with the resulting data ...it was quite a steep learning curve, but I'm ready for the next stage ......which is to create a user interface within Access to use when packing items for dispatch. To set out my stall, most of my Access dabbling to date has been with table/queries....with very little experience relating to do Forms &/or Reports.
Requirements....
1. Have a main screen of orders still to be packed.
2. to be able to highlight an order & click a button called 'view order'
3. At this point the order opens up showing all the order details (customer name, address, what he bought etc.), another button will then available which says 'Process'
4. When the 'Process' button is clicked a window opens up just for the purposes of scanning the products (each product has a barcode). The idea being all items to be packed will show, once the product barcode has been scanned a tick/check box will appear adjacent to it (or the text will change colour e.g. Green). If a product is scanned that isn't in the list of products to be scanned, an onscreen warning appears.
For the purpose of my next steps, I wish to tackle the No 4 above....in principle it's very simple, but I'm having difficulty working out the best way to implement within access (as I say reports & forms are quite new to me)...any top tips?
To date, I've learnt how to 'go fetch/parse' XML (orders) using VBA within Access & to populate an Access database with the resulting data ...it was quite a steep learning curve, but I'm ready for the next stage ......which is to create a user interface within Access to use when packing items for dispatch. To set out my stall, most of my Access dabbling to date has been with table/queries....with very little experience relating to do Forms &/or Reports.
Requirements....
1. Have a main screen of orders still to be packed.
2. to be able to highlight an order & click a button called 'view order'
3. At this point the order opens up showing all the order details (customer name, address, what he bought etc.), another button will then available which says 'Process'
4. When the 'Process' button is clicked a window opens up just for the purposes of scanning the products (each product has a barcode). The idea being all items to be packed will show, once the product barcode has been scanned a tick/check box will appear adjacent to it (or the text will change colour e.g. Green). If a product is scanned that isn't in the list of products to be scanned, an onscreen warning appears.
For the purpose of my next steps, I wish to tackle the No 4 above....in principle it's very simple, but I'm having difficulty working out the best way to implement within access (as I say reports & forms are quite new to me)...any top tips?
