My Order Entry Screen

[spudmizer]

Here are my Tables
Item Information
- Item number
- Item Description
- Location ( in stockroom )
- Price
* - Vendor Number

Vendor Information
* - Vendor Number
Vendor Name
Vendor Phone
Vendor Contact
Vendor Account Number

Here is my problem and what I am trying to achieve
On a Form you enter an Item Number, which auto populates
the next fields: Item Description, Location, Price, Vendor Number. Then on that same form has two temporary Fields "qtyorder" and "qtyonhand", you put how many you want to order and how many are left, then there are option buttons a) Add to Order
b) Clear Screen
c) Print / View Current Order

If you click "Add to Order" it places the order on a "Order Report" to be printed when the order is complete, sorted by vendor number. These are the problems I am stuck with !
1) How do have it save the order to the report
2) Make sure that NONE of the data ( except price ) is changed
optional 3) Would like it to display that last 5 order entry in a preview are below where you are entering the data.

The Report would look like this

VndrName | Vndr# | Item# | Item Desc | Order Qty | On Hand | Price | ext Price | Po# |

1) Ext price is just "=orderqty*price"
2) Po# Is just a blank Column

Hope I gave enough info !!! If not just let me know !!!

 

[tlbroadbent]

Have you actually created an Access Project or ADP file that connects to SQL Server or MSDE as the database back-end? If you are using an Access MDB and the JET engine for the database, you should post your question in another Access forum. Most of your qustions apply to Access forms so start with forum702 - Microsoft: Access Forms. If you want to get the best answer for your question read faq183-874 and thread183-468158.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[lamarw]

1.) To save the order to the report you will have to invoke the report and send the query results to it.

2.) Are you familiar with subforms? I use a subform with a table in it. I link the tables using the KEY as you have indicated above, then I filter the contents with a query that is based on the key. IF you add this to your form you should be able to see the last so-many orders placed by the key.

Lamr W

Does this help?

 

[spudmizer]

tlbroadbent,

1) Sorry don't know how to do sql YET..but I want to so
to answer your question
a) "Have you actually created an Access Project or
ADP file that connects to SQL Server or MSDE
as the database back-end" Ah..NO
b)"If you are using an Access MDB and the JET engine
for the database, you should post your question
in another Access forum" I have never heard of
either.

lamarw ,

a)"To save the order to the report you will have to
invoke the report and send the query results to
it." How ? Sould like what I want.

b)"Are you familiar with subforms? I use a subform
with a table in it. I link the tables using the
KEY as you have indicated above, then I filter
the contents with a query that is based on the
key. IF you add this to your form you should be
able to see the last so-many orders placed by
the key. " Subforms no not yet but will look into
them.. So how you you do it ?