Page 2 of 2 FirstFirst 12
Results 16 to 27 of 27
  1. #16
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    1,120
    Have a look at the attached, I think it should do what you're after (I added some emailing options in case you want to do that instead of printing them).



    Cheers,
    Attached Files Attached Files
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  2. #17
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    8,676
    @Vlad
    Tried to download the dB in Post #16 but get an "Invalid Attachment" error.
    HTH
    -----
    Steve
    --------------------------------
    "Veni, Vidi, Velcro"
    (I came; I saw; I stuck around.)

  3. #18
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    1,120
    @Steve
    Thanks for the heads up, can you please try this one.

    Cheers,
    Attached Files Attached Files
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  4. #19
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    8,676
    @Vlad
    Downloaded, extracted and opened
    HTH
    -----
    Steve
    --------------------------------
    "Veni, Vidi, Velcro"
    (I came; I saw; I stuck around.)

  5. #20
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    1,120
    @jlorence: Would you please let me know if the new file does what you want. If it does you should mark the post as Solved.

    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  6. #21
    jlorence is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2020
    Posts
    11

    Database and Report

    Quote Originally Posted by Gicu View Post
    @jlorence: Would you please let me know if the new file does what you want. If it does you should mark the post as Solved.

    Cheers,

    Hi, yes it does thank you!!!

    I am just trying to recreate a report from the original database, and battling through that. Ultimately we need two reports, something like the original (that came from a previous database), and the one you created. So now that its a new database referencing a new table, I need to get a similar report to reference that same new table. Is there a way to just copy over a report from one database to another and just update the table references and the fields to the new table? I wasn't immediately able to figure that out, so I am trying to build the report from scratch, which I am sure I will struggle with too.

  7. #22
    jlorence is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2020
    Posts
    11
    I think I have it all working, I just cannot figure out how to filter the date range everytime I run the new report? The old report used to prompt me for start and end date when opening the report, and I cannot figure out how to duplicate that prompt/filter? And I think that is the last step.

  8. #23
    jlorence is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2020
    Posts
    11

    Database Reports need filters

    Hi,

    Here is the updated database, with two new reports, "Weekly Stagehand Schedule" and "Updated IDs"

    If possible, I would need the Weekly stagehand schedule report to prompt me to enter a date range when I click on it (ex. 'start date' "1/1/20" and 'end date' "1/8/20") then filter just the records in that range.

    Then the Updated IDs report to prompt me for record ID range when I click on it (ex. 'start ID' "5" to 'end ID' "7") to filter just those records nothing before or after.

    I cannot seem to figure that step out either.Almost done schedule 1.24.20.zip

  9. #24
    jlorence is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2020
    Posts
    11
    Quote Originally Posted by jlorence View Post
    Hi,

    Here is the updated database, with two new reports, "Weekly Stagehand Schedule" and "Updated IDs"

    If possible, I would need the Weekly stagehand schedule report to prompt me to enter a date range when I click on it (ex. 'start date' "1/1/20" and 'end date' "1/8/20") then filter just the records in that range.

    Then the Updated IDs report to prompt me for record ID range when I click on it (ex. 'start ID' "5" to 'end ID' "7") to filter just those records nothing before or after.

    I cannot seem to figure that step out either.Almost done schedule 1.24.20.zip



    Also I just noticed on your date range report that when the record takes up more than one page, it doesn't continue on the 2nd page to finish that record. Does that need a page break of some sort?

  10. #25
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    1,120
    Here you are, let me know if it works for you!
    Cheers,
    Attached Files Attached Files
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  11. #26
    jlorence is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2020
    Posts
    11

    Completed database

    Quote Originally Posted by Gicu View Post
    Here you are, let me know if it works for you!
    Cheers,

    It seems to be doing everything we need! Thank you so much for your help with building that, it is greatly appreciated.

  12. #27
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    1,120
    You're welcome,good luck with your project!

    Vlad
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

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

Similar Threads

  1. Create New Rows based on number entered
    By AMJADJ in forum Programming
    Replies: 7
    Last Post: 09-25-2018, 07:43 PM
  2. Replies: 4
    Last Post: 11-07-2014, 04:25 PM
  3. Replies: 3
    Last Post: 07-12-2011, 02:02 PM
  4. Insert x number of rows based on value
    By opopanax666 in forum Programming
    Replies: 4
    Last Post: 10-26-2010, 03:26 AM
  5. Hiding rows when blank in a report.
    By ser01 in forum Reports
    Replies: 0
    Last Post: 02-27-2010, 10:29 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
  •  
Tech Forums: Microsoft Office Forums