Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Alkemac

    Passing a parameter to a Crystal Report

    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...
  2. Alkemac

    Corporate WAN issue

    Hi.. checked that out and the user has ownership rights on the folder... Thanks
  3. Alkemac

    Corporate WAN issue

    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...
  4. Alkemac

    sending email.

    Thanks Andrew... I'll have a look at it..
  5. Alkemac

    sending email.

    Hi.. How different would it be trying to place the email in a default folder in a public folder ? Thanks
  6. Alkemac

    Calling existing Crystal Report in VB.Net

    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...
  7. Alkemac

    Calling existing Crystal Report in VB.Net

    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!
  8. Alkemac

    Posting a new appointment in someone else's Outlook Calendar

    Thanks a mill... I'll give it a try...
  9. Alkemac

    Posting a new appointment in someone else's Outlook Calendar

    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.
  10. Alkemac

    Using ExportOptions to define a "send as" user name

    Does ExportOptions support the ability to send an email via MAPI and VB6 using another email address instead of my own deafult ? Thanks
  11. Alkemac

    Timeout Expired with ADO connection

    Thanks Dr....
  12. Alkemac

    Timeout Expired with ADO connection

    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...
  13. Alkemac

    Timeout Expired with ADO connection

    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
  14. Alkemac

    Emailing Crystal Report

    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 ?
  15. Alkemac

    Sending Crystal report to print

    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!
  16. Alkemac

    Sending Crystal report to print

    Very simple question - how do I programmatically send a Crystal Report to the default printer through VB6 ? Thanks
  17. Alkemac

    Supplying CrystalReport Datasource

    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 ...
  18. Alkemac

    Posting a new appointment in someone else's Outlook Calendar

    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 =...
  19. Alkemac

    Only one row returned from XML file

    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=&quot;1.0&quot; encoding=&quot;ISO-8859-1&quot;?><xsl:stylesheet version=&quot;1.0&quot...
  20. Alkemac

    XML/XSL 2 SQL SVR - Making the right choices

    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...

Part and Inventory Search

Back
Top