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

  1. garyzak

    auto assign codes to field

    Issue resolved. It is working. Created another table to store the value for incremnting. Thank you all for your help!
  2. garyzak

    auto assign codes to field

    point taken. Sorry about that. I will dig in and take your suggestion. Thank you.
  3. garyzak

    auto assign codes to field

    Thank you, Mike. The results, for each time the program runs, starts at 35,000. With the above code, I need to "store" the very highest number in the merge in a variable and then increment so that the number keeps going up. Can you please take a look? It is working as far as the numbers entered...
  4. garyzak

    auto assign codes to field

    All set, got the dang thing going! Thank you very much for your help on this. I will copy this post for further exploration as I learn. You are an inspiration and a great help. Thanks again....
  5. garyzak

    auto assign codes to field

    Thanks JRB-Bldr; stil getting "Variablbl importid not found" even though that field is in Merge... *SET EXCLUSIVE OFF * 1. Setup excel headers (Source doc) * 2. Save excel as dbf (Table #1) * 4. Export Exceed to excel * 5. Convert Exceed excel to dbf (Table # 2) * 6. Scan for dups * 7...
  6. garyzak

    auto assign codes to field

    Hello all; this is the last thing, I promise.... Ran into a snag with the content managment program Exceed. It stores ID's in the Importid field from old records so at anytime there are id's like 1000-2000, with 35000 being the top end. Wehn I export to the .CSV, I need the numbers to start at...
  7. garyzak

    auto assign codes to field

    Thank you jrbbldr and baltman...All set. I appreciate your time and expertise..
  8. garyzak

    auto assign codes to field

    Sorry; just to clarify: The codes BMPR, HTTO should corespond to certain companies: BMPR = Buffalo Medical Primary Reception HTTO = Hospital Transfer Trace Occupational etc... Please let me know if ther is a simple way to do this.. Thank you in advance for your time/help..
  9. garyzak

    auto assign codes to field

    Hello; I hope I can get a little help/direction. I have one more step in this process to get my program working correctly. There is a field called AFFIL that is supposed to have affiliate codes automatically assigned as the files are uploaded in the temp directory. Examples of the codes are...
  10. garyzak

    Need help with steps for dup check

    Great! I modified and it is now working. Thank you for your help.
  11. garyzak

    Need help with steps for dup check

    That saved the file as you mentioned as a csv. Thank you very much! One last question, please. Where can I define the correct column headers for Exceed: ex: AIDNO(exceed creates primary number) LNAME FNAME SLNAME SPOUSE ORGNAME This is what was in the new Exceed file: a...
  12. garyzak

    Need help with steps for dup check

    Yes, the Exceed program only accepts .csv so I am trying to automate this with VFP. It needs to export the .csv and use the column headers in my previous post. Can the exported file include the column headings, or would I have to do this manually?
  13. garyzak

    Need help with steps for dup check

    Thank you for the reply and information, JRB-Bldr and Mike. I have this working, it is deleting dups when I chose yes and passes when I chose no. The last thing I could use a bit of advise with if at all possible is how to EXPORT to Excel and convert the file into both a .csv (the file is to be...
  14. garyzak

    Need help with steps for dup check

    Hello again; Thanks for the earlier replies. I am close to having this working but still a bit off. Please let me know if you have any ideas. When I open the program and chose a "source" Excel file to match against MERGE, it goes through each record with the messagebox. The record that pops up...
  15. garyzak

    Need help with steps for dup check

    Thank you both. I will rework with your suggestions. Thank you
  16. garyzak

    Need help with steps for dup check

    Thank you Mike; one file is exported from a contact managment program called Exceed, the other file will be an Excel file sent by user. I must export the Exceed file, change to a .dbf and check it for dups against the user supplied Excel, that will also be changed to a .dbf.
  17. garyzak

    Need help with steps for dup check

    Hello; hope to get a little help. Have two source files I need to check for duplicates within Visual Foxpro 9. Below are the steps I need to impliment and below that is the actual code. I am close but need help with the code to make sure this will accomplish what I need. I appreciate any help...

Part and Inventory Search

Back
Top