Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Oct 2005
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    misssing names (Access 2000)

    In my database for issuing orders i have problems when i
    want to to open an old order in order to edit it.
    My main form is called FOrderInformation and the subform
    FOrder details extended.
    i choose the order from a list box called ListOrders.

    Dim stDocName As String
    Dim stLinkCriteria As String
    stLinkCriteria = "orderid = " & Me![list].Visible = True



    When i open the form i can see the products in the subform,

    but some of the products are with missing product names.
    What may be the reason for that ?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: misssing names (Access 2000)

    You cannot really expect us to know that...

    Perhaps the product names are missing, or they are displayed incorrectly, or there is another reason. Without seeing the database, it is impossible to tell.

  3. #3
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: misssing names (Access 2000)

    Are the product names displayed using combo boxes? One scenario is that some products are not in the recordset behind the combob box.

    This might happen if , say, the same form is used for entering new orders. When you enter new orders only current products are offered, or perhaps only products in stock. If you use the same form to look at old orders, and items that are no longer current etc will have the name missing.
    Regards
    John



  4. #4
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: misssing names (Access 2000)

    My guess would be that you allowed products to be deleted from the product table without checking that these products had been included in orders. I'm also guessing that you did not create any relationship between the Products table and the Order-Detail table. I would have established such a relationship with Enforced Referential Integrity, and specifically turning OFF the Cascading Delete option.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  5. #5
    New Lounger
    Join Date
    Oct 2005
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: misssing names (Access 2000)

    I want to thank you all. And also to apologize that i have gien so little information. Actually i found the reson of my errors due to your guessing, and it was that i had only products on stock.

Posting Permissions

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