Search results for query: *

I have a form that shows claim information. I have a command button on that form that by clicking will(should) create a new record based on the information in the current record. * CMDADDSUBCLAIMA.CLICK * * Add a new Sub Claim * Get next sub number for this claim Select claims2 Store 0 to...

I have 3 files linked. Clm, trans, and (Alias clm ) clm is linked left outer to trans by clm.fld and clm.fld2 Clm is linked to itself by Clm.fld (this way I can get all of the clm.fld2 fields. Detail prints as follows: Clm.fld Clm.fld2 Trans.fld Clm(alias)fld2 3456701 00...

The import wizard allows you to change column headings field length etc,.. Is there any way to save those setting for future imports? or somehow view the code neccessary to acccomplish the same thing in a program? I would rather not use the wizard.

I want to be able to import a lotus worksheet to a free table. I want to be able to use a windows explorer type dialog box to locate the file I want to import click on the file so that the import can do its stuff. Any thoughts or examples would be appreciated. Using VFP 8

Is there a way to include the actual record numbers from a VFP table into a crystal 8.5 report? Thank you

Anyone aware of how to append only unique records to a file?

Every time I refresh my report I get a different grandtotal. Anyone ever come across this one? left outer table connection, simple report using a foxpro db (ODBC)

How do I format a field for inputing of time values of minutes, seconds and out to one-hundreths of a second? mm:ss.nn

The vertical & horizontal scroll bars that show with every form in edit mode does not increment properly. Moving the block half way down does not change the screen at all. If I click on the bottom arrow it goes down the form halfway. Is there a setting that I am missing?

I maintain a web page and something strange has happened. Upon publishing my pages I called up the url in IE6 the page came up but there were items missing (clickable tabs near the top. Other page content did display above)from my view there was not even an "X" It was like I designed...

I maintain a web page and something strange happened. Upon publishing my pages I called up the url in IE6 the page came up but there were items missing from my view (clickable tabs across the top) I called someone to view the page on their pc and the page looked fine. I had them verify to...

What comma did I miss in the IFF expression? sum(Ledger.osexp + ledger.osloss)AS totalos,; IIF((substr(clms.claimant,1,3)<>&quot;AGG&quot;),&quot;AGG&quot; as clmtprefix; FROM mrcdata!clms left outer JOIN mrcdata!Ledger; Program error : Missing comma(,)

I have Crystal 8.5 installed on my pc. When I open a particular report with crystal a formula that I have which strings 2 numeric field together displays as 3000370-00 If i call the report with visual basic 6.0 the field prints out as 3,000,370-00. Whats up? both run from same workstation VB6...

When the code below executes I would like to hide all other forms and throw a form up with the name of the current report that is printing displayed with maybe a hour glass that shows that something is happening or at least display the report name in the &quot;printing records box&quot;. I will...

I would like to print a series of Crystal reports, all of which use the same report parameter, &quot;?bookto&quot; How do I prompt the user once for the string and use it as the value for all? CrxReport.ParameterFields.GetItemByName(&quot;BOOKTO&quot;).AddCurrentValue = (YYYMM from user)...

Is there a way to supply a value for a specific parameter by parm name instead of Parameterfields(1)? I have a list of quarterly reports that use either {?bookto} or {?bookfrom}to {?bookto} I would like to supply both values up front Dim appl As New CRAXDRT.Application Dim rep As...

I would like to put a command button on a form and on click event go to a specific web page to check some exchange rates then return back to form after closing IE Thanks

Something weird going on with Crystal reports call with VFP. Reports that were defined as landscape are reverting back to portrait. Is there a way to add code to assure a landscape orientation? oCRapp = createobject(&quot;crystal.crpe.application&quot;) oRep =...

I would like to export a crystal report to a folder using vfp6.0 from VFP application to a pdf file. can it be done within this code? oCRApp = createobject(&quot;crystal.crpe.application&quot;) oRep = oCRApp.openreport(&quot;k:\vfp\reinsurance\reports\31pf.rpt&quot;) oRep.Printout(.F.)...

I am trying to create a summary file from 2 files(parent/child) select pf245.pc, pf245.st, pf245.lob, sum(pf245.lr) as LR1, sum(pf245.lx) as LX1,; sum(dirsum.lr)as LR,; sum(dirsum.lx)as LX,; sum(dirsum.pw)as PW,; sum(dirsum.lp)as LP,; sum(dirsum.le)as LE; From MRCDATA!pf245 left outer join...