Search results for query: *

Howdy! I have several reports which have this type of layout: RH - Has title and text PH - Has text, or may be supressed/hidden D - Hidden - no detail data RF1 - Subreport1 RF2 - Maybe 2nd Subreport RF3 - Maybe 3rd Subreport RF4 - Maybe 4th Subreport PF - Page Number - Report file name...

Environment: CE 10.0 Citrix/Windows Server 2003 VB6 SP 6 CR Viewer Control 9.0 I have a report created in the designer. One field is a long integer (example: 25200121). I create a formula field to check this value for 0. I print something different if it is zero (0). JobDisp...

Howdy, I have been asked to upgrade Excel 2000 to 2003 on my Citrix Servers. 70% of my company does not use Citrix during normal working hours. They use Excel 2000 from their local WS. 30% are remote users and use Citrix exclusively. Some of the 70% use Cirix from home. Finally, regardless of...

I want to reference a CR section similar to below: rpt.sections("Section1").reportobjects("Picture1")=loadpicture(strLogoFile) I am unclear how CR references the sections. Are they named in sequential order? Are they named "RH", "PH", "GH1"...? Appreciate the help.

I am writing a VB program to automatically export a crystal 10 report to a PDF file and then e-mail it. Life is wonderful until I execute the: .Export False I get an error message that says "Missing or out-of-date export dll. If I remove the 'False' argument, it prompts me for the...

I am creating a monthly report we send to our customers. I would like to add their logo to the page header. The report runs in batch mode (spits out one report per customer). Is there a way to change the picture during runtime? or, am I stuck with storing the image as a BLOB? If given a choice...

Howdy! I have a form with 7 datacombos, defined as an array. The form works fine for awhile, then all of the combos just quit working. The user can drop the list down and see the contents, but they cannot click and select anything. Also, they cannot type in the box to quick scroll through the...

Is there an issue with using a bit datatype for a selection criteria in CR 8.5? I do not remember using one before. But, I am doing it in this report. It works fine from within CR. But, when I launch it from VB6 I get an error "..False is an unknown column name". The VB code makes no reference...

Howdy! I have a form with a number of text boxes bound to an ADODC control. The form can be used for new entry, or for editing (depending on user selection). If it is new entry, the adoProject.Recordset.Addnew method is fired. I am getting the above error when that happens. The thing is, I can...

Howdy, I have a report which prints a billing detail within a date range. The main report prints rental billing info, the subreport prints sales billing info. They have different data sources (Sql Server Views). They are linked by CustomerNumber. Sometimes there will NOT be any data in the main...

I apologize in advance, but I cannot remember how to sum a text box. The text box is bound to a column located in a footer section. At the next footer, I want to sum them up =sum([text1]) - but that does not work =sum([text1].[value]) - does not work appreciate the answer

Howdy! I am constantly validiting data values in my code. Long ago, I wrote a function (below) which received the table, column, value and data type. It returns a boolean if the data does/does not exist. Works fine. However, I have never liked the fact I am passing the data type as a string...

Howdy, I want to pass a control as a parameter to a sub. For example: Private Sub ShowTotals (ctlTextBox as TextBox) as single ctlTextBox.Text = 125 * 10 End Sub Private Sub ShowStuff() ShowTotals (frmMain.txtTotals) End sub As written, this produces a type mismatch when 'ShowTotals' is...

Sorry folks, but I left my bigger brain at home today. Need help with the following problem. I need to write a SQL Statement that produces the results below. Actual data: PART LOOCATION QTY NEED BALANCE Wrench 125-A 11 3 8 Wrench 125-A 11 2 9...

I use the HeadClick event to sort data by the selected column. Works great. But, the Click event also fires. That is not so great. Also, click fires 1st, so I cannot add code to tell Click to relax if it was actually a headclick event. Right now, I am stuck with using dblClick which I prefer NOT...

Is there a way to update all ado recordsets connected to a resource when the data is updated, inserted, deleted, etc?

I sometimes use the ADODC control for binding data to AX controls. I am trying to make things more efficient, and only open the adodc recordset as needed. I want to first make sure what the .state property is at before I open/close it because someone thought that should be an error, instead of...

All of my users and I can create an ODBC link to a particular database, but only one can do so at a time. Anyone can create a new DSN, or use the one that is already there. After linking, everything works fine for them. But, everyone else gets an "ODBC - connection to <database> failed" error...

Can anyone recommend a flowcharting SDK that works easily with VB6?

I am trying to pass the reference to an ADODC control to a function. The control is on a form and the function is in a class mod. I can reuse this function code if I can make the ADODC variable (there are three different ones on different forms). For example: Public Function...