Search results for query: *

Hi all, I've run into a problem with a multivalue string parameter that feeds to a stored proc via SSRS 2005 in that if I choose All from the drop down then I only get partial results (up to letter G ). I have calculated the length of the parameters to be about 1750 characters plus commas. If...

Have you set the report language to be English(United Kingdom) , I think sp2 is crucial here too. Otherwise convert all your dates to the same locale format in the dataset using convert. W

Dear all I have had to migrate an Access 97 database application from one NT4 SP6 machine that has Visual studio installed on it, to another machine of the same build but without Visual Studio. The trouble is now I have moved the app, it no longer runs and it seems to fall over on a reference...

Using Excel 97 I have 2 worksheets. In worksheet1 I have sales data. In worksheet2 I have expected sales data. The structures of the Worksheets are the same. So I need to move from cell to cell in each worksheet and compare the values. So if anyone has any code to do something similiar Id...

Hey Dragon55, There is another option you can add which is the adCmdText option which you place last after the locktype and cursor type try it and see if it helps it should make a difference. Enjoy Will

Hey VB400,<br><br>Yep I went and got myself certified, Im based in the UK so I dont know if this is relevant to you. In my experience becoming certified doesn't automatically mean you'll earn more but it does open a lot more doors for interviews which in itself means you can raise what you...

Check out the Data Definition File in the helpfiles. I use these to create one report and then I use it on my local Access DB and SQL7 and Oracle8i across a network.

When you design the report use a Data definition file, this is a template of the data that you want to use in the report and is not dependent on the the database location, you could take the data from any type of db (access, Oracle, SQL). TO add a DDF follow the folowing in the designer window...

Dear All as a complete newbie to crystal reports 6 in VB6 can you please help.<br><br>I need to have 4 subreports of completely unrelated data on a single report (bloody management).<br><br>I use data definition files to design the data expected by my reports as the user can choose different...

hi Frank all you need to do is to create the database (I'll use DAO as its Access)&nbsp;&nbsp;object and&nbsp;&nbsp;use<br>a normal SQL script to create the table and then using the tabledef object set the various field <br>properties such as AllowZeroLength and DefaultValue<br><br>Dim...

If the problem is you cant open the connection to a password protected database, make sure you add the database password argument to the connection string.<br><br>DIM ADODBConnection as ADODB.Connection<br>DIM rs as ADODB.Recordset<br>DIM sSQL as String&nbsp;&nbsp;<br><br>SET ADODBConnection =...