Search results for query: *

Hi, What's the trick, if any, to setting the location of my Access 97 table in Crystal reports 4.6 to a SQL Server table? The only way that I can see is to re-write the report using ODBC to SQL Server. I also posted this ques. in 'Business Objects: Crystal Reports 2 Data Access', but did...

Hi, What's the trick, if any, to setting the location of my Access 97 table in Crystal reports 4.6 to a SQL Server table? The only way that I can see is to re-write the report using ODBC to SQL Server. Thank you for you help.

Hello, Is there a way to dimension a string length using a variable. Ex: Dim strInput as String * 2000 >>Would like to get the same result as above using: Dim strInput as String * intLength >>I know VB6 requires a constant but is there a way to set the length of 'strInput' using a variable...

Can someone please explain to me why a varable defined as single with a decimal * 100 comes out as a fraction? sample: dim sngx as single sngx = 8.40 debug.print sngx * 100 ' results in 839.9999 Why doesn't it result to 840? I'm probably the only one who is missing something here.

Hello, I have been able to retrieve Access database table names but want to be able to do it on an SQL database. The code I use for Access is: Set db = OpenDatabase(MyDatabaseName) For intI = 0 To db.Containers("Tables").Documents.Count - 1 If...

Normally after creating a package with the 'Package and Deployment Wizard' I perform the installation on the PCs that will be using the application. Rather than installing the package on each PC can I install the package on a server and have the PCs execute from the server? Thanks for your help.

Is there a way to intercept constraint and/or trigger messages before it is displayed to the user. Example: Oracle Database field Last_Name Varchar2(25) Not Null. The user leaves the row before entering the Last_Name. In this case I would like to replace the constraint message displayed...

I am trying to export a Crystal report ver 4.6 to excel but keep ending up with extra columns and shifting header columns. Is this a version bug? Any help is appreciated. Thank you, moki

Anyone out there have a routine to unpack and pack comp-3 EBCDIC fields. I am trying to limit the modification required on our mainframe by FTPing mainframe files containing packed decimal fields by unpacking them via a VB6 project. Currently, to read mainframe data with packed decimal fields...

Hello out there, I have a vb6 form with 3 Datagrids bound to 3 ADO ctl. and want to reduce the number of connections from 3 to 1. Can someone provide a runtime example? Thank you.