Results 1 to 7 of 7
  1. #1
    Join Date
    Mar 2008
    Posts
    5

    Unanswered: Access Forms Assistance

    I'm designing a semi-complex access db. as a fairly new user to Access.

    It is a DB for a catering company. This DB has the following tables: Customers, Order Info (Date, time, location, etc), Ordered Goods (the items they are ordering).

    I have the table relationships set up correctly as listed above.

    The problem i'm running into is creating the forms. I need to create an order form which is designed for quickness and ease. The First area, the Customers I need a drop down menu, upon selecting the customer it will show their information such as the phone number, cc #, email. under that will need to be the order info which will be an input area for the information mentioned above. Under that is a multiple list item which can record multiple items at a time. There will be a Add new order(opening a blank screen), or save and exit which will return the user back to the switchboard.

    Now my question is ... how do I create the drop down menu? and all the input fields to work 100%? I was told I needed to do some VBA which I have no Idea how to do.

    I seem to run into problems creating the Form with all the information needed and store it properly. If you have any suggestions comments responses, etc..

    I thank you in advance.

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    I want to see your table relationships view tbh. You are more than vague when it comes to the relationships.

    The "drop down menu" is called a combo box. If your underlying query is correct, creating the combo box should be very easy with the wizard.

    You won't need VBA if your relationship structure is correct and you design your forms correctly.

    You could also check out the Northwind Database as I believe that is one good example of how to design order based forms... at least it was when I first looked at it in Access 2.0
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Mar 2008
    Posts
    5
    Well i'm not too sure what the easiest way is to post the information your looking for, so i'll post my database.

    it just has a generalized item list, customers (named reps), and order info, ordered goods
    Attached Thumbnails Attached Thumbnails untitled.JPG  
    Attached Files Attached Files
    Last edited by summerpewp; 03-30-08 at 17:20.

  4. #4
    Join Date
    Mar 2008
    Posts
    5
    just uploaded my relationships to better explain what i'm trying to do.

    I have read through 3 books, and unless i'm just not looking in the right place, i can't seem to figure this out.

    I have a form that currently has input fields, but i need 1 drop down field that when selected shows the information of that selection (just their contact info, cc# etc..)

    Then they proceed to doing the order by entering the information. They click save + new for entering another order, or save + exit and return to the switchboard.

    How can this be accomplished....

  5. #5
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Ok, so the form needs to have an underlying query that includes all the fields from your OrderInfo table + all the non-keys from Reps. Then you create your combo box for RepID. When you use it, all the fields from the Rep table will populate themselves.

    It also wouldn't hurt to enforce your referential integrity.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  6. #6
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Quote Originally Posted by StarTrekker
    It also wouldn't hurt to enforce your referential integrity.
    Quote of the week
    George
    Home | Blog

  7. #7
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Yes... enforced relationships sure solve more problems than they create
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •