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

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

    inserting blank record at interval

    Hi, I have a label format file that has the label set up with nothing in between for me to convert. I want to import into foxpro and insert a blank record after every 4th line. Current format: name address city state zip name address city state zip name address city state zip Format after...
  2. emboughey

    Help with select statement

    I'm hoping this is a quick fix. I couldn't find anything but maybe I wasn't looking for the right syntax. I need to use only the first 3 characters of facility_id but I'm not sure how to do it. Can you guys help? sql = "SELECT Planet_Code,Job_Number, Job_Name...
  3. emboughey

    Program running slow to update records

    The program is written to access a dbf file. In doing that, it adds fields (prefix, first, mid, last, etc) and then updates them with information from a library of name elements. The problem is that it is only running at about 700 updates per minute and my files are usually greater than 10,000...
  4. emboughey

    Navigate to directory

    I can't figure out how to allow someone to navigate to a specific directory to start the program. Can anyone help? I'm using the following syntax type.... (old stuff I know) @ 5,5 say 'Enter Directory to convert data from: ' thefile = getdir()??? use alltrim(lower(thefile)) Thanks is...
  5. emboughey

    Tweak a SQL query for VB to match data

    The below code is pulling data from 2 files based on the planet code matching. Problem is one file has a 12 digit code and the other has an 11 digit code so no matches. How would I tweak the below code to only look at 11 digits instead of 12? This is a large program and I'm thinking this is...
  6. emboughey

    Adding additional report to existing code

    Hi all, I'm usually in Foxpro and not VB so please bear with me. I have a form in VB that imports data and also creates a report if you enter a job # or planet code. I need another one that creates the exact same report by date range. (date range comes from the USPS daily file) Can someone...

Part and Inventory Search

Back
Top