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!

Recent content by emboughey

  1. emboughey

    inserting blank record at interval

    Thank you. I actually am in the mailing industry as well so this is extremely helpful.
  2. emboughey

    inserting blank record at interval

    I received the files in a pdf file and they were set up as label format. The problem is that when you convert from pdf to excel, it loses the line break between records. What I ended up having to do was import the file delimited, put 2 pound signs when it encountered the zip code to signify...
  3. 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...
  4. emboughey

    Help with select statement

    It worked fine this time. I didn't have both of them set up for 3 characters.. Thanks. One more thing. I need to add something else I need it to look for Op_Code > "897" but it's not working. I believe it is a character field which is why I put the quotes around it. WHERE [planet] =...
  5. 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...
  6. emboughey

    Program running slow to update records

    Does what I've sent help at all in figuring out what's causing such a long time in processing?
  7. 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...
  8. emboughey

    Navigate to directory

    Here's the code I've written.... The copy command (lcnewfile) doesn't work though. I want to actually get the date to print first ie:06282007_importfiles.csv, but I just can't get it to work for me. *** Premier File Import, Data Work, and Export Program *** Created by Emboughey ***...
  9. emboughey

    Navigate to directory

    Thanks everyone for your help! I know it seemed like a really simple question, but I've been away from the programming side for awhile and find myself quite rusty... I'm setting several programs (almost identical) into action through this one because I have several database structures. I...
  10. emboughey

    Navigate to directory

    I'm to here now. Getting an error with the lcfile though... Any advice at all would be greatly appreciated. @ 5,5 say 'Enter Directory to get data from: ' thedir = getdir() SET TALK OFF SET SAFETY OFF USE east-cent ZAP lcPathAndMask = thedir+"\*.xls" lcFile = Sys(2000, lcPathAndMask) Do...
  11. emboughey

    Navigate to directory

    This is the program I'm writing. I have no idea even where to put the getdir() so it can append from all the files in that directory. They are in two different locations... SET TALK OFF SET SAFETY OFF set defa to c:\working\premier USE east-cent ZAP lcPathAndMask =...
  12. 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...
  13. emboughey

    Tweak a SQL query for VB to match data

    Skipvought. It's still not pulling them. Below is all the code required for that specific form. I hate to ask for help but I have tried several things and none have worked. They either pull only the planet codes in the archive with 11 digits and ignore the 12 digit ones or it just locks up...
  14. 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...
  15. 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...
See more

Part and Inventory Search

Back
Top