Results 1 to 7 of 7
  1. #1
    3 Star Lounger
    Join Date
    Feb 2004
    Location
    Kitchener, Ontario, Canada
    Posts
    228
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Updating Query (XP)

    I might be going about this totally the wrong way. What I am trying to do is
    FORM - NCR main entry screen This is the main styarting point.
    Tabs: NCR header - is where the starting info is placed when new file opened.
    Desc and Inst - is where the different types of problems go. Different files can have many different types of problems
    Sort information - This is where I am having a problem. I have already made a small subform to get the tag numbers from the 1st tab: (on a side note this might be wrong since I can open this and then make changfes to the tag numbers but this does not update.... I think I need to the something like Me.dirty but I can not remember right off.)

    What I am trying to do is have a table where the tag number is taken from the subform on the sorting page and the desc column is limited to only the desc found on the 2nd tab so in the end I have the following in the Sorting Info table

    Example of data wanted in table
    NCR Tag Description Rejects found
    2421 1 Parts not Flat 12
    2421 1 Nicks and dings 4
    2421 2 Parts not Flat 14
    2422 1 Part Too think 125
    2421 2 Nicks and dings 7
    2421 2 Burr on ID 11

    NCR should come from the opened file
    Tag should come from the subform on the tab
    Desc shoud be limited to the list in the 2nd tab : I made this a query. but when I try to make the table the inof is not shown.

    I have attached the file so this will make more sence,
    Attached Files Attached Files

  2. Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

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

    Re: Updating Query (XP)

    I'd start by analyzing carefully how the subforms should be related to their parent form, and setting the Link Master Fields and Link Child Fields properties. Several of them don't have these properties filled in.

  4. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 16 Times in 16 Posts

    Re: Updating Query (XP)

    You should also create relationships between the tables. In most cases the links between subforms and their parent forms will follow automatically from the relationships.

  5. #4
    3 Star Lounger
    Join Date
    Feb 2004
    Location
    Kitchener, Ontario, Canada
    Posts
    228
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Updating Query (XP)

    I am totally drawing a blank here... I know I am missing something very simple.
    You can slap me later.... The reason it was not working for me was that in the table I had an item set as a memo and was trying to make it a lookup... as soon as I set it back to text it worked...

  6. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 16 Times in 16 Posts

    Re: Updating Query (XP)

    I'm looking at your database, but it's going to take some time to cut through the clutter.

  7. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 16 Times in 16 Posts

    Re: Updating Query (XP)

    Since you've already solved the problem, I won't go into that. But you should clean up your database, there's a lot of unnecessary clutter, for example subforms that serve no purpose, duplicate indexes etc. And check your spelling.

    A slightly straightened out version is attached.
    Attached Files Attached Files

  8. #7
    3 Star Lounger
    Join Date
    Feb 2004
    Location
    Kitchener, Ontario, Canada
    Posts
    228
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Updating Query (XP)

    Thanks a lot... a lot of that was cause by me trying to strip out info so I could make tyhe file smaller... You are always a great help... I dont know what I would do without you sometimes. and my spelling is very bad... That will get fixed on the last pass...

Posting Permissions

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