Search results for query: *

Hi all, I hope someone can help me. We have developed a VFP app to read accounting files using the vendor's ODBC driver. There is no support for this driver now :(. The vendor's files use a Faircom c-tree database. A client wishes to migrate to 2016 server. In testing, we found that our app...

Hi, I'm attempting to create a pivot table using a list table as the datasource, and if I filter the source table, then I would like the pivot table to reflect the same filter. My thinking is that the source range is defined as visible cells only. Code fragments: Create dynamic range (to...

Hi: As a general observaton I'd say addresses cause more coding trouble than any other piece of data...here's my current issue. I have an address table which can contain up to 5 addresses per customer. The address table has a location field (1 = mailing, 2 = street, etc. I want to select...

I'm developing a routine to group sales transactions by week numbers, and then group those into reporting months on qa 4-4-5 basis. 1st problem: given a date value, how would I find the nearest Saturday? so: ldDate1 = ctod("31/03/2008") ldSaturday = ????? Regards Mike

Hi, a client is experiencing what appear to be random data changes to stored data, even after going through their entire data table manually and saving every change. The particular field is custom-labelled, but the underlying name doesn't change. Can anyone offer pointers as to why this...

Hi: I'm using VFP to send mail via Outlook, and for testing purposes I'm including the .DeferredDeliveryTime parameter using (eg)= “29/09/2006 17:00”. Sadly this did not work, and the mail got sent immediately, much to my embarrassment! (using Outlook 2003). So: With oMailitem ...

I'm sure I've seen an example of this on the forum, but couldn't locate it. I have: select ; s.cardrecordid, ; S.invoicenumber, ; S.Date, ; (S.totallines + S.totaltax) as invtotal, ; S.Outstandingbalance ; from sales as S ; left outer join cards as C ; on S.cardrecordid = C.cardrecordid ...

Hi I'm using xfrx within a VFP9 report-writer to send a report to pdf. All other reports work fine; yesterday I tried a multiple detail band report, which previewed and printed correctly, but sends blank pages to Excel or pdf. The only report-specific code (apart from index creation) to...

I have a csv file which includes dates in the above format. How should I read/convert it into a date field? Regards Mike

I'm preparing an invoice form in report layout (vfp9). The layout is deceptively simple. I have to set a standard depth for the detail section, to accomodate a graphic, but the detail section should normally only be one line deep. Thus far I'm getting a variable depth, acc to the # of...

Hi: I have written some custom functions in Excel VBA to read a VFP database, which I have saved as an .XLA file. For various reasons, I now want to convert this code to a VFP DLL. My question is not about converting the code; what I need are some guidelines, links, suggestions if possible...

Hi all; this question could only come from an accountant/excel user...(and VFP novice) Is there a way to format a number in report layout to the above, *and* have all the positive and negative numbers line up, like the excel format [($999,999.99_);($999,999.99)] (the '_)' shifts the positive...

Hi Given: table1.financialyear eg 2005 (the year ending in ....) table1.lastmonthofyear eg 6 (= June) and table2.date eg 01/07/2005 (dd/mm/yyyy) how can I calculate the financial year of the date eg with the above 01/06/2005 = 1st June 2005 = 2005 year 01/07/2005 = 1st July 2005 = 2006...