Results 1 to 12 of 12
  1. #1
    Business is offline Advanced Beginner
    Windows 8 Access 2010 64bit
    Join Date
    Apr 2016
    Posts
    78

    getting a value from a table and displays it on a report

    Hi,



    I need help.
    An update on a table did that when saving the record type as been converted.
    Let me be more clear. After updating the table stock and saving the information on a invoice form in the invoice table,the product name was replaced by it s Id.or doing a query to do the report,on the report the name does not appears .it s the Id number.
    how do i go about it.

    Regards

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    After updating the table stock and saving the information on a invoice form in the invoice table
    ?????I have no idea what this means. Try to describe WHAT you are trying to accomplish in simple English.

  3. #3
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    You use a query as the report's source, joining together the transaction table (like FactureOutside) with the table containing descriptions (Stock).
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  4. #4
    Business is offline Advanced Beginner
    Windows 8 Access 2010 64bit
    Join Date
    Apr 2016
    Posts
    78
    pBalby i dont get you,your language is too strong.make it a bit easier for me.I m just a beginner

  5. #5
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Like

    SELECT FactureOutside.factOutsideId, FactureOutside.produitId, Stock.produitNom, FactureOutside.factdehoDate
    FROM Stock INNER JOIN FactureOutside ON Stock.produitId = FactureOutside.produitId;
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  6. #6
    Business is offline Advanced Beginner
    Windows 8 Access 2010 64bit
    Join Date
    Apr 2016
    Posts
    78
    mister Paul where do i use this code.After i m making a query with FactureOutside table and getting the report assistant i get an error message saying that i chose field from the same savings

  7. #7
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    That isn't code, it's SQL (a query). You can start a new query, change to SQL view and paste that in. Switch back to design view and see what it looks like.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  8. #8
    Business is offline Advanced Beginner
    Windows 8 Access 2010 64bit
    Join Date
    Apr 2016
    Posts
    78
    It does open the report but there is nothing on it.From when i run the query there is nothing on the query table

  9. #9
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Did you change the field the combo was bound to? In the sample, it's bound to the name field instead of the ID field. You need to populate the ID field like it's supposed to be.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  10. #10
    Business is offline Advanced Beginner
    Windows 8 Access 2010 64bit
    Join Date
    Apr 2016
    Posts
    78
    I did it mister Paul and it came with other errors.it does not populate the other textboxes. I wish i could understand vba as you but please i m stuck for days give me some proper explanation for me to go forward and finally finish

    Regards

  11. #11
    Business is offline Advanced Beginner
    Windows 8 Access 2010 64bit
    Join Date
    Apr 2016
    Posts
    78
    pBaldy mr ¨Paul you deserve to be called master.I sat down on it this morning and what you have told me is working. Wonderfull. I ll keep posting if i get other problem.

    Thanks again you can t beleive how it s feel good to see it working

  12. #12
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Glad you got it working.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Report displays data multiple times
    By kermit in forum Reports
    Replies: 2
    Last Post: 05-11-2015, 03:50 PM
  2. Replies: 3
    Last Post: 04-14-2013, 06:22 PM
  3. Replies: 3
    Last Post: 05-05-2012, 12:25 PM
  4. Replies: 2
    Last Post: 12-08-2010, 01:32 PM
  5. Report displays no records
    By windwardmi in forum Reports
    Replies: 5
    Last Post: 10-05-2010, 12:10 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