Search results for query: *

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

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

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

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

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

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

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.

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