Search results for query: *

Hello, This might sound very basic but I don't seem to find my way around to modify the ADO connection string at runtime. The development folder structure is different to the production folder structure. How can I go about modifying ADO connection string at runtime e.g. to point to...

Hello Laters, Z I am aware of the situation with numbers but stragely this is happening with text. Further experiment has shown that if the text width is within the width of the cell then it displays OK but if the cell width is less than the text width then I get ###########. In other words...

Hello, This behavior is quite strange. In one of the cells of a spreadsheet when I type any text, I get ########### displayed when I move out of that cell. If I change the cell format to "General" from "Text" then the text appears correctly. What could be the reason? Thanks for any help...

Hello, I need to join two tables (tb1 and tb2) which are in two different databases on the same server (db1 and db2). What is the best way to do it. Thanks for any help provided. Rizwan.

Well, I did not receive any reply but then played around a bit to find out that the only probable solution is to make a reference to each table used in report. This way you can change the recordset of any table you wish. I experimented only with CR8 and it worked fine, but, of course if you...

I am using CR8 and VB6 to pass an ADO recordset to a report created using RDC. If my report has only one table then there is no problem and the following code works perfectly: ..... ..... myrs.open "Select * from MyTable WHERE Myfield='abc'", mycon set crDbtables = crDatabase.Tables...

I am using CR8 and VB6 to pass an ADO recordset to a report created using RDC. If my report has only one table then there is no problem and the following code works perfectly: ..... ..... myrs.open "Select * from MyTable WHERE Myfield='abc'", mycon set crDbtables = crDatabase.Tables...

I am using VB6 SP5 and CR8 Developer Edition and the RDC. I am making a record selection formula from a form which has a DataGrid and the Pr_Id field of the currently selected record should become the recordselectionformula. The CRViewer is on another form (Form2) so I have to use...

Hi all, I am using VB6 SP5 and CR7 to print a list of countries from a table COUNTRIES in a database MYDB in Access 97. The table has just one field C_NAME and each country name is a separate record. I want the printed output to be as follows: Argentina, Afghanistan, Angola, Bahrain...

Hello, I am using VB6 and CR7. The question might seem very basic but I am not able to achieve the following: The reporting of a list of coutries appears as... Argentina Brazil Chile El Salvador .... I want it to appear as.... Argentina, Brazil, Chile, El Salvador, ..... How can that be...

Thanks Marc, Your tip did the trick. Rizwan.

Hello, I am using VB6 and CR7 to create a project profile report which reports data from 12 tables in an Access 97 database containing linked information about projects. I have 4 subreports on the main report layed out on top of each other. What happens is that if one of the sub-reports has...