vb.net and acces report

[sbdproj]

Hi,

I'm having a problem with opening an access report in my program.
I'm using an access database(2003) in which I've already made some reports. In my my program I fill the databases and then after hitting a button I want to view the reports I've already made.

I got the progam to open access but when I want to open and view the reports it goes wrong. Instead of opening the report access gives me the possibility to save the report as an PDF file.
This is the code I'm using:
Dim oAccess As Object
oAccess = CreateObject("Access.Application")
oAccess.OpenCurrentDatabase(filepath:="S:\Schildklier_Portaal.mdb", exclusive:=False)
oAccess.DoCmd.OpenReport(ReportName:="qry_overzicht_schildkliermeting")

What am I doing wrong here? Or is there an easier way to view the reports I've made?

paul

 

[DeanConsulting]

I am not really sure on this but I have always used Crystal Reports. Have you looked into this?



---------------------------------------
Noble D. Bell

http://www.noblesoftware.com

 

[sbdproj]

I'm checkin' it out now, I've never used it before.
I thought it would be easy to open an access report in vb.net but apparently it doesn't...

 

[chrissie1]

do this insttead
make a reference to microsoft access 10.0 objects or another version
If you want to print change acviewpreview to acviewnormal

dim Accessapp as New Access.Application 
Accessapp.OpenCurrentDatabase (FilePathName) 

Accessapp.DoCmd.OpenReport (Reportname, Access.AcView.acViewPreview)
Accessapp.Visible = True

Christiaan Baes
Belgium

If you want to get an answer read this FAQ faq796-2540
There's no such thing as a winnable war - Sting

 

[sbdproj]

I've added the reference "Microsoft Access 11.0 Object Library" . It stands in my list with other references but I still get these errors:
Type 'Access.Application' is not defined. and
Name 'Access' is not declared.

any ideas?

 

[chrissie1]

if you type imports what is the list you are getting mine says access as the first member. Perhaps they changed it for acces 11 into msaccess perhaps. Sorry but i don't have access 2003.

Christiaan Baes
Belgium

If you want to get an answer read this FAQ faq796-2540
There's no such thing as a winnable war - Sting

 

[sbdproj]

if I type imports I get this list:
ADODB
ChristalDecisions
Dao
Microsoft
ReadWriteFile (my app.name)
Std
System
Util

Where should I find access?

 

[chrissie1]

perhaps under microsoft

Christiaan Baes
Belgium

If you want to get an answer read this FAQ faq796-2540
There's no such thing as a winnable war - Sting

 

[sbdproj]

I've found it:
Imports Microsoft.Office.Interop.Access

But I still get the same errors.
Type 'Access.Application' is not defined. and
Name 'Access' is not declared.

Am I forgetting something else what could cause these errors?

 

[chrissie1]

then i think it coul be

dim Accessapp as New Microsoft.Office.Interop.Access.Application 
Accessapp.OpenCurrentDatabase (FilePathName) 

Accessapp.DoCmd.OpenReport (Reportname, Microsoft.Office.Interop.Access.AcView.acViewPreview)
Accessapp.Visible = True

Christiaan Baes
Belgium

If you want to get an answer read this FAQ faq796-2540
There's no such thing as a winnable war - Sting

 

[sbdproj]

It works fine now!
thanx for the help