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!

  • Congratulations TouchToneTommy 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 vino10

  1. vino10

    Dialing rules

    hi guys, How to dial a phone with my PC,when my phoneline is running from a PABX system,
  2. vino10

    Foxpro otimization

    Thanks guys, I think all of you was right,So instead of using alltrim() can i just use the == operator to get the exact value.
  3. vino10

    Foxpro otimization

    Thanks guys i think i see the problem, I think its because of the missing index for the soundex(c_lname) and soundex(c_fname). Thanks guys You give me a very helpful Ideas. By the way,I use the Alltrim() just to Eliminate the spaces in my field. Thanks anyway for the suggestions
  4. vino10

    Foxpro otimization

    Sorry guys, Heres my code Note: I have index on last name,first name Thanks SELECT ALLTRIM(control_no) as control_no,; ALLTRIM(c_lname) as last_name, ALLTRIM(c_fname) as First_name,; ALLTRIM(c_minit) as MI, dob_dt as Birthday,; ALLTRIM(c_adr1) as address1,ALLTRIM(c_adr2) as address2...
  5. vino10

    Foxpro otimization

    Good Day guys Guys how can i speed up my query selection in our system, it takes more than a minute to process a single query we ony have 300,000+ records. My query is just selecting names with soundex equivalent.
  6. vino10

    editing messagebox

    Hi guys, Can i edit/change the caption of a messagebox() button? is it possible?
  7. vino10

    Automated Unique sequence Number

    Hi guys? Question guys. does VFP have an automated generations of Unique sequence Number?
  8. vino10

    Excel formula

    Thanks! byundt I think i save time by this. thanks again
  9. vino10

    Excel formula

    Hi Guys, I have 2 different report in 2 different excel file and its being updated daily, now i have to create another excel summary report consist of those 2 excel report which i need to have a formula. Is it possible to have another excel file w/ formula coming from 2 different excel. EX...
  10. vino10

    Txt Delimited?

    Ok, Thank you for the Help and time
  11. vino10

    Txt Delimited?

    Yap, i think i can use your codes but the problem is the codes aint simple enough and it has so many variation of reports to incorporate it. Im thinking of starting again from scratch by using SQL Statements in that way i can manipulate it mush more easier. I have some idea i dont know if it...
  12. vino10

    Txt Delimited?

    ok, sorry for that,Generally the report is for the breakdown count of each questions (Age breakdown,Do you smoke?, Etc) for a certain Survey Questionaire so i have put this report into a report form giving me the quick view and automation of report to print smoothly but i only did was to save it...
  13. vino10

    Txt Delimited?

    Tnx Yeah i think i can do that, the thing is the current report is generated from several variables like this: Age 18-24 x1824 25-29 x2529 Total where: x1824,x2529 is 2 unique variables then i use the command Report form "Report_name" to file "file_name" ascii. Please tell me if i've done...
  14. vino10

    Txt Delimited?

    Guys, Question guys, I have a system revision which includes all report form from Visual Foxpro reports to a Text delimited file. Any way of conerting it without starting from scratch? thanks in advance
  15. vino10

    MS Acces Question

    Guys, How Can i Merge 2 tables with same columns into 1 table?

Part and Inventory Search

Back
Top