Search results

I am really sorry for that. The form I am submitting with same password. The form Equipment needs to be used for the purpose. Choosing 1st three items next two should follow. Also, I dont need the repeated items shown in dropdown. Thanks

Hi, I want to make a form which will allow me to get data from a query and search using 3 fields parallely. Attached the database in 2010 format. password of the db is "nolimit". The query PTM & Equipment should be bound with the form and if I enter month, PTM and equipment need rest 2 fields...

Yes. Thanks everyone. Mark this thread as CLOSED.

tamangspace: Once again I am facing the problem. I used the same code that you gave but getting error on the calculation. pls check my form , Only additional thing I did is visibility set to "No" for the text box which stores the temp calculated data. Even after setting the visibility ON the...

This serves the purpose. :)

Thanks for your concern. But, Let me make it clear that the difference is all that matters to me more than time1 and time2 values. I need to sort out records later on by difference (ascending/descending ) and also need summation of differences etc later on to analyse the data. Now, is there any...

tfurnivall: Thanks. But, what problem actually I am facing is that Its working fine if i enter simply in 24hr format it takes the value correctly and also calculates the minutes correctly using the formula =DateDiff("n",[open],[close]) but the final calculation is not showing up in the table...

Friends, I coudn't find a solution to my problem even after having so many experts out here. :(

Hi, I want to add three fields in a table namely from, to and diff . How to add them in a form so that I can enter the time in (xx:xx) 24hr format in the "from" and "to" fields and calculate and save the time difference in minutes to the "diff" field automatically. PS: I am using access...

Hi, I want to calculate the average of 16 anodes from text box into the "average drop" box and simultaneously want the data to be saved in the table too as one of the fields. Also, How to load form view while the database loads? Thanks in advance.

Yes. The error let me check the type, it was not date/time ( duration). Even, after changing the datatype stills the same error. :(

ypma: I tried it but its not working. I have two text boxes namely ot (field name:opentime) and ct (fieldname: closetime) wherein I enter two times and want the data to be recorded in 3rd text box namely duration (fieldname : duration) but the formula gives the output as...

Hi, I am new here. I have a query. I have a table with many fields in which 2 fields take time values (strt and end time) and 3rd duration field that records the datediff("N", strt, end) i.e diff in minutes. How to write a code to put those in form I have a form linked up with that table. In...