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 strongm 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: *

  • Users: vjee
  • Order by date
  1. vjee

    Changing appointments in Outlook 2003

    Back with some more information... did some testing and I isolated the problem. What I do is the following: I wrote an Outlook COM Add-In in C#. This add-in captures all changes to appointments and displays a window where the user can add some additional information which is stored in some...
  2. vjee

    Changing appointments in Outlook 2003

    Yes, there is only one server. Vjee Component Developer
  3. vjee

    Changing appointments in Outlook 2003

    Hi, we are having problems with updating appointments. When we create an appointment in Outlook 2003, save it, close the appointment en open Webmail, the appointment is there. When we change the time of the appointment in Outlook, save it en connect to Webmail again, the appointment is still at...
  4. vjee

    Exporting Excel data as XML - Decimal separator

    Hi, I'm having problems with the decimal separator when exporting Excel data to an XML-file. I have a number of cells which I export to XML using a data map: ActiveWorkbook.XmlMaps("exportmap_Map").Export URL:="d:export.xml", Overwrite:=true Simple and clean... The problem is the decimal...
  5. vjee

    Opening Word document with parameters

    uhmmm... I think I explained it a little bit wrong. :) At this moment, I call the macro through automation and pass the parameters directly to the macro : Private Sub Command1_Click() Dim wrdApp As Object Dim wrdDoc As Object Dim strFileName As String Set wrdApp =...
  6. vjee

    Opening Word document with parameters

    Hi, does anybody know if it's possible to open a word template using VB and pass parameters to this template and use them in a VBA-macro without passing them directly to the macro? So, it's like opening the template with commandline parameters from the "Run" prompt, for example...
  7. vjee

    Export to Excel produces files of 0 bytes long

    I must have missed that article during my search. Going to give it a go. Already downloaded the hotfix. Thx Mark! Bart
  8. vjee

    Export to Excel produces files of 0 bytes long

    Hi, I'm having a little trouble with exporting Reports to Excel. I'm trying to export it from the Crviewer. I'm using Visual Basic 6 and Crystal Reports 8.0 in a Windows 2000 environment. The neccessary dll's for export are distributed. The weird thing is that after deploying my application, the...
  9. vjee

    ADO Update fails with Sybase System 11

    Hi, we are trying to update a table using ADO (2.6). We have a Sybase System 11 database. The weird thing is, the rs.update works fine UNTIL we try to update a varchar-field in the table. ex. with rs .fields("Status") = 5 .fields("AuditDate") = Now .update end with...
  10. vjee

    copy a file to a FTP server

    Included the path on the FTP host and the copy worked! THX CajunCenturion.
  11. vjee

    copy a file to a FTP server

    Hi, I'm looking for a way to copy a file to an FTP server. It's not an FTP-server on the internet but on a LAN. I have an IP from a computer somewhere on the local area network of our company. I tried it with the MS Internet Transfer control like this: with ctlFTP .Protocol = icFTP .URL =...
  12. vjee

    CreateObject vs "New" keyword

    Excellent!!! Thanks!!
  13. vjee

    CreateObject vs "New" keyword

    Hi, a collegue of mine was given the advice, to use CreateObject instead of using the "new" keyword. Dim xlObject = Excel.Application set xlObject = CreateObject("Excel.Application") set xlObject = New Excel.Application She asked me what the advantage was of using...
  14. vjee

    visual basic and crystal reports

    I know there's a version on one of the Visual Studio CD's. It's v4.6 (ancient!!) but I can't remember which CD it is. It's located under a directory \Common\Tools\crysrep You can also download it from their website but that's an evaluation version.
  15. vjee

    visual basic and crystal reports

    When you install the Crystal Reports Designer Component, you can choose it from your Project Menu (like forms, modules,...) and add a Crystal Report to your project. It similar to using the Data Reports from Visual Basic but better and it has more properties to play around with! :) The designer...
  16. vjee

    UNABLE TO USE REFERENCE TO RECORDSET OBJECT IN SQL STRING

    try this: "INSERT INTO SUTATTLS(EMPNO)" _ & " VALUES(" & objSource3.adoRsMultiUse!EMPNO & ")"
  17. vjee

    crystal reports & vb6

    Had the same problem. You have to add the needed runtime files yourself to your package. Crystal Decisions have a page where they givve some more information on this topic and which files to include in your package. http://support.crystaldecisions.com/kbase/c2007290.asp
  18. vjee

    Empty error when previewing report

    already found it. Played a bit around with the Stored procedure, renamed it,... works fine now.
  19. vjee

    Empty error when previewing report

    Hi, I have just converted my reports to use the p2soledb.dll to connect to a SQL Server 2000 Stored procedure. When previewing the report (or verifying the database), I'm getting an empty error dialog followed by an "Server has not yet been opened" error. The first error is my...
  20. vjee

    Connect through Trusted Connection to SQL Server

    Took me a while to try it due to other problems, but it worked. Thanks! Bart

Part and Inventory Search

Back
Top