Page 2 of 2 FirstFirst 12
Results 16 to 20 of 20
  1. #16
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,646
    Db has forms with names:
    frmInputPlants
    tblInputProducts
    tblProductConstituentDetail Subform



    Only the first one works.

    My initial inclination would be to have a structure that relates Constituents to Product and Products to Plant. But you have a requirement to differentiate Constituent requirements by the source Plant. Gets complicated. Looks like you have a handle on that.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  2. #17
    illicited is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2013
    Posts
    28
    Your looking at the latest attachment I posted right? From this morning?

  3. #18
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,646
    Yes, downloaded an hour ago.

    "The record source 'qryPlantProductsDetail' specified on this form or report does not exist."

    And taking another look at the query list I do see that query.

    Could be the issue is I am running the db under 2007. The db does give me incompatibility warning when I open it. Will have to try again later under 2010.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  4. #19
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,646
    Just downloaded the db. Running under 2010. Still get the 'record source does not exist' error. I try to open the qryPlantProjductsDetail in datasheet and get error "The Microsoft Access database engine cannot find the input table or query 'tblPlantProductDetails'." There is no table called tblPlantProductDetails.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #20
    illicited is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2013
    Posts
    28
    Ok sorry about wasting your time, I'll take a look at that.

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 7
    Last Post: 01-26-2017, 12:49 AM
  2. Replies: 10
    Last Post: 10-06-2012, 12:28 PM
  3. Replies: 1
    Last Post: 06-17-2012, 12:38 AM
  4. Replies: 3
    Last Post: 01-24-2012, 02:44 AM
  5. Replies: 0
    Last Post: 01-26-2011, 05:51 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