|
I am looking for a SQLHelper class for an access vba application. I am in a time crunch on a project and would like to find an exsisting piece to start working from.
|
|
|
|
|
I started programming VB with the Learners addition 6.0. It did not come with several of the more advanced components, especially MAPI. Instead of move to the VB6 Professional, I purchased VS.Net 2003. Now I am really lost.
I am trying to create an application that will create an email using the default mail client and I am going to pass some variables to, like message text and an attachment. I do not see that MAPi came with VS.net. I see system.web.mail, but that does nto appear to use the mail client on the local machine.
Is MAPI part of VB.net? Is there a way to do what I describe without owning the MAPI OCX from VB6?
Chris
|
|
|
|
|
MAPI doesn't come with any version of VB. The Messaging API (MAPI32.dll)is only installed with Exchange Server, Exchange Client, the full version of Outlook (not Express!), or Windows Messaging.
The System.Web.Mail namespace in the .NET Framework wraps the CDOSYS (Collaboration Data Objects for Windows 2000) and will either send mail using the SMTP mail service built into Windows 2000 and above, or use an arbitrary SMTP server. CDOSYS is a COM component that wraps the CDO API 2.0, NOT MAPI. Lost yet? Read this[^].
Now, in order to launch the default STMP client (not MAPI!), you would do the same thing that IE does. Shell the command line:
mailto:someone@somewhere.com?subject=Some subject?body=Some message body
But, attachments are not supported this way!
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I am looking for a way to make scroll bars that come with text boxes to scroll down automatically when the text box fills up. If anyone can help me i would greatly appreciate it.
Thanks in advance
P.S feel free to email me the solution as well to iamydd@bellsouth.net
|
|
|
|
|
hi
U pls give the Multiline property of text box to true and also scroolbar property 1 or 2 or 3.
try it
Ok
Bye Arun
Arun
|
|
|
|
|
Thanks, but the multiline property is already at true and i cant find scroolbar propertys. The only thing it has it for me to set scrollbars to vertical horizontal both or none.
|
|
|
|
|
Hey
I am having trouble, i have a filepath and i am trying to ad the following steps to a button click:
- Select a Printer By name
- Send it my file path
- Print file
Any help would be greatly appreciated
thanks you for your time
Chris
|
|
|
|
|
Possibly using a process?
|
|
|
|
|
You can do that with Crystal Report.
That´s a VB component to print.
Very easy to use.
|
|
|
|
|
How to do that? Do you have any document or resource on the web to demonstrate about this technique?
A thousand mile of journey, begin with the first step.
APO-CEDC
Save Children Norway-Cambodia Office
|
|
|
|
|
You can see this page: http://www.businessobjects.com/products/reporting/crystalreports/appdev.asp .
But it is really easy. In VB you have to add the Crystal Report Component; in VB.NET it is named ReportDocument.
The file you want to print has to be a crystal report document (you can download the software in the site above). Then you have just to work with properties and methods.
Ex in VB.NET: reportDocument1.PrintOptions.PrinterName = ""
|
|
|
|
|
File path to what kind of document? There printer object cannot interpret every kind of document. Actually, it can't interpret ANY kind of document. What you do depends entirely on what you're trying to print.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hey thanks for the feedback.
I have an installed PDF printer that i want to send my documents (MS Office Documents) too and also a 'print' command. The printer will do the rest.
Does this make it harder or easier to print the files or is the situation still the same?
Thanks
Chris
|
|
|
|
|
That's better. Word will actually have to do the printing. The PDF printer will just render into a .PDF what Word outputs when it prints. If you're just going to convert Word documents, you can use the Word (Office) automation model to load the document, select the printer, then print the document. It's been covered dozens of times in the forum, just search for Word using the "Search comments" link.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Sir,
I've a Windows Services on application server that listen to the folder files & process it.
In turn, the data will be inserted into a table in SQL2K and the associated trigger will call the stored procedure that will call the exec master..xp_cmdshell to call ASP page that generating a report (image).
This scenario works well when the application server in log on status..
but while the server is log off..
the errors below appears:
1)
System.Data.SqlClient.SqlException: A severe error occurred on the current command. The results,
if any, should be discarded.
xpsql.cpp: Error 997 from GetProxyAccount on line 604
2)
A severe error occurred on the current command. The results, if any, should be discarded.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
thanks...
Best Regards,
Sayhigh Soon
|
|
|
|
|
sayhigh wrote:
1)System.Data.SqlClient.SqlException: A severe error occurred on the current command. The results, if any, should be discarded.
xpsql.cpp: Error 997 from GetProxyAccount on line 604
Look at this[^] KB article on MSDN.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
hi
I am doing a project in vb for serial port communications.I want to know how to use Timeouts functions. I want a time gap between the sending datas.
So how can i set the timeouts for that.Or is there any other methods for setting time gap between the sending datas?
Pls give your valuable sujessions
Arun
|
|
|
|
|
|
I found an article regarding "Persist ListView settings with serialization". it was great but it was in C sharp. I am a VB.Net programmer. Can someone please help me get a VB.Net version of the same program. (my requirement is only to saving and restoring the column layouts ofthe list view)
Thanks in advance
v
|
|
|
|
|
|
I found an article regarding "Persist ListView settings with serialization". it was great but it was in C sharp. I am a VB.Net programmer. Can someone please help me get a VB.Net version of the same program. (my requirement is only to saving and restoring the column layouts ofthe list view)
Thanks in advance
|
|
|
|
|
Hi, can anyone give me an idea? Between SQL Server 2000 reporting service and Crystal Report, which one is better to use with visual studio .net? I try to install SQL server reporting service many time but it is not success because it require SQL service pack 3a, I alread install it but it did not work.
A thousand mile of journey, begin with the first step.
APO-CEDC
Save Children Norway-Cambodia Office
|
|
|
|
|
Please, help. I need make toolbar, but i don't know how it make. Contact me on ICQ please. If you want, we can start some business together. Thanks.
14-73-65-46-9
|
|
|
|
|
Dear All,
I am doing a project using VB6 and MS word. What i need to do is to put/read everything in a word file, which may contains tables, images and all format and alignment. My problem is how can i read everything for that word file and store in a place, when a user request, then i have to pull out this doc file or just a few line from this doc with exact look? i have been search in so many forums but still can't get any help for it. But i am sure there is so way can do it, it may be a third party component. I don't know. Can anyone give me some help? Please help urgently. Thanks
Yolip
|
|
|
|
|
Your going to have a nasty time with this. I don't know of any 3rd party component that will do anything like this. Also, the formatting of a Word document can come from many places. In order to get the look of the document exact, you'll also need the styles section of the current document, printer settings for margins, EVERYTHING. You'd be much better off showing the entire document that the section you want came in rather that trying to duplicate what was in the original document.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
