Results 1 to 8 of 8
  1. #1
    Accessgrasshopper is offline Novice
    Windows Vista Access 2010 32bit
    Join Date
    Feb 2011
    Posts
    9

    ShipToCode is driving me crazy


    Hello, just joined the forum. I am developing a form where I will enter a sales quote for a customer. I would like to include a ship to code from my shipto table. This shipto code is related to my contact table via the CompanID. The problem that I am having is that when I enter the ship to code using the shipto table as a lookup table, it is giving me the ship to codes for all customers not just the one that I am creating the sales quote for. I don't know how to isolate the shipto code options for this one customer.

    Please help! Thank you.

  2. #2
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    It sounds like you are trying to use combo boxes. Suggest you look at this web site and view the three tutorials on combo boxes .

    http://www.datapigtechnologies.com/AccessMain.htm

    Alan

  3. #3
    Accessgrasshopper is offline Novice
    Windows Vista Access 2010 32bit
    Join Date
    Feb 2011
    Posts
    9
    Thank you Alan. I got it to work thanks to you. You are awesome!!!!
    I have one more issue I need your help with. I am also creating purchase orders, sales orders, etc, where I need to list item numbers for each item sold. Access only allows one auto number per table. How do I get around this? Thank you.

  4. #4
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    I am not understanding your request. Please explain what you have in your database. What you have attempted and what you are trying to do. Your request is to vague to even offer up any suggestion.

  5. #5
    Accessgrasshopper is offline Novice
    Windows Vista Access 2010 32bit
    Join Date
    Feb 2011
    Posts
    9
    Hi Alan,

    I have a table for orders. I have an auto number primary index field that represents each unique order number. I have a related items table linked to the orders table. The items table has a unique auto number field for each item added. I need to create another field titled item #, that will automatically increase by 1 as I add items to the order. I did not use the auto number primary index field of the items table to achieve this because it is not flexible. In case I have to delete an item; the auto number field will skip an item #. I hope this explains my dilemma. Thank you.

  6. #6
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    Here is one answer that I hope works for you.

    http://support.microsoft.com/kb/209567/en-us

    And another possible answer.

    http://www.vb123.com/toolshed/07_acc...ntercolumn.htm

    and last one may be just the thing

    http://www.techonthenet.com/access/m...ential_nbr.php

    If you want further options, google "MS Access Create Sequential Number"

  7. #7
    Accessgrasshopper is offline Novice
    Windows Vista Access 2010 32bit
    Join Date
    Feb 2011
    Posts
    9
    Thank you Alan,

    I will review each option carefully and I will advise. Thank you so much. You are making this whole process fun.

  8. #8
    Accessgrasshopper is offline Novice
    Windows Vista Access 2010 32bit
    Join Date
    Feb 2011
    Posts
    9
    Hi Alan, I am stuck again. I have a form that I use to enter a sales quote for a customer. The data is stored in the sales quote table. I am in the process of designing another form from a query that will pull of the of the data from a particular sales quote and turn it into a sales order. My dilemma is the following: Once the sales order is created I want to secure the data in the sales quote table for the particular transaction so that it cannot be changed. Since the quote turned into a sale I do not want the historical info to change. How do I do this?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Report issue driving me crazy
    By Grofica in forum Reports
    Replies: 11
    Last Post: 01-28-2011, 11:23 AM
  2. Creating a driving relationship on a form
    By ld8732 in forum Database Design
    Replies: 1
    Last Post: 12-31-2010, 06:20 AM
  3. Autonumber gone crazy
    By asearle in forum Access
    Replies: 1
    Last Post: 07-27-2010, 05:41 AM
  4. Pls help... driving me insane!
    By Maverick1501 in forum Reports
    Replies: 1
    Last Post: 03-31-2010, 06:26 AM
  5. HELP with crazy receipt numbering
    By jlm722 in forum Forms
    Replies: 15
    Last Post: 09-23-2009, 01:49 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums