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 Chriss Miller 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: *

  1. johann59

    Scan folder and files

    Are there functions in VFP 9 that would allow me to: -Scan a specific folder at certain time intervals (let's say at 1 hour intervals) for files (Excel/Text, etc. files) that are dropped in that folder. That folder would usually be empty and the program would check it every hour it would scan...
  2. johann59

    Syntax to create cursor from 2 tables

    Thanks Mark, but I have a 70,000 record table to match against the 8000 duplicates. How can I programmatically match the two tables? Using the INSERT will not work with that big of a table. And that is on me, I did not say at the beginning the amount of records that I had. Sorry for that.
  3. johann59

    Syntax to create cursor from 2 tables

    I need to write a SQL statement that can merge duplicate field(s) and create single records into a Cursor For example: Table1 (Main) First,Last,Name,Address,City,State,ZipCode 1. Winston,Smith,Winston Smith,123 Anywhere St,Chicago,IL,60601 2. Andrea,Lopez,Andrea Lopez,235 N...
  4. johann59

    VFP and Google Web service

    You're right Mike. Sorry about my lack of knowledge in respect to the use of 'Google Maps API'. My mistake. Did not think this all the way through. I just read the terms of service and it does say: Users of the standard API: -2,500 free requests per day, calculated as the sum of client-side...
  5. johann59

    VFP and Google Web service

    Thanks Mike & JRB for the advice, and specially to atlopes. Found the code useful and will try and incorporate it to what I finally plan to do. Another step in my learning process. Thank you very much. Mike, we do have a geo-coding software. We use it to code several thousands of records, but...
  6. johann59

    VFP and Google Web service

    I need some advice. I'm using VFP 9. I have a list that contains US addresses. Want to be able somehow to run those addresses through a Google search and have Google return the correct addresses. Most of the time those addresses have misspellings. Examples: a) 123 Any Steet, Anytown CA 90000...
  7. johann59

    Copy cells from 1 table to another using an array?

    Thanks Olaf. I just keep on learning. I appreciate your post.
  8. johann59

    Copy cells from 1 table to another using an array?

    Hi Tamar. I mean once I have the table F1 completed, I will use the 'Report Writer', a program that handles the printing, to create specific reports that have the Code, and the corresponding quantities. Each report (page) cannot have more than 100 pieces, Even if the remainder is a single piece...
  9. johann59

    Copy cells from 1 table to another using an array?

    ...INTO F1(qty) VALUES (array1(1,5)) INSERT INTO F1(qty) VALUES (array1(1,6)) ... I'm thinking of checking empty elements with IF EMPTY(array1(1,8)) ***code ENDIF But how do I tie all of it? 2. Is it better to use a FOR...LOOP along with SCATTER & GATHER? Never have used these commands, but I...
  10. johann59

    Geocoding API to get latitude and longitude using address

    Maybe this can help: ** Longitude and Latitude from Address String ** Copyright 2013 Craig Boyd *!* Getting the Longitude and Latitude for an Address *!* Just finished answering a question out on UniversalThread regarding how to get *!* the Longitude and Latitude from an address. Following...
  11. johann59

    Import excel sheet to foxpro table?

    One small tip. If original Excel 2007 contains more than 65,536 records, better to save to a .csv file, otherwise you'll truncate the remaining records. Johann
  12. johann59

    Print a report based on a field value

    Duane, I do have a primary key, and if there is more than 1 match, I have the name, address, city, st, zip and account appear in the ListBox, so the user can select the appropriate name. I will go with your suggestion and try that out, although you still left me wondering if I could kind of...
  13. johann59

    Print a report based on a field value

    Thanks Duane for your answers, 1 Form called Form1 1 Query caled Query1 1 ListBox called LB1 # Buttons and labels 1 Table called Table1 with 200,000 records Table has 10 fields: Field1, Last, First, Address, City, St, etc Field1 ONLY contains a value of either an "A" or a "B" for each of the...
  14. johann59

    Print a report based on a field value

    Duane, or anybody, if I could as well bother you with a 'DUMB' question, is the Visual Basic code behind both Access (2007 & 2010) based on VB6, VB.NET or just another subset called VBA? It does not seem to be VB.NET. Thanks,
  15. johann59

    Print a report based on a field value

    You're right. I'm missing information on my problem. Yes, table1 has approx 200,000 records, but all the records have a value of either "A" or "B" in field1. The form has a 'Search' text box, where the user enters the name of a person, and then the user can press the 'Preview' button. So far...
  16. johann59

    Print a report based on a field value

    I'm kind of new in regards to working with Access. I've worked mostly with Visual FoxPro, but they wanted this project done in Access, so... I'm about finished with a project done in Access 2007. The only issue I'm having is coming with the code to print a report based on a value in a field...
  17. johann59

    255 field limit - How to import a file with more than 255 fields?

    Hi Dave, My main tool I work with is Visual FoxPro and 90% of the files I have to process come in an Excel format, so I'm just going to put out there my 2 cents. If this is a one time deal, could you bring those records into excel and then just delete the columns that you do not need? There is...
  18. johann59

    New PDF-Excel project using VB 2008

    Hi, I'm not as familiar with VB as I would like to. All my projects that I've built in the past and my programming skills are more oriented to Visual FoxPro, but my boss insists that this new project be built using VB 2008. I have to use a mailing list of approx 100,000 records (Students)...
  19. johann59

    Alphanumeric sequence

    Thank you VERY much to MrDataGuy & Olaf. I was able to do exactly what our client needed. This forum rocks! I'm guessing the reason of why they wanted this kind of sequence is for a mailing they're doing. I assume some type of ID. We are embedding this number in a QR barcode. Again, thanks.
  20. johann59

    Alphanumeric sequence

    I'm trying to create an alphanumeric sequence. I have a single table with 200,000 records. I want to add a alphanumeric sequence consisting of no more than 3 alpha characters and 4 numeric characters. I've searched the forum to see if I could find something in that regards but I couldn't...

Part and Inventory Search

Back
Top