Search results for query: *

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

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

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

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

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

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

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

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

Hi, I'm creating reports with the Report Designer Component 8.0 and I was wondering about something... I tried to install it on a client machine. Everything works, except when I want to preview a report saying it can't connect to the physical database. Found some information at the...

Hi, I'm developing a VB6 application which generates reports from stored procedures. I succeeded to connect to the database by using the SetlogOnInfo with the necessary parameters. Report.database.tables(1).SetLogOnInfo <server>,<database>,<username>,<password> For testing purposes, this is...