Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: mikeopolo
  • Content: Threads
  • Order by date
  1. mikeopolo

    ODBC read on 2016 server is very slow

    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...
  2. mikeopolo

    Synchronise pivot table with filtered list table as source (Excel automation)

    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...
  3. mikeopolo

    How to select nth (or below) address record

    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...
  4. mikeopolo

    Find nearest day of week

    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
  5. mikeopolo

    Random data changes VFP database on W2000 server

    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...
  6. mikeopolo

    Deferred mail send via Outlook not working

    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 ...
  7. mikeopolo

    Select top n records per customer?

    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 ...
  8. mikeopolo

    xfrx to pdf with multi-detail band report - blank pages

    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...
  9. mikeopolo

    How to read 31-Mar-2006

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

    Invoice form with standard depth for details?

    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...
  11. mikeopolo

    How to create VFP DLL and call from Excel with VBA

    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...
  12. mikeopolo

    How to format a number like ($999,999.99)

    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...
  13. mikeopolo

    From a date, derive which financial year it is in

    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...

Part and Inventory Search

Back
Top