SwanseaAccess
New member
- Local time
- Today, 14:48
- Joined
- Sep 27, 2010
- Messages
- 8
Evening all,
I'm quite new to access and have taken on the quite daunting task of implementing a system to efficiently add sales orders, manufacturing orders and schedule production for a small-ish manufacturing company.
My starting point has been playing around with setting up a table for sales orders. I think I've added all the fields I need and now I am attempting to set up a form which will essentially act as an interface for the users (who have very limited computer skills).
I basically want a form where the users can either input an existing order number, retrieve the data for that order, amend certain fields and save it as a new order or just create a new order from scratch.
I've read a few books, browsed a few websites and played around with buttons and not got very far!
Some of the books and articles I've read are either too basic or too advanced for my needs and I can't seem to find a good source of guidance. Any help or pointers would be appreciated (i.e. a good website resource or book to buy).
I think I may need to learn some VBA programming to carry out this task but I wanted some expert opinion before I dig a hole so deep I can't get out!
Thanks!
I'm quite new to access and have taken on the quite daunting task of implementing a system to efficiently add sales orders, manufacturing orders and schedule production for a small-ish manufacturing company.
My starting point has been playing around with setting up a table for sales orders. I think I've added all the fields I need and now I am attempting to set up a form which will essentially act as an interface for the users (who have very limited computer skills).
I basically want a form where the users can either input an existing order number, retrieve the data for that order, amend certain fields and save it as a new order or just create a new order from scratch.
I've read a few books, browsed a few websites and played around with buttons and not got very far!
Some of the books and articles I've read are either too basic or too advanced for my needs and I can't seem to find a good source of guidance. Any help or pointers would be appreciated (i.e. a good website resource or book to buy).
I think I may need to learn some VBA programming to carry out this task but I wanted some expert opinion before I dig a hole so deep I can't get out!
Thanks!