Search results for query: *

Personally, I don't understand what the problem is. The record cannot be found? The form doesn't show result if the record has been found?

Get CutePDF, it's free, services as a printer and you will not have any problems. We used it all the time

We use textreport class library, my former manager found a long time ago. At that time our clients used DotMatrix reports heavily. This class is awesome, you can print any text you want and customize it. All our FoxPro laser reports have an instance of this class if the user selects to print to...

We convert DATETIME() to a character and add that to the file name so that has some kind of meaning.

Hello, like I said, it's your app, you can design it any way you want. I was just saying that normally you don't use combobox, if the user need to chose from more than 20-30 records. As far as views, I write my own SQL views statements, meaning I do not use FoxPro view wizard. We still use...

You c an design your forms any way you want but, in my opinion: 1. I would never use tables as a source for anything, only views. They can be open exactly the same way as tables can but it much safer than to use tables directly. 2. 2000 records in the combobox???? Have you try to pick a record...

Yes, this is he way we do it as well: using views mostly but sometimes cursors to drive a combobox

Not my code but check the VALID() in the LostFocus() is a bit weird, I don't think you need it. If VALID() = .F., the cursor will never get into the LostFocus() anyway

Yes, that is all correct. Valid() is better but LostFocus() will work as well. I think the problem with the original code is that there is no test at all. And, yes, IF EMPTY() without CTOD() should work fine. Another issue I can see with all that is that returning .F. from either method will...

Like other said, use VALID() instead, check if the field is blank there and if it is, use NODEFAULT()

OK, I am not sure adding some blank records to the dataset that drives the report will work as, if I understand correctly, there could be unlimited(theoretically) number of lines per invoice. If you have an item description on the invoice too long for the report control, that control could be...

Can't you just create a bunch of controls in the detail section of the report and add a condition when to print, like PrintWhen lineCnt = 1, 2 ,3 and so on. Or Invoice Detail line, whatever. We have quite a few similar reports to print Utility bills, Invoices etc. Each Invoice have a header and...

Hello, I agree with Mike that it's much better to recreate the cursor based on the different selections. We have the same forms with grids driven by the view and we requery the view is the user selects different prompts. SET FILTER hides the rest of the records and you can't see those records in...

It seems to me that you are over complicating this process. We have a similar behavior on pretty much every maintenance form we have, whcih is a lot but we are using PageFrame with 2 pages(actually, we have more than 2 pages but , anyway). You select the record on the first page that has a grid...

Agreed

Hello, I have a situation when I need to format Excel file column(file created programmatically with Excel object) that contains Social Security numbers to be right justified. The problem I have is with SSN with leading zero(s). They are coming out left justified. Ideally I would like to...