Search results for query: *

I want to thank you all for your contributions to this thread. While the solutions presented didn't work for my situation (Crystal XI R2 connecting to a DB2 database using Client Access ODBC drivers) I was able to come up with an alternative. For anyone else who has the same setup I do, here's...

You may have already checked this, but could it be a problem with the selected .dll files in VB6? (Tools/References) I'm only basing this suggestion on the headaches I've experienced with VBA/Access 2000 regarding having the correct libraries selected and in the correct order of precedence. dw

Ok, let me first warn you that I use CR8 and I'm unfamiliar with the differences between CR8 and CR9. Next, you mention "how can I actually put a field in the table (or get the query to generate it)". Being a data dipper, Crystal Reports will not place information into your data...

You could also create a variable to do your summary then display that variable's value at the end of your report. Here's an example: Assume the formula you want to summarize is MyFormula We'll name the variable SumOfMyFormula You need to create another formula that will reside in the same...

Naith has the correct method for obtaining the blank values in the Courses table. To elaborate on Naith's response, I'd create a report that generates a letter to all schools of the type you're interested in then supress the letter where "Not IsNull({Courses.Field})" dw

That did it! Thanks vb5prgrmr!

Thanks for the response! I went a little further and actually copy/pasted the following code in an effort to test my theory: <Begin Code> Sub OpenDatabaseTest() Dim wsODBC As DAO.Workspace Dim db As DAO.Database ' ' Create the ODBCDirect workspace ' Set wsODBC =...

Hello Everyone, I suspect I'm trying to accomplish something which is not supported by the version of Office / VBA that I'm currently using. Here's the details: Office Version: 2000 Professional SP-2 VBA Version: 6.0.8435 I'm trying to create an ODBC connection in VBA in order to...

Ok, here's something odd. I'm trying to write a query that accesses a DB2 database on an AS400. I'm connecting via ODBC just fine, but the admins for the AS400 have set a time limit of 1200 on all queries (to keep users from overloading the system). I've built a query that runs off a HUGE table...

Ok, as luck would have it, I discovered the solution not long after posting my original question. Here's what I found: http://kb.corel.com/kbdocs/paradox/PX70WIN/PX70WIN_10770.htm This page details the steps for setting up Paradox to work with ODBC connections. My problem was I was confusing...

Howdy everyone, After looking through this forum I haven't seen a clear answer to the question of connecting to a database via ODBC. Posts like the following... thread177-75168 ...seem to indicate that it's easy to connect to another database using ODBC & the BDE, but I'm still...