Recent content by cmcgann

Hello All, I am running a report that takes in 2 date parameters. Start date and End date. However when I run the report for today no data is returned (even though the data exists). When I run the sql directly there is no problem.. I noticed that there was a statement in the criteria parameter...

Does anyone know how this can be set at the server side? Instead of explicitly setting it in each procedure, have it set as default? Thanks

I tried this and it works. Thanks all for your help..

Hi vongrunt, I hadn't. Tried it or heard of it. I had a quick look in help and this seems to be what i am looking for. I'll let you know how i get on. Thanks again.

Hi there, Thanks for the swift response. First off i have tried using rollback in error handling but the problem here is that it never gets executed by sql server. The rollback code goes something like this -- IF @@Error <> 0 -- BEGIN -- ROLLBACK TRANSACTION -- END This is a Server side...

Hi, I am experiencing a problem where an SQL transaction does not committ when the updates in the procedure times out. BEGIN TRANSACTION UPDATE WHATEVER SELECT WHATEVER UPDATE WHATEVER COMMIT TRANSACTION The knock on effect of this is that locks are held open for table WHATEVER...

Hi, Ive done this before with some problems, I didnt use the SQL generated VB code. I called the DTS package on the server directly from VB. I addeed a reference to the DTS object Library dtspkg.dll. I then executed it by calling the function below. I added a List View on the Form to display...

Sorry, Should have taken more care reading the Post. Im not 100% sure what you mean though, Do you mean just changing the Forecolor? Or having dfifferent colours for different columns? The Latter i dont think you can do..

Here you go!! Should work, just pass a different color to change 'Function Call adjustListviewColour lvExceptions, lSelectedItem, vbBlue Public Function adjustListviewColour(objListview As ListView, lIndex As Long, lColour As Long) Dim i As Integer Dim lLvColumnCount As Long...

Does Anyone know how to automate the export of a Crystal report to an excel file. E.g when the file is run it automatically exports the data to a file Thanks in advance

Problem: I am trying to count up the values in a column in a table. in Word and automatically display the result in another field Desired Process: Enter the hours worked in each row of the hours column. when the hours are entered the total should be displayed a another field underneath. I...

Ken, I did tried it without passing the parameter and it works fine. I reckon its the way i am passing it is incorrect, Thanks

Hi, I am stuck. I have created a stored procedure on SQL Server which accepts one parameter. I have then setup a Crystal report which reports from this Stored Procedure. In Visual basic, i want to Call this Crystal report and pass it the parameter it needs to return data. The following...

Thanks a Million

All, When i run the setup of my project that was made using the Package and Deployment Wizard i get the Following error. An error occurred while registering the file &quot;MSADO21.TLB&quot; The program then does not work correctly. I use the Data Designer on a SQL database (ADO) Basically...