×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

My Order Entry Screen

My Order Entry Screen

My Order Entry Screen

(OP)
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 !!!

RE: My Order Entry Screen


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

RE: My Order Entry Screen

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?

RE: My Order Entry Screen

(OP)
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 ?





Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close