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

  • Users: EKC
  • Order by date
  1. EKC

    Comparing date values

    Hi, I need to validate values of 2 dates on the form before submiting it.I used IsDate function to check if values are dates but I have a problem how to check that dateEnd is later then dateStart.I tried: if document.entry.dateStart.value < document.entry.dateEnd.value but it is not working...
  2. EKC

    Beginner question

    Hi, I have a form with a few input boxes.I want to be sure that required text boxes are filled before submiting form so I have a client side validating in place.When user try to submit form without filling required box,I also want image of arrow to show and point to blank box. I tried few...
  3. EKC

    How to get a value of selected item from the list?

    Thank you
  4. EKC

    How to get a value of selected item from the list?

    I have a form with some input elements and 2 list.One list display list of codes I need to display brief explanation based on selected choice.My list is : <select name=&quot;Code&quot;> <option>KTOL <option>POUF <option>YUH <option>TRAM <option>DTM <option>OTHER </select> I have OnChange...
  5. EKC

    Extract decimal portion of the number

    Hi, I have 2 questions: 1.I need to extract decimal portion of the number,multiply it with 0.6 and add it again .Example: 6.45= 6 + (45*0.6)=6.27 2.What function is used to substract dates Thanks, Lyn
  6. EKC

    Need a function that replace character

    Hi, I have a numeric field that need to be converted to time - actually this field show time ex. 15.45 is 15:45.Is there a function that can do this and if not is there a function that can replace a &quot;.&quot; with &quot;:&quot; Ex. Fun(15.45) should return 15:45 Thanks in advance Lyn
  7. EKC

    Trigger or what?

    So if I create trigger on Order table and include message,it's going to be visible on each machine running front-end and not only on front-end where order is entered.Yes or No? Thanks Lyn
  8. EKC

    Trigger or what?

    Hi , On a recent presentation of a new (custom made) database managment system(back end can be SQL,VFP,Oracle front end made in Visual C++)I saw nice thing:If new Order is entered everyone is getting MsgBox saying something like &quot;We have a new Order&quot;. Is this possible to do with VFP...
  9. EKC

    Looping again - Monday deadline

    Thanks guys, I really appreciated yours help Lyn
  10. EKC

    Looping again - Monday deadline

    Hi, I need help solving this problem: I need to go trough the table and for OrderID and OrderLine (I pass as a function arguments) loop as long as Sum of RelQTY is Less or equal then QTY(I pass as a third argument) and when this happend ,returnd value of RelDate field of a record.Ex: OrderID...
  11. EKC

    Want Datediff minus the weekends

    Hi, Recently I had to do similar thing but in Visual FoxPro so I got this function that you call with your start and end date ** Date1,Date2 are arguments to this function** ldStartDate= IIF(Date1> Date2,Date2,Date1) ldEndinDate = IIF(Date1=> Date2,Date1,Date2) lnNumberOfDays = ldEndinDate -...
  12. EKC

    Loop trough records

    Thanks guys, Lyn
  13. EKC

    Loop trough records

    Hi, I need help solving next problem: I need to calculate Sum of the QTY from the Table1and store it in a variable.Table1 has OrderID,orderline,reldate,QTY fieldsIt looks like: Order orderLine reldate QTY 111 1 3/1/01 20 111 1 4/1/01 10 111 1...
  14. EKC

    Wyh I can't modify Table ?

    Hi , I need to add 2 more fields to a table but in Table Designer title bar I have Name of my Table Table1.dbf(ReadOnly).&quot;Insert&quot; new fields command appears dimmed.I checked properti of the Table1.dbf file-it's archive.What could be a problem? Lyn
  15. EKC

    It's stupid question but I must ask

    Hello friends, I'm ashamed to ask this question but I need to (I guess being beginner in VFP gives me that right).So here comes the question:Where do you declare a function? I have my little project that have only one form where user enter information in the boxes and command button which has...
  16. EKC

    Urgent date problem

    Hello everyone, I have two dates:start date of job(jstart) and end date of job(jend).I need to calculate time needed to finish the job,so I have (jend-jstart).That gives me time in days which is OK but that also include weekends which should't be.So my question is how to eliminate Saturdays and...
  17. EKC

    Beginner question

    Hi , Can someone tell me why my .exe program doesn't work if I save it in location other then location of project.When I build .exe and save it in the same location as project file it works fine.When I save it in another location,after I run it I get Open File box to locate table I used. Thanks, Lyn
  18. EKC

    Compare Tables

    Hi , I forget to ask one more question: Because of the denied access to database tables,I need to copy tables to another location in order to work on them (make reports).Some table are very big and copying takes time.Is there another way :can tables be compared and new record added insted...
  19. EKC

    Program closes

    Hi , I made .EXE file but when started, it closes immediately.I read about similar problem someone posted month ago but I can't find that message. Thanks, Lyn
  20. EKC

    Skipping records

    Hi, I posted my problem earlier but now I have new question( I decided different approach): I have set of records in one cursor(fields are order,orderline ,part,orderdate,QTY).If 2 records have the same order and orderline fields (those records following each other -I sorted them by...

Part and Inventory Search

Back
Top