|
hi Adhizzz. i hope this helps
Print a Microsoft Access report from VB 6.0
As you may know, Microsoft Access provides a much more robust reporting
system than Visual Basic. As a result, if you use Access as a back-end
to your application, you may want to print Access reports from your VB
application. Fortunately, you can do just that with Automation.
The following code shows one way to do so, using late binding. remember to replace dbName and rptName with correct values:
Dim objAccess As Object
Private Sub Command1_Click()
Dim dbName As String
Dim rptName As String
Dim Preview As Long
Const acNormal = 0
Const acPreview = 2
dbName = "D:\PathToDB\db1.mdb"
rptName = "MyReportName"
Preview = acPreview 'acNormal
With objAccess
.OpenCurrentDatabase filepath:=dbName
If Preview = acPreview Then
.Visible = True
.DoCmd.OpenReport rptName, Preview
Else
.DoCmd.OpenReport rptName
End If
End With
End Sub
Private Sub Form_Load()
Set objAccess = CreateObject("Access.Application")
End Sub
Private Sub Form_Unload(Cancel As Integer)
On Error Resume Next
objAccess.Quit
On Error GoTo 0
Set objAccess = Nothing
End Sub
|
|
|
|
|
hi Adhizzz. i hope this helps
Print a Microsoft Access report from VB 6.0
As you may know, Microsoft Access provides a much more robust reporting
system than Visual Basic. As a result, if you use Access as a back-end
to your application, you may want to print Access reports from your VB
application. Fortunately, you can do just that with Automation.
The following code shows one way to do so, using late binding. remember to replace dbName and rptName with correct values:
Dim objAccess As Object
Private Sub Command1_Click()
Dim dbName As String
Dim rptName As String
Dim Preview As Long
Const acNormal = 0
Const acPreview = 2
dbName = "D:\PathToDB\db1.mdb"
rptName = "MyReportName"
Preview = acPreview 'acNormal
With objAccess
.OpenCurrentDatabase filepath:=dbName
If Preview = acPreview Then
.Visible = True
.DoCmd.OpenReport rptName, Preview
Else
.DoCmd.OpenReport rptName
End If
End With
End Sub
Private Sub Form_Load()
Set objAccess = CreateObject("Access.Application")
End Sub
Private Sub Form_Unload(Cancel As Integer)
On Error Resume Next
objAccess.Quit
On Error GoTo 0
Set objAccess = Nothing
End Sub
![Rose | [Rose]](https://www.codeproject.com/script/Forums/Images/rose.gif)
|
|
|
|
|
Hello Sir,
I have been assigned a task to auto mate a school system. i.e. Timetabling issues, Teacher Replacemts, Employee Attendances(HR), Exam control and Student Records...
although .. i have analysed almost everything.. database tables are finalized as well...
but coz of being untouch with all this development issue since a year.. i am just strugling as to how and where to start design and development of the software....?
if anyone having idea about this kind of software? please help me ...
or i would be grateful if anyone can come up and exchange emails with me regarding this project... i mean, the one, who can help me step by step..as how to start
i'll be using VB.NET and SQL Server...
thanks ..
All Praises are for the Lord of the universe...
Regards,
Tahir
|
|
|
|
|
My advise to you is prioritize. Seems to me that the functionalities you describe can best be split in several solitary programs. Prioritize and start from there.
Grtz, Guus
|
|
|
|
|
Yes! I am trying to priortize the functionalities...
looking for Teacher and Student Records Managent at first hand...
but still kind of confused.. 
any more suggestions please?
thank you
|
|
|
|
|
I'm doing a project to write a system using Vb6.0. The system is very simple but for me is very hard. The most difficult part is to comes out with chart. The chart is to analyze the stocks. The system is a system for a shop seeling clothes one..Anyone can help pls reply. Thanks
|
|
|
|
|
Your question puzzles me slightly. But from what i understand is that you need to produce some sort of chart.
Excel is equipped with a wide range of charts. Use code to populate an Excel spreadsheet and open it.
Grtz Guus
|
|
|
|
|
I have written a small script in VBA which I need to deploy to a number of machines on a network.
Is there an easier way other than manually importing a .bas file into Outlook?
I found reference to a program called Desktop.VBA but every link on every site I found pointed to the same dead server...
Any and all help would be greatly appreciated.
Cheers,
Simon.
|
|
|
|
|
I need help i have a firewall, and some one keeps trying to connect to my comp, i need help getting back at this person so if anyone has any ideas please let me know? I have the persons IP Address. Thanks guys for all help
|
|
|
|
|
Simple. Find out who owns the IP address this person is using and report them. ANything you do to the other guy carries the risk that your going to get busted.\
RageInTheMachine9532
|
|
|
|
|
alright i appreciate that, and i did figuare out how to report it and i already did. I hope that works and again thanks for your help
|
|
|
|
|
plz sir help me how can i connect with data base with out using controls.
|
|
|
|
|
Take a look at the System.Data namespace.
If you are using SQL Server, read about System.Data.SqlClient, if not, System.Data.OleDB.
Free your mind...
|
|
|
|
|
Or when you are using a connection string in VB go to http://www.connectionstring.com
Grtz Guus
|
|
|
|
|
hello i got little problem
okay u now see the main form
i click button
it opens another form lets says its form2
in form2 there is also button than open form3
in form3 there is close button
when i click on it
it close both form2 and 3
i want only to close form3 and let form2 opened?
how can i do this?
im using
Dim something As new form2
something.show
somebody help me plz
thanks
|
|
|
|
|
hi samerali,
i don get your problem. with form1, form2 n form3 as u describe, this code works for me the way u want. assume each form has a button1:
'//in form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim NewChild As New Form2()
'Display the new form.
NewChild.Show()
End Sub
'//form2
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim NewChild As New Form3()
'Display the new form.
NewChild.Show()
End Sub
'//form3
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Me.Close()
End Sub
|
|
|
|
|
I need help developing a firewall in vb 6.0
|
|
|
|
|
Hello
Please let me know the cursor attributes of the data recieved by telnet using Winsock. I mean the cursor location is updatebale or just readonly. For example if we connect to the server , it returns UserName : ABCDEF
Here the cursor atteched to UserName is read only & the cursor attached to ABCDEF is read write where in one can change the contents.
Please let me know the curcor attributes in VB using Winsock
|
|
|
|
|
I am creating a league table and i was wondering whether anyone would have some code which is relevant to what i want to do. I am creating the program in VB 6 and i have to finish this prgram soon because this is what im going to use when i begin my own league. My prgram should allow me to enter results which then works out the league table. i need help so plz try ur best to supply me with a readily made program or some code thanx
|
|
|
|
|
Hi all!
I am currently trying to create some simple interactive games using VB 6. I came across this Map OLE control whereby when the user clicks on certain region of a picture, the program will be able to detect and pop a msg out.
However this OLE control can't seem to load on my VB 6 because it was meant for VB 4.
Much help is needed here.
thank alot!!!!
|
|
|
|
|
Hi
Can anybody tell me HOW CAN I SEND A MAIL WITH PICTURE & BACKGROUND WITH
VB? (E: with using ms richtextbox)
when i use ms richtextbox and put a picture in that
1) i can't use picture as background.
2) picture in my mail convert to several character and my message
put beetween characters.
if you can help me please tell me solution !!!
BEST REGARDS.
MkhProgrammer
|
|
|
|
|
most of the time when some one install the patch then this is used to fix some bugs and some provide some new features for upgradation. so i want develop application with vb.net that can be upgradable later just installing patch a mini application delivered by me.i don't know the logic that how to develop a application in such a way that can be upgradable later just installing patch a mini application delivered by me. so please guide me.
tbhattacharjee
|
|
|
|
|
Hi,
There are difference ways to patch an application. The easiest way is when none of the interfaces of your objects have changed. Say, you just changed a line like "a = a+1" to "a = a+2", that's not a big change. So you may consider just sending out a new dll or exe which can be copied directly over the old file.
If the interface of an object changes, say you change a method from "GetMyData (Byref a as integer)" to "GetMyData (Byref a as double). Would be consider a change to the interface of an object. Now all things which call GetMyData need to comply with this change. That can lead to all sorts of files being copied.
It seems to be the way these days that when you download update they just contain heaps of new files in their entirety. Back when I was a lad, we used a system called RTPatch. It used to work out which parts of files had changed and make a true "patch". Maybe its still around.
Hope this gives you a start along the path.
Nursey
|
|
|
|
|
hi Tridip Bhattacharjee,
A patch is simply a setup which makes changes to an existing application
rather than instal a new one altogether.
If u break your interface, u need to compile your application again; if there are database changes (if the application uses databases), then you need a script(s) to duplicate all changes to your customers' databases - without losing their data!
This is your patch.
![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
|
|
|
|
|
say suppose i have developed a application by vb.net which will help me to detect database server like oracle or sqlserver in a network.
i am unable to do it please help me.
tbhattacharjee
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
