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

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

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

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

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

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

Hi all. I have 2 tables and I'm using VFP 9. Tbl1 fields/records name1, naddress, nlatitude, nlongitude, etc name2, naddress, nlatitude, nlongitude, etc Tbl2 fields/records StoreName1, sAddress, slatitude, slongitude, etc StoreName2, sAddress, slatitude, slongitude, etc I want to find up to...

Can somebody guide me on how to display the fields from a specific table into a ListBox? Basically I want the user to be able to view the fields from C:\Projects\Table1.dbf and select them from a ListBox so we can process that field. Thanks.

I'm trying to have my Program (form) create a text file from a report form and I'm having some issues. I'm using VFP 8 and this is the code inside a command button: REPORT FORM C:\Jobs\Reports\Report.frx NOEJECT NOCONSOLE TO FILE C:\Jobs\Reports\RPT0419.txt ASCII a) When I execute the command...

I'm using VFP 8, and trying to create an exe. Form runs perfectly inside the IDE, but I when build the exe and go and run it as an exe, it just flashes and terminates. I've read about putting the line of code "READ EVENTS" and I've inserted this line first in the LOAD event and then also in the...

When I start my program in VFP I would like it to automatically scan the contents of a specific folder and if any files in there, load them into a ListBox. Any suggestions would be appreciated. Thanks.