Search results for query: *

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...

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...

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...

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

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

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...

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...

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...

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

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...

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...

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

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...

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

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...

Hi, Report I try to make need to go through records in cursor and populate Cells in Excel.If two records are the same (have the same order and odline fields)then the second record should be skipped and only QTY field should be added to QTY field of previous one.So I have code like this that...

Hi, I'm getting this message when I try to compare value in the Cell with a value of the field in the cursor c_report.ordate (bolded line in code): SELECT c_report For i=7 to _TALLY .Cells(i,1)=c_report.cust .Cells(i,2)=c_report.orderID .Cells(i,3)=c_report.orline .Cells(i,4)=c_report.part...

Hi everyone, I have Select statement Select cust,orderID,partID,date,Qty from Table1 order by cust into cursor c_report I need to go through each record in this c_report and make date field to closest Friday(ship date).I tried something like this Select c_report Scan do While...

Hi, I need to figure out number of weeks between 2 dates user enter into two TextBoxes on a form.Value user enter into those text boxes are stored in Public variable tdDateFrom and tdDateTo (variables are ControlSource for those text boxes).I tried n=Int(Week(tdDateTo)-Week(tdDateFrom)) but...

Hi, I have table transaction with Parts and transaction dates.Each part has more then one transaction date of different type and source.My problem is that I need to get latest date for each part,so I'm trying with SQL statement(If It's possible?).If it's not possible how should I make small...