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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to base Report Recordsource on Recordset
Junior: Thanks for your help. I can assign an SQL string easily enough, but I need to go right from a recordset to a recordsource. That is, use ADO to get the records and not attached tables etc. Hope this helps... Webber- webber
- Post #8
- Forum: Microsoft: Access Reports
-
How to base Report Recordsource on Recordset
Thanks! I did try that and it didn't seem to work. Actually, I couldn't even get it to compile (says compile error, type mismatch). Here's the code: Private Sub Report_Open(Cancel As Integer) '-- Initialize Dim rst As ADODB.Recordset Dim fOK As Boolean ' Connect to...- webber
- Post #3
- Forum: Microsoft: Access Reports
-
Compact on Close in MultiUser Environment
I have an question on Compact on Close feature in Access 2000. Basically I'm not sure this is working in my situation after reading the documentation and looking on www.google.com. As background, I have an application in Access 2000 that is used by about 20 people from 7:30 a.m. to 9:00 p.m...- webber
- Thread
- Replies: 0
- Forum: Microsoft: Access Other topics
-
How to base Report Recordsource on Recordset
I have an interesting problem that I haven't been able to find an answer to. Basically, I would like to base a report's recordsource not on a table or query buton a VBA recordset. So the data that the report is based on would come from a recordset. I have created an ADP in Access 2000 using...- webber
- Thread
- Replies: 8
- Forum: Microsoft: Access Reports
