Recent content by alan92rttt

We use the 2nd one that Nigel posted works well. It has been updated since that link http://www.rcs-solutions.com/blog/2009/02/21/UpdatedVFPCalendarControl.aspx Alan

The excel date issue I normally have are on export. I could probably fix them by checking the date format and century settings. I found that its easier to just wrap the dates in a dtoc() when I generate the cursor and they end up as dates correctly in excel. I'd bet that the same would be true...

My thought on CSV was a XLS replacement so the lack of memo does not rule it out. I always had date "issues" even exporting to XLS. When I do VFP to Excel I always am running from a cursor and a preprocess the dates to some out right and if required add the memos via OLE. IF these are the...

I would think that making a CSV or dBase 3(can excel 2010 open that?)file rather than a XLS or XL5 file would solve the problem. It would require a small change to the open command but that should be minor. Alan

I've been playing a lot with vfp to excel recently. WHile "copy to" get a basic output to excel the users expect a bit more formatting than "copy to" supports. You can use a portion of what I've done to get a file into the current version. 1st I copy the data to excel using "copy to" and...

I think the solution is actually simple. Reviewing your comments and code it seems that case_id is a system generated key. If I am correct on these assumptions, the main problem is actually your insert. $sql3 = "INSERT INTO crt_case (case_id, case_no, cpt_no, crt_div) VALUES (''...

I've had this happen with labels when their are set to autosize. I'd gotten into the habit of: turn on autosize on to set the size then off. IN some cases the lable would still shift so I also shift the label back and forth by 1 pixel using the keyboard. Since I started doing this with...

Have you tried the dos level "START" command? Call it via the VFP run command. RUN start <clipper exe here> or !start <clipper exe here> Alan

Fox DOS can not talk to the sound card. It can only use the mother board speaker. Most new systems don't have come with a motherboard speaker and they don't bother sending something to the soundcard. I have seen some systems that have a bios setting to redirect that sound to the soundcard...

The simple solution is to get the full adobe acrobat. When you have that any report can be printed to PDF all you need to do is set the printer to the Adobe PDF printer or change your default printer. Alan

You could use a row source type of SQL Statment and constrict your data in the sql. select substr(mycolumn,1,50) as desc, key, other info from mytable ..... Alan

Their are several pieces of software that can do that for you. If you use installshield to install your application on end users systems you can also use install shield to create a patch. I've also looked at a program called RTpatch. it does a good job a making a small program that can...

Is their any reason rowsourcetype 7 (files) won't do the job? If you want to use a folder other then the current folder just put the path name in the rowsource property. Alan

If you have an existing index on that column you could just use the set order command to tell VFP to use that index in descending order. set order to myTag descending Copyed from the VFP help SET ORDER TO [nIndexNumber | IDXIndexFileName | [TAG] TagName [OF CDXFileName] [IN nWorkArea |...

I agree with Mike, I can not see anything wrong based on what you've posted. Alan