Recent content by johann59

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

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.

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

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

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

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

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

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

From the beautiful land of Southern California! I've been looking into previous posts, but have been unable to find some code. I need help figuring out this problem. My main goal is to transfer data from 1 table (T1) into another table (F1). A client gives me a file with codes and the quantities...

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

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

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

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

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,

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