Search results for query: *

Hello, Have you already tried the iif function. for example iif(table.a,"yes","no") FILIP MERLIER

thanks stefan this is just what I needed. i'll give you a star for it filip merlier

hello guys, i'am working with vfp7 sp1. To find a week from a date is very easy with the week() function. Is there also an easy way to find the date of a week. For example week 32 should give me the first date of that week namely 02/08/2004 in dmy format Any help is usefull Filip Merlier Belgium

Hello Mike, I did not know how easy things could be. I'll give you a star for it. It helps me a lot in my projects because this opens my view about the possiblity of the combo boxes. FILIP MERLIER

Hey Rick, The variable is a public variable. All I want to do is put in a manual text which is not in the array. Are there some opportunities ? FILIP

Hi Guys, It is probably not a difficult question, but I never did this before. I have a form with a combo box. The rowsourcetype is an array which I fill up in the load of the form. The style property is dropdown combo. The control source is a memory variable(characters 50 length) this variable...

hey, if the combobox is in a form just put the method style in te layout department on dropdownlist i hope this is usefull to you wmg, FILIP MERLIER

hello bigdavidt, have you already tried thisform.pageframe1.activepage=2 thisform.pageframe1.page2.refresh

Dear Mike, I convert my report to a pdf file and then send it to the printer winfax. I want to know how to fill in automatically the phone number and the company name. I didn't found much on the net. So any starting code or suggestions would be very appreciated. Filip Merlier

Dear colleges, Has anyone already made a program in vfp sending a fax from a crystal report seding it with winfaxpro 10.0 Any help would be appreciated. FILIP MERLIER

Hi Guys, My boss has a new toy, namely me. I make offers in vfp7 and make de report with crystal reports. Then I send the PDF or word file like this : m.xxattach="c:\foxprow\"+ALLTRIM(m.ccklant)+ALLTRIM(STR(m.ccbonnr,10,0))+".PDF" xxattach=m.xxattach oCRApp =...

Thank you Mike, This works fine. But In the other tip it was something with setting a font to courier new length 10 or something like that. I don't know wthat this set display to vga50 does for my other programs. Can it harm something ? Wfg, FILIP MERLIER

Dear Guys, Last week somebody asked the same question as I will ask now. I searched on the tips but I cannot find it anymore. The question in fox2.6 when you say display struc to printer prompt everything is on one line. In the tip there was an answer to do this also in vfp7.0...

Dear Experts, I have a form in which a have a crystal report in which a make a pdf file. code is : oCRApp = CREATEOBJECT("crystalruntime.application") oRep = oCRApp.OpenReport("offerte.rpt") oExport = oRep.Exportoptions() oExport.Destinationtype = 1 oExport.FormatType...

Hello Experts, I finally got it right to make crystal reports, gave a good preview, can export it to any printer(in the preview), ... So far so good. I have 2 questions now. 1)How do I send the report to a specific printer (all the printers are installed on the server (program ms server 2000)...

Dear Colleges, I finally got to run crystal reports 8.5 in my vfp7.0 sp1 application. I have still one problem. I make an sql statement for printing invoices or .... For example : client 1 has invoice nr 100 and need 3 prints client 2 has invoice nr 101 and need 5 prints ...... I saw a code...

Hello Craig, Another little question, When I make my report with odbc in crystal design, how can I use them in a formset toolbar if You say i better not use ODBC. It is necessary to make a form for every preview ? I think I am asking silly questions but I don't know any better for the moment...

Hi Smart Guys, about thread184-748134 i put on tek-tips. I'm still not reaching what I want. It is working fine(printing) when I copy my file to a foxplus type. otherwise I get an ODBC error. I would really want to work with the visual file types. My code in vfp7.0 sp1 is : oCRApp =...

Hi, The connection goes through an odbc for visual foxpro (so no odbc text driver) using foxpro 7.0 and cr 8.5

hello guys, I have a formset with a print function. When i push the print buttom i get the following code : My code is oCRApp = createobject("crystal.crpe.application") oRep = oCRApp.OpenReport("g:\develop\rap.rpt") oRep.Preview I get the following error : Ole...