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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Access reports (same report different theme)
Well that's funny. Another answer to my own question: Sub cmboCompanyName_AfterUpdate() Dim strNewRecord As String strNewRecord = "SELECT * FROM Customers " _ & " WHERE CustomerID = '" _ & Me!cmboCompanyName.Value & "'" Me.RecordSource...- Swoop7
- Post #3
- Forum: Microsoft: Access Reports
-
Access reports (same report different theme)
To answer my own question see below. Are there any better ways of doing this? Can I change the Query object a report uses dynamically/supply SQL? See http://www.databasejournal.com/features/msaccess/article.php/1556051 for the source of this code. Option Explicit Option Compare Database...- Swoop7
- Post #2
- Forum: Microsoft: Access Reports
-
Access reports (same report different theme)
Hi, I've got a number of variations on the same report. I don't want to recreate/copy the same report X times. I'd rather change the SQL via code. Is this possible? Could someone post a snippet of code to get me started. Thanks, -Swoop- Swoop7
- Thread
- Replies: 2
- Forum: Microsoft: Access Reports
