 |  |  |  |  |  |  |  |
Is it possible to display report in Visual Basic which is created in Microsoft Access
 |
Is it possible to display report in Visual Basic which is created in Microsoft Access
0
#1 Apr 4th, 2005
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.
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.
•
•
Join Date: Dec 2004
Posts: 2,413
Reputation: 
Solved Threads: 211
Re: Is it possible to display report in Visual Basic which is created in Microsoft Access
0
#2 Apr 4th, 2005
I'm not sure if this what you are looking for, but have you looked at crystal reports?
Re: Is it possible to display report in Visual Basic which is created in Microsoft Access
0
#3 Apr 4th, 2005
•
•
•
•
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.
Re: Is it possible to display report in Visual Basic which is created in Microsoft Ac
0
#4 Apr 15th, 2005
•
•
•
•
Originally Posted by Comatose
I'm not sure if this what you are looking for, but have you looked at crystal reports?
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
Re: Is it possible to display report in Visual Basic which is created in Microsoft Access
0
#5 Apr 20th, 2005
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
Richard Henerlau
Re: Is it possible to display report in Visual Basic which is created in Microsoft Access
0
#6 Apr 28th, 2005
•
•
•
•
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.
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
Re: Is it possible to display report in Visual Basic which is created in Microsoft Access
0
#7 Oct 28th, 2005
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
•
•
•
•
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
Re: Is it possible to display report in Visual Basic which is created in Microsoft Access
0
#8 Nov 15th, 2007
•
•
•
•
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.
Regards
Chiquito
|
Similar Threads
- visual basic and access (Visual Basic 4 / 5 / 6)
- Question in Visual Basic 6.0 (Visual Basic 4 / 5 / 6)
- Need Visual Basic (Visual Basic 4 / 5 / 6)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: Remote Desktop Connection
- Next Thread: Problem in Running application on another computer
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest Visual Basic 4 / 5 / 6 Posts
- Today's Posts
- Unanswered Threads
* 6 429 2007 access activex add age application basic beginner birth bmp calculator cd cells.find click client code college component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report save search sendbyte sites sort sql sql2008 sqlserver subroutine tags textbox time urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows
