By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,516 Members | 1,135 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,516 IT Pros & Developers. It's quick & easy.

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

P: 56
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?

Expand|Select|Wrap|Line Numbers
  1. Private Sub cmdPrint_Click()
  3.     If fraFormType.Value = 1 Then
  4.         DoCmd.OpenReport "~Blank CC/MS Form", acViewNormal
  5.         DoCmd.OpenReport "~Blank CC/MS Form Page 3", acViewNormal
  6.         MsgBox "The Critical Care/Med Surg Form has been sent to your printer.", vbInformation, "Form printing"
  7.     ElseIf fraFormType.Value = 2 Then
  8.         DoCmd.OpenReport "~Blank Psych Form", acViewNormal
  9.         DoCmd.OpenReport "~Blank Psych Form Page 3", acViewNormal
  10.         MsgBox "The Psychiatry Form has been sent to your printer.", vbInformation, "Form printing"
  11.     ElseIf fraFormType.Value = 3 Then
  12.         'MsgBox "The Peds Data Collection Form is under revision.", vbOKOnly
  13.         DoCmd.OpenReport "~Blank Peds Form", acViewNormal
  14.         DoCmd.OpenReport "~Blank Peds Form Page 3", acViewNormal
  15.         MsgBox "The Peds Form has been sent to your printer.", vbInformation, "Form printing"
  16.     End If
  18.     DoCmd.Close acForm, "fdlgBlankForms", acSaveNo
  21. End Sub
Jul 27 '10 #1
Share this Question
Share on Google+
1 Reply

P: 56
I've found the way to view hiden reports.


Jul 27 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.