Results 1 to 8 of 8
  1. #1
    CAMc is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jun 2019
    Posts
    7

    Report, filter by job number, then by status


    Hi,

    What is the simplest way of populating a label on a report? I want each page of the report to be a different job no?

    cheers for any help.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    What exactly do you mean by 'populating a label on a report'? Do you have a table with field for job no?

    Provide sample data. If you want to provide db for analysis, follow instructions at bottom of my post.
    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.

  3. #3
    CAMc is offline Novice
    Windows 10 Access 2016
    Join Date
    Jun 2019
    Posts
    7
    Hi thanks for reply and I haven’t created the database yet and I’m not to experienced with access but searching around I think the term i am looking for is a dynamic report title so I should be able to sort that.

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Presuming the job number is in the data, just use a textbox instead of a label and put the job number field in the control source.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    CAMc is offline Novice
    Windows 10 Access 2016
    Join Date
    Jun 2019
    Posts
    7
    That’s great will give it a try, cheers

  6. #6
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    No problem, post back if you get stuck.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  7. #7
    CAMc is offline Novice
    Windows 10 Access 2016
    Join Date
    Jun 2019
    Posts
    7
    Hi I tried that today but just kept giving me a number. I have the job no in a separate table from the one I generated the form. I am sure it was the ID it was giving me as it changed from 1 to 2 to 3 as I went thru the first three jobs.

    i got over it by adding code to the ID text box so each time it gets focus it grabs the value of the job no, job name and item reference and puts it in the text box in the form. Probably long winded way of doing it but more familiar with vba than access.

  8. #8
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Original question was about a report. Why do you reference a form in your solution?

    Why don't you build query that joins tables for report? Then related data is available. This is what I think Paul meant.
    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.

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

Similar Threads

  1. Replies: 1
    Last Post: 09-03-2019, 08:28 AM
  2. Replies: 1
    Last Post: 08-29-2013, 09:22 PM
  3. Replies: 8
    Last Post: 08-14-2013, 12:45 AM
  4. Replies: 19
    Last Post: 04-23-2013, 05:45 PM
  5. Form to Filter Report by Week Number
    By jortizz in forum Forms
    Replies: 1
    Last Post: 05-18-2011, 09:30 AM

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