Search:

I saw the code snippet that you referenced, specifically



Dim crDBTab As CRAXDRT.DatabaseTable

For Each crDBTab In crReport.Database.Tables
crDBTab.SetLogOnInfo strSrv, strDB,...

Thanks JG. This issue has been a challenge. Although the workaround of passing the client data to the report works I would like to find amore proper solution as this will tell me what "invalid"...

Thanks JG. I'll test the code snippet that you referenced and post a follow up. Regards, SGarv

As an update. I was not able to resolve this issue. As best as I could conclude, the problem arises when the report internally uses a table that points to a specific server, but the log on...

As a follow up to my initial post I'll add that I was unable to resolve the issue. I found no way to specify the same server/database for the table used within the report and the data source that I...

Here is one possible way to do it. Please note that this code is untested, as I do not have the tables and data that you have. I am sure that you can adapt and debug it to your needs.

From the...

The short answer to your question whether you can do this without the intermediary temp table is Yes, you can :-)

I have some remarks about your code. I hope you are not bothered by them.

The...

Hi all,
I have yet another question. I have been struggling to get a report which contains two identical subreports to work. CR9 was producing an internal query engine error. I determined that this...

Here is another way:

http://www.xtremevbtalk.com/archive/index.php/t-203255.html

If using VB6 the App object has a PrevInstance property. I seem to recall that this method did not work for...

If I understand correctly, what you are saying is that the "modal" form displays, but you are still able to open/close/use other applications that are installed on your computer.

If so, this is...

Hi all,

I was charged with getting an old report to work when the database was moved to the new database servers. I documented everything in this post:
...

Again, thanks to all that took the time to read the original post. After much research and experimentation I can say that I resolved all the problems I had. The solutions are documented here for...

Follow up. One small step...

I did more research and found various options. One item where I had doubt was the connection information for the report. To see what I had in there I added this code
...

Hi all. Thank you for taking a look at this. I apologize for the sheer size of the post. I tried to keep it as short as I could. I inherited a legacy report built using CR9. An application written in...

I Googled putty scripting and got a few results. Perhaps one of them can help achieve what you are trying to do. Regards

Understood. I thought this was in reference to VB6. Sgarv

No, like this:




'Way at top of code module of form.
Option Explicit

'Form's (or module's) declaration section
Private intCount As Integer

For posterity?



Dim colNXS as Collection


set colNXS = new collection

'Work with collection

Does LIKE work with numeric fields? If I recall, LIKE is for matching text fields.

Regards, SGarv

There are ways to create a delay, I can think of two:

The old brute force method:

Dim dateFut as date


Mscomm1.output = chr(2) & "C_1" & chr(3) & chr(2) & "P_1" & chr(3) & chr(2) & "X_1" &...

I had a look at your code and it is somewhat complex. Let me ask you a few questions to try and break down the issues that you are having.

1. From looking at the form that you sent, I assume that...

Change dim ss as string to dim ss as integer


Change

If FExist(path) Then
Open path For Output As #ss

to

Just as a quick note. the FM20*.dll is not freely redistributable with our applications. The only way to do this correctly is to first (download and) install the ActiveX Control Pad and then the...

Using the immediate window I get:

? int(23.214)
23

? int(-23.214)
-24

If you need your result to be positive (absolute number) then use abs() function to get final result:

Hi all,

I just joined this forum and this is my first post. I consider myself experienced in VB6, but I have a problem which is driving me up the wall and I ask for Other Eyes to have a look and...