Results 1 to 12 of 12
  1. #1
    Vegaanders is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2016
    Location
    Cyprus
    Posts
    29

    Print preview from tabbed navigation

    Hi all.

    I have built a small HRM Access project. One of the tasks is to print out payslips. If I open report it ask me for what month and then show me the payslips for those who have got some salary that month. It also shows the print button.

    I want to collect all the different reports in a tabbed navigation. This is no problem but when I want to open the report from inside the tab I cant get it to show up in Preview. Is this not possible or what do I do wrong



    Anders

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,917
    Is your form set to modal or pop up? That can keep it on top.

  3. #3
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,550
    the code behind the buttom must be:

    docmd.openreport "myreport", acPreview

  4. #4
    Vegaanders is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2016
    Location
    Cyprus
    Posts
    29
    Can I change the code behind a navigationbutton. When I try it say read-only

  5. #5
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,550
    is the db an .accdb?
    or
    .accde?

  6. #6
    Vegaanders is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2016
    Location
    Cyprus
    Posts
    29
    It is an accdb

  7. #7
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,917
    Are you talking about the "new" Navigation Forms?

  8. #8
    Vegaanders is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2016
    Location
    Cyprus
    Posts
    29
    I have used the tabbed navigation control.one tab opens a report(payslip). When I open the reprt standalone it opens up as a preview as I want, but when I open it by clicking the tab that is not possible and the code behind the tab I can't change, it is read-only. Hope this make sense.

    Anders

  9. #9
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,917
    I'm afraid I've not used those Navigation Forms yet and so have no experience. If you wanted to post your db so we could play with it then I at least might have a chance. If you do post it then remove any sensitive data of course and then Compact and Repair before zipping up the db. Uploading db's is in the second page of the "advanced" posting script.

  10. #10
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,917
    This thread is now marked as Solved. Is it solved or did you just give up? If solved, do you care to share your solution with others that read these forums?

  11. #11
    Vegaanders is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2016
    Location
    Cyprus
    Posts
    29
    Hi!
    I gave up and used normal command buttons instead. Now it works as I want it too. Thanks for help

  12. #12
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,917
    Thanks for posting back with your solution.

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

Similar Threads

  1. Tabbed navigation menu - possible ??
    By Lukael in forum Access
    Replies: 5
    Last Post: 02-01-2016, 01:58 AM
  2. Replies: 4
    Last Post: 01-20-2016, 02:24 PM
  3. Replies: 5
    Last Post: 07-29-2014, 01:05 PM
  4. Replies: 6
    Last Post: 03-01-2014, 07:07 AM
  5. Print & Print Preview Differ
    By IDH in forum Reports
    Replies: 3
    Last Post: 07-25-2012, 09:50 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