I have a VB6 Application, using Crystal Reports 10 and SQL Svr 2000.
In the Crystal Report (GH3A) Group header, I have a formula (@FinancialSummary), which calculates a date string based on a field in the table. However, I'd like to pass it the value from my code. The code I use to call the...
We have a WAN in our corporate environment. Each of our 6 branches has its own Exchange server. Our Exchange server in head office replicates every 10 or so minutes to these branch Exchange servers.
I've developed a VB6 application, which places an email in our Head Office Exchange server in a...
Hi..I have been scouting around to find something to help me and came across the following if it is of some help to you....
Example
This example demonstrates how to use to set some of the properties of the MicrosoftMailDestinationOptions class.
[Visual Basic]
Public Sub ExportToMSMail(ByVal...
Hi.. am new to Vb.Net... Problem is, I have an exisiting report that I wish to call programatically, pass it two parameters and then email. Can someone please help ???
PS - Not for school project or any other nefarious reason!
Hi - Unfortunately, no one helped. I tried this URL www.dimastr.com and looked at the OutlookSpy option.. To be honest, I didn't explore it further.
If you dont come right, let me know and I'll try and help you.
Will this help ?
Option Explicit
'Connections
Public PCis As New ADODB.Connection
Private Command1.click
dim SQL as string
SQL = " Exec PCis.dbo.portcis_getbdastatement_statementsdb '200312'"
'StatementHistory.Execute SQL
PCis.Execute SQL
end sub
Private Sub Form_Load()
Set...
Just along similar lines, I've got a stored proc sitting in SQL svr 2000 and when I run it from my VB6 code, it pulls 365 records from the tables and then hits the timeout expired error. Anyway I can get around this as I am not using a recordset where I can set the timeout ?
Thanks
I tried using the following code to send an email from VB6, containing a Crystal report and it came up with the error "missing or out of date dll".
Anyone know of a solution please ?
Thanks for the quick reply... Just in closing, how do I suppress the dialogue box from appearing, is that just a false. Only need one copy and no collation. How do I supply those ?
Thanks!
Starting out with Crystal..as always, things have to be done in a rush.
I am using Crystal 10 developers edition, with VB6.
I've used the data report writer in VB6, but never the Crystal Report one.
Some questions :-
1) How do I setup the datasource for the crystal report programmatically ...
Can someone please check the attached code and tell me what else needs to be added to create a new appointment in someone else's Outlook Calendar ? I dont seem to be able to get the part(.subject, .start etc) to work as it always complains its not part of the collection..
Thanks
Set olMAPI =...
I've created the following XSL file and when it runs with the XML file, only one row is returned. What would cause this to happen ?
<!--Start of XSL-->
<?xml version="1.0" encoding="ISO-8859-1"?><xsl:stylesheet version="1.0"...
Simply, I need to establish that what I want to achieve is in fact possible - without spending time on what might end up to be a wild goose chase. Yes, I am prepared to learn, but I also have a time constraint.
To reiterate, I have an XML file that contains the information of many clients. I...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.