Search results for query: *

I have setup a simple DTS package that exports data from SQL to Excel which all works fine. This runs every night creating a new spreadsheet each time from a template. The problem is that I have other excel sheets that contain formulas that link to this data. If I open one of the linked...

Hi! I have been looking at running my VB6 app as a service and have come across 2 methods. One using the Microsoft 'ntsvc.ocx' and the other using API calls. I have looked at the ocx control which looks by far the easiest but can't get the sample program to work on my Windows 2000 Pro...

Thanks Mike, thats great!!!

Hi! This is probably a really basic question but here goes anyway... I have a report where I am grouping on a date for each week. By default it shows the sunday of each week as the group title, this works fine but I want this to be the Monday! Thanks in advance!

Thanks, however this is alrady what I am doing with the VB command '.Connect' and it works fine for reports based on tables but for SP's it just seems to ignore the command! Are you using the Crystal OCX control? If it works fine with Foxpro then it must be a VB/Crystal issue. I shall do...

Hi! I have set up a report that I call from my VB app using the Crystal OCX control. I need to change the location of the SQL database on the fly, this I can do for reports that access the SQL tables directly by using the code: CrystalReport.Connect = "dsq=" & DatabaseName However...

Hi! I am using the Crystal Reports OCX control with a VB6 application. 8/10 times when I call 'CrystalReport1.Action = 1' I get the following error: Run-time error '-2147417848 (80010108)': Automation error The object invoked has disconnected from its clients. I have looked all over the web...