Ad:

Visual Basic 4 / 5 / 6 Discussion Thread
Unsolved
Views: 14009

Apr 4th, 2005

Is it possible to display report in Visual Basic which is created in Microsoft Access

Expand Post »

Is it possible to display report in Visual Basic which is created in Microsoft Access?

We developed a databasep applicaton that uses Access database. but one of the cross tab reports is difficult to develp in VB , but could develop in Access. Now I want a way to call this report in Access thr' VB.

Similar Threads

visual basic and access in Visual Basic 4 / 5 / 6
Question in Visual Basic 6.0 in Visual Basic 4 / 5 / 6
Need Visual Basic in Visual Basic 4 / 5 / 6

sham

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

40 posts
since Mar 2005

Permalink

Apr 4th, 2005

Re: Is it possible to display report in Visual Basic which is created in Microsoft Access

I'm not sure if this what you are looking for, but have you looked at crystal reports?

Comatose

Team Colleague

Reputation Points: 361

Solved Threads: 214

Taboo Programmer

Offline

2,413 posts
since Dec 2004

Permalink

Apr 4th, 2005

Re: Is it possible to display report in Visual Basic which is created in Microsoft Access

Quote originally posted by sham ...

Is it possible to display report in Visual Basic which is created in Microsoft Access?

We developed a databasep applicaton that uses Access database. but one of the cross tab reports is difficult to develp in VB , but could develop in Access. Now I want a way to call this report in Access thr' VB.

ya u can..

N[e]tt[e]

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

18 posts
since Feb 2005

Permalink

Apr 15th, 2005

Re: Is it possible to display report in Visual Basic which is created in Microsoft Ac

Quote originally posted by Comatose ...

I'm not sure if this what you are looking for, but have you looked at crystal reports?

Yaa, I know crystal reports, but it needs additional licence cost.
One of the reports I wanted could not be developed in Data Reports since it has subreport control(master-detail) in it and few field/control calculations.

I developed this report in Access where all the data resides for this project. Now I want a short from VB to be developed so as to open Access report.
I hope this clarifies scenario.

=Sham

sham

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

40 posts
since Mar 2005

Permalink

Apr 20th, 2005

Re: Is it possible to display report in Visual Basic which is created in Microsoft Access

There is no built-in control to display access reports in Visual BASIC. However, there are several third-party components (some of which cost $$$) that can be used for this purpose. Hope this helps!

Richard Henerlau

rhenerlau

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

9 posts
since Apr 2005

Permalink

Apr 28th, 2005

Re: Is it possible to display report in Visual Basic which is created in Microsoft Access

Quote originally posted by sham ...

Is it possible to display report in Visual Basic which is created in Microsoft Access?

We developed a databasep applicaton that uses Access database. but one of the cross tab reports is difficult to develp in VB , but could develop in Access. Now I want a way to call this report in Access thr' VB.

Why don't you check out VB6 Shell to MSACCESS.exe pass report name as a parameter.

RetVal = Shell("C:\Program Files\Microsoft Office\Office\MSACCESS.exe YourDB.mdb /cmd Rpt001", 1)

You can look up in Access the Command Line parameters the /cmd says you are passing a parameter, you could have code in access to intercept this parameter in I believe Command$. Then you can Docmd to open the report based on the parameter sent in like in this case Rpt001.

Mike

Mike Vance

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

4 posts
since Apr 2005

Permalink

Oct 28th, 2005

Re: Is it possible to display report in Visual Basic which is created in Microsoft Access

Wouldn't that require everyone that wants to view the report to have copy of Access?? (not the runtime)

Which is what he is trying to avoid

He would need VB6 Professional version, Both Crystal Reports and Data Reports are in the controls.

-----------
Kegtapper

Quote originally posted by Mike Vance ...

Why don't you check out VB6 Shell to MSACCESS.exe pass report name as a parameter.

RetVal = Shell("C:\Program Files\Microsoft Office\Office\MSACCESS.exe YourDB.mdb /cmd Rpt001", 1)

You can look up in Access the Command Line parameters the /cmd says you are passing a parameter, you could have code in access to intercept this parameter in I believe Command$. Then you can Docmd to open the report based on the parameter sent in like in this case Rpt001.

Mike

Kegtapper

Reputation Points: 13

Solved Threads: 4

Junior Poster

Offline

115 posts
since Oct 2005

Permalink

Nov 15th, 2007

Re: Is it possible to display report in Visual Basic which is created in Microsoft Access

Click to Expand / Collapse Quote originally posted by sham ...

Is it possible to display report in Visual Basic which is created in Microsoft Access?

We developed a databasep applicaton that uses Access database. but one of the cross tab reports is difficult to develp in VB , but could develop in Access. Now I want a way to call this report in Access thr' VB.

Si vos ya tenés creado el reporte (v.g. tureporte.rpt) lo podés llamar de donde quieras y cuando quieras. Lo que te sugiero es que desde tu programa en Visual Basic le mandes el recordset que tu previamente crearas en tu aplicación no solo porque es una práctica saludable sino evitar problemas de database (por ejemplo, tu creás el reporte usando Access y tu aplicación usa MySql, que tal?)
Regards
Chiquito

Chiquito

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since May 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Visual Basic 4 / 5 / 6 Forum Timeline: Remote Desktop Connection

Next Thread in Visual Basic 4 / 5 / 6 Forum Timeline: Problem in Running application on another computer

DaniWeb Message

Cancel Changes

User Name
Password