forms tutorial access
How do I make an invoice in MS Access?
So I have a project due tomorrow. We need to create a comprehensive database for a fake company. I do not ask you to do it for me or anything, keep in mind all I request is authorized by my teacher and the classification board. I just need your help. What I: Tables inhabited (invoice, sales, personnel, inventory) What I need: Forms! I have no idea how to do forms, I need a form that displays an invoice. A drop-down box to select and display the invoice Items sold in this operation, the staff member who sold and the total price. I know he needs a form and a subform. Litereally but I have no idea how. Can anyone tell me, help me or link me to a tutorial that explains this simply? Thank you. I know he is late lol, I had other homework to do and I put it to last. I use the wizard, but when it's the shape that I still much to do much editing to make it how it is supposed to be. I do not know how to change the form correctly.
You create a table containing all the elements to be included in your list. Then you add a list box to your form, and in Row Source property of the combo box, type the following command: SELECT DISTINCTROW [tblname]. [FieldName] FROM [tblname] if you use your SELECT DISTINCT [table name]. [Staff] from [table name] If you want more than one field to appear, then separate them with commas. You can also view ohttp: / / Office.microsoft.com/en-us/access/HP052405811033.asp Hope this helps.
|
|
Brilliant Microsoft Access 2007 Forms, Reports and Queries
... |
