Don't see reports in database. Is it possible they are set under hidden mode?

**bluemoon9** · Jul 27 '10, 03:17 PM

Originally posted by bluemoon9

on the form, there is a command Print with 3 options, when I click on each option, it print the form assinged to the option; however, when I go to the back end of the database and view "report" tab, I do not see these reports, is it possible that these reports have been set under hiden mode? is there a way to see these report list in the report tab?
thanks!

Code:

Private Sub cmdPrint_Click()
    
    If fraFormType.Value = 1 Then
        DoCmd.OpenReport "~Blank CC/MS Form", acViewNormal
        DoCmd.OpenReport "~Blank CC/MS Form Page 3", acViewNormal
        MsgBox "The Critical Care/Med Surg Form has been sent to your printer.", vbInformation, "Form printing"
    ElseIf fraFormType.Value = 2 Then
        DoCmd.OpenReport "~Blank Psych Form", acViewNormal
        DoCmd.OpenReport "~Blank Psych Form Page 3", acViewNormal
        MsgBox "The Psychiatry Form has been sent to your printer.", vbInformation, "Form printing"
    ElseIf fraFormType.Value = 3 Then
        'MsgBox "The Peds Data Collection Form is under revision.", vbOKOnly
        DoCmd.OpenReport "~Blank Peds Form", acViewNormal
        DoCmd.OpenReport "~Blank Peds Form Page 3", acViewNormal
        MsgBox "The Peds Form has been sent to your printer.", vbInformation, "Form printing"
    End If
    
    DoCmd.Close acForm, "fdlgBlankForms", acSaveNo
    
    
End Sub

I've found the way to view hiden reports.

thanks!

bluemoon

Don't see reports in database. Is it possible they are set under hidden mode?

Don't see reports in database. Is it possible they are set under hidden mode?

Comment