|
-
Dec 29th, 2005, 12:38 PM
#1
Thread Starter
Fanatic Member
Report ..
How can I make a Report like in acces? Is it easy to make a Report and take print as easy in Access. Please help.
Seema_s
-
Dec 29th, 2005, 12:40 PM
#2
Re: Report ..
Make your report in Access and just call it from VB.
Other than the printer object, VB has not built in reporting features.
-
Dec 29th, 2005, 12:42 PM
#3
Thread Starter
Fanatic Member
Re: Report ..
 Originally Posted by Hack
Make your report in Access and just call it from VB.
Other than the printer object, VB has not built in reporting features.
What is the code to call a report from VB? I need help plz.
-
Dec 30th, 2005, 04:53 AM
#4
Re: Report ..
select data report in vb ide from project>add data report and then change the data source and record source properties .create text boxes and labels in that report and also link them.Then just call your report from vb code .
-
Dec 30th, 2005, 06:58 AM
#5
Re: Report ..
 Originally Posted by seema_s
What is the code to call a report from VB? I need help plz.
First, go into Access and create the report.
Then, from your VB program, set a reference to the MS Access Object Library, then run something like this
VB Code:
Private Sub cmdPrintReport_Click()
Dim Axs As Access.Application
Set Axs = CreateObject("Access.Application")
Axs.OpenCurrentDatabase (DBPath)
Axs.DoCmd.OpenReport "MyReport"
Set Axs = Nothing
Axs.Quit
End Sub
Where MyReport is the name of your Access report and DBPath is the full path and db name of your database.
-
Dec 31st, 2005, 11:47 AM
#6
Thread Starter
Fanatic Member
Re: Report ..
 Originally Posted by Hack
First, go into Access and create the report.
Hi, Friends. Thanks for the help. Let me know is it hard to create a report in VB?
Regards,
Seema_S
-
Dec 31st, 2005, 02:14 PM
#7
-
Jan 1st, 2006, 04:37 AM
#8
Re: Report ..
 Originally Posted by seema_s
Hi, Friends. Thanks for the help. Let me know is it hard to create a report in VB?
Regards,
Seema_S
I already explained that you don't create a report in VB. You create a report in Access, or Crystal Reports or some other type of report generator, and call the report from VB.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|