show only one page of access report in vb.net

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello
I am trying to open up an access report that was already built in a vb.net program. I have no problem with that, the thing is that I need to only open up the page of the report that is currently open in the .net program. Any ideas

Thanks
Brian
 
Hi Brian,

I am somewhat confused about the problem.

How do you open the access report in VB.NET and how do you build-in the
report in vb.net program? Do you mean by means of automation the Access?

And your aim to open the report with certain page by automation Access.

I will appreciate your efforts if you can provide your situation more
detailed.

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.
 
Hi Brian,

I am not sure if you are opening the access report by using automation. If
you are do so, I think it is not easy to do so, because the page of report
in access is related the design of the report.that is to say how many
records will be displayed in one page is determined by the design of the
report. In this situation, if you wants to display certain page, you may
need to know the which records are displayed on the page, then use the
filter and where condition to filter the output of the report, so that you
will see that the record will just one page.

So can you tell me if you are automation the access to display the report
in the Access?

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.
 
Hi Peter
I got it to work by doing a couple of wierd things. I made a nother table and all that is in it is id of the person I want. Then I made a query and linked that to the main table so that all that is shown is the record I want, and then I run the report with the new small query as the datasource, instead of the entire database. I think this should work, as long as nothing goes wrong when the update is being done to the second table. I am not sure if this made sense, I seem to be confusing even myself.

Thanks for the help
Brian
 
Hi,

I think report will restrieve the data from the table. So you may try to
change the report's recordsource property to get the record what you want
or just use the filter property of the report.

So do you have concern about the method above, if so please feel free to
let me know.

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.
 
Back
Top