troubleshooting Question

Access 2007, Report Loops

Avatar of Amour22015
Amour22015 asked on
Microsoft AccessVisual Basic ClassicVB Script
4 Comments1 Solution653 ViewsLast Modified:
Thank you!

I have a send object command that send a report.  The problem I am having is that the rptCSM report loops to the bound table?  How I know this is when I go to the email the report will have the same amount of pages as there are records to the rptCSM bound Table.  There should only be one page to the rptCSM report.

I have this logic and I think I am filtering correctly:
'Check if in the SCGTable
Set rsSCGTable = New ADODB.Recordset
sSQLSCGTable = "Select * from SCGTable where SCGNumber = '" & TxtSCGID & "'"
rsSCGTable.Open sSQLSCGTable, CurrentProject.Connection
If rsSCGTable.EOF Then
message
Else
DoCmd.OpenReport "RptCSM", , , "SCGNumber = " & "'" & TxtSCGID & "'", acHidden
DoCmd.SendObject acSendReport, "RptCSM", "Rich Text Format",
DoCmd.Close acReport, "RptCSM"
End If

As you can see this is in ADO Verison 6.0

Also when I try this there is some small sized menus that come up and I don't want to see them?

Thank You!
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 4 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros