Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2014
    Posts
    22
    Provided Answers: 1

    Unanswered: Help with Report viewing and printing

    I have a small db. I have set it up to be very user friendly (I hope). When a user clicks on the icon to open the db, the app window auto hides and the user sees just the start form. On all other subsequent forms, the app window stays hidden. The user can go from form to form and back and still not "see" the app window. HOWEVER, when the user clicks the button to print the form (I have code for it to open in Print Preview in order for them to choose their own print settings), the report is not showing in front of the form. The user has to click on the Access Prgm icon and the report shows then. i would like the report to come to the front (in front of the form). Not smart enough to figure this out. Please help.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    is there a setfocus event for reports, callable from another object?
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Nov 2014
    Posts
    22
    Provided Answers: 1
    This is the code I am using for the report.

    Option Compare Database
    Option Explicit

    'Private Sub Report_Load()
    '
    ''Removing all access information code
    ''Global Const SW_HIDE = 0
    ''Global Const SW_SHOWNORMAL = 1
    ''Global Const SW_SHOWMINIMIZED = 2
    ''Global Const SW_SHOWMAXIMIZED = 3
    ''User one of the following below:
    ''Call Module2.fSetAccessWindow(0)
    ''Call Module2.fSetAccessWindow(1)
    'Call Module2.fSetAccessWindow(2)
    ''Call Module2.fSetAccessWindow(3)
    'End Sub

    'Private Sub Report_Open(Cancel As Integer)
    ' ' Forms![Issue_Details].Visible = False
    ' 'DoCmd.SelectObject acTable, , True
    ' ' DoCmd.RunCommand acCmdWindowHide
    ' Reports![rptIssues].Visible = True
    'End Sub

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    seeing as its all commented out, then that doesn't look like its doing anything......
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Nov 2014
    Posts
    22
    Provided Answers: 1
    It's commented out because I was testing behavior.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •