Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Error: Cannot open any more databases
Hey AceMam, Thanks for your reply. No, my subForms & subReports are ony 1 deep. Input from other sources suggest I must be running out of table ID's, though since Jet 4.x supports 2048 ID's I can't see how. I should have 32 tables open, and they are all linked tables so I'm told in that case...- bbbum
- Post #4
- Forum: Microsoft: Access Forms
-
Error: Cannot open any more databases
Hi all, I have a report, which by necessity contains 12 sub reports. I print it with a "Print" cmd button on the form which is the form with the data I want to print, which also contains 12 sub forms. The "Print" cmd button opens the report showing the desired record(s) by using the...- bbbum
- Thread
- Replies: 3
- Forum: Microsoft: Access Forms
-
Report Condition (Where)
Take a look at using the WhereCondition parameter in the line of code that opens your report. If you make your QRY-ProjectHrsSearch the data source for your report, and then set the WhereCondition equal to your Project# it should give you the results you want. Code Example: DoCmd.OpenReport...- bbbum
- Post #3
- Forum: Microsoft: Access Forms
