|
|
Hi this is santosh. i am writing code to access records from multiple tables created in oracle databaseinto VB.
I gave the connection string, i gave record set.it is working to retrieve data from one table , but when i was trying to retrieve data from mutiple tables by joining , its not working.
please help me in writing a select statement to join multiple tables in VB.
Bye
santosh
santosh
|
|
|
|
|
My guess is that your join statements are the problem, double check them.
|
|
|
|
|
i wrote the join statement but its still showing run-time error. i think my sytanx for join is wrong. so can u please give me the syntax to join tables and retrieve records from the database.
thanks and regards,
santosh.
|
|
|
|
|
I have a VB6 application that is running on a Windows 2000 Server using Terminal Services which are being managed by Citrix MetaFrame XP. Also running is ScrewDrivers v3 (A.K.A. Simplify Printing) from triCerat to manage the client printers.
I am using a third party custom ActiveX control called VSPrinter, which is part of VSView from ComponentOne, to provide print preview and printer control.
When I trigger a print from the print preview, I am presented with the standard Windows PrintDialog.
The problem is that the available printer list is populated with ALL printers available to Terminal Services, not just the printers for this client.
The ComponentOne support was useless, and their forums are littered with problems regarding usage under Citrix. Their standard reply is that one should check their forums for help. The common theme on the forum is that their product has not been tested in a Citrix environment.
Has anyone else used this control and observed this problem?
Or has anyone else found a print preview control that works in this environment?
|
|
|
|
|
i want to open a prefilled mail message.
the parameters are:
- to
- subject
- an attachment file
on my workstation the next code works fine:
Public Class SendFile
Private oApp As Object
Private oNameSpace As Object
Private olMailItem As Integer = 0
Private olByValue As Integer = 1
Public Sub New(ByVal AttachmentName As String)
'Return a reference to the MAPI layer
oApp = CreateObject("Outlook.Application")
oNameSpace = oApp.GetNamespace("MAPI")
'login with the currently user
oNameSpace.Logon(Nothing, Nothing, True, True)
OpenMessage(AttachmentName)
End Sub
Private Sub OpenMessage(ByVal AttachmentName As String)
Dim oMailItem As Object = oApp.CreateItem(olMailItem)
Dim oAttachments = oMailItem.Attachments
oAttachments.Add(AttachmentName, olByValue)
'open mailformular
oMailItem.Display()
End Sub
End Class
but on a citrix metaframe system (Windows 2000 Server installed) it fails with
-- ActiveX component can't create object
what's wrong about it?
stephan
|
|
|
|
|
Possible Outlook is not installed on that machine or you are referencing a different version on your machine (and subsequently in code) than what is installed on the citrix box?
"Half this game is ninety percent mental."
- Yogi Berra
|
|
|
|
|
My UserControl, I'm developing, have to get a custom constructor, with a parameter (StyleEnum) to getting a default-Style. This value is editable as the Style-Property in the PropertyGrid (Within the constructor I set the Style-Property too). The Style-Property will be not serialised (because it's value will be get in the constructor). I added a converter for my Control to generate the correct InstanceDescriptor. The code-generation works fine, but while testing I had a problem I can't solve:
I added my control to a form, changes the Style-Property to a other value and looked at the code. All is fine, the new value is be given to the constructor. Then I closed the form and the form-code and reopened the form. The Style-Property in code is still the old, but the Style-Property in the PropertyGrid is resseted to the initial value of the control. It looks like, the control is loaded with the standard constuctor without an parameters. How I can solve that problem, how I can tell the IDE to use the custom constructor with property?
-- modified at 8:41 Wednesday 7th December, 2005
|
|
|
|
|
The IDE is crap in this regard.
Your best bet, and I always do this, is make the default constructor private if you don't want it to be used.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Thanks for that good idea, I will try it and (if I found this thread) will tell you if it works.
|
|
|
|
|
Hi,
I need to print a windows form which has labels, text boxes ets on it. I do not want to display the windows form on screen as its being printed. Is there a way to do this.
Thanks
John
|
|
|
|
|
hi in my application i wanna store and retrieve images using sql server. i am using vb6 as my language. if anybody can help me please help.....
Roy Joseph
|
|
|
|
|
Generally the way to do this is to store image in a file, then you will only store the path to the image in SQL Server.
"Half this game is ninety percent mental."
- Yogi Berra
|
|
|
|
|
Tahnk you . But i want to store image not image path. in .Net e can use memory stream buffer to do this things. but in VB6........ what ? if u know plz reply.
Roy Joseph
|
|
|
|
|
In KB 149040 Microsoft reports a bug, but gives only a way to reproduce the error, but not a way to solve it. VB6.0 gives this error 3020 when I use
..............Recordset.Edit
..............Recordset.Delete
..............Recordset.Update
Error 3020 is meant to be given when you use Update without an AddNew or an Edit method.
Does anyone know how I can avoid this error, because VB6.0 does not delete the record because of this error.
|
|
|
|
|
Have your tried updating to a newer MDAC on your machine? MDAC Downloads[^]
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi, does anyone know who to programmatically to get a list of message in outlook express or ms outlook and show it in a list view? (VB.Net or VB6)
|
|
|
|
|
The code posted below write the eMail-Subjects of all eMails in the Inbox-Folder into a ListBox called List1. If you want to list the eMails of the other folders you have to loop through them with the 'oNamespace.Folders'-Object. I hope I could help you...
Dim oOutlook As Outlook.Application<br />
Dim oNamespace As Outlook.NameSpace<br />
<br />
Set oOutlook = CreateObject("Outlook.Application")<br />
Set oNamespace = oOutlook.GetNamespace("MAPI")<br />
<br />
Dim lvItem As MailItem<br />
<br />
For Each lvItem In oNamespace.GetDefaultFolder(olFolderInbox).Items<br />
List1.AddItem lvItem.Subject<br />
Next
|
|
|
|
|
Thank you very much for your answer. I will try to test it and let you know when it is working or not.
|
|
|
|
|
I already test your code and found some error with the reference, but i already customize of part of it as show below:
Dim oOutlook As Microsoft.Office.Interop.Outlook.Application<br />
Dim oNamespace As Microsoft.Office.Interop.Outlook.NameSpace<br />
<br />
oOutlook = CreateObject("Outlook.Application")<br />
oNamespace = oOutlook.GetNamespace("MAPI")<br />
<br />
Dim lvItem As Microsoft.Office.Interop.Outlook.MailItem<br />
<br />
List1.Items.Clear()<br />
For Each lvItem In oNamespace.GetDefaultFolder(6).Items<br />
' List1.Items.Add(lvItem.Subject)<br />
With List1.Items<br />
.Add(lvItem.SenderName)<br />
End With<br />
Next
Thank you very much for give me some idea about solving this problem!
Best Regard,
Kanel
|
|
|
|
|
Ok, the Code I posted is for VB6... I forgot to tell you...
|
|
|
|
|
Thank you very much for your respond. It is no problem, at least it's already give me an idea how to get the message from outlook. But I have one more question, if i select on the specific subject or sender, how could i load the content of the message into the text box? I assume that the message contain only text format.
|
|
|
|
|
i wanna to move my form towards mouse pointer on desktop . it should move whenever i move mouse pointer. please help me to do this. i tried with form's left property and move metod. but no use....
please help 
thanks
Roy Joseph
-- modified at 2:04 Wednesday 7th December, 2005
|
|
|
|
|
Hey All
I have to develop a small application for which I have to generate the barcodes for the identifcation of the person.
Keep track how many times that person come
I have to develop it in .Net
Anybody Plz give me the idea
1. That how to generate the unique Barcodes
2. Then Read them each time person entered
What Approach should i follow
Hema Chaudhry
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
