Search results for query: *

Hi, Yes I do get an option to connect thru odbc. Just doesn't look like there's an easy way to do this other than adding a the SQL database and removing the Access database at least I retain the formulas. I'll keep reviewing the responses then take this approuch if necessary. Thank you all...

Hi, After clicking 'Set Location': 1. a list of tables 2. the set location button 3. the same as report button 4. the done button 5. the help button If I click on the 'Set Location' button the 'Choose database' window displays with the following options: 1. the ok button 2. the cancel...

Sorry Turkbear, I don't see 'Create New Datasource' when going through the 'Set Location' screens. Is it because I'm using Crystal 4.6.1.0? Thank you

Thank you synapsevampire, Forgive my ignorance, I am currently pointing to a network drive and to the database mydb.mdb and would like to re-set the location to SQL Server mydb but I can't see a way to do this through the 'Set Location' option. I must be overlooking something....Thank you...

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.

Thank you Swi that did the trick. Learning something new everyday..

Thank you for the information but it doesn't work with the 'Get #1, lngRec_Loc, strInput' because strInput is now an Array. The reason I'm doing this is to retain the nulls in the record coming from file #1. I want a 2000 (not always, this will be a general purpose pgm to read diff. fixed...

I am performing the following to replace nulls to spaces in a text file. If I use 'Line Input #1, strInput' the nulls are stripped and the fixed record size is reduced by the number of nulls. I am parsing the text file records, code not shown. ===============================================...

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.

The following may help. rs.Index = "codephoto" rs.Seek "=", codephoto_1, codephoto_2 if rs.NoMatch then ' Not found - do whatever end if

Eval may fit your needs. Note: You must have Project reference to MS Access Library.

You could try: If rs("xrefnum") = Empty Then strInfo = "Missing UPC" End If ' OR If rs("xrefnum") & "" = Empty Then strInfo = "Missing UPC" End If 'OR If len(rs("xrefnum") & "") = 0 Then strInfo = "Missing UPC" End If

Thank you Chiph, that looks like a better way of retrieving information.

Thank you for your reply DrJavaJoe, I found a method that will do the trick. Don't know if this will help anyone but I have posted it for reference. GobjRs_Archive.Open "select name from sysobjects where xtype = 'U'", GobjConn, adOpenStatic, adLockPessimistic For intI = 0 To...

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...

Thank you...that answered my question.

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.

Thank you 'experts'. bjd4jc, found that by using the error handler in the datagrid error event did the trick. Thanks again all...