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 Chriss Miller 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. pcrmil

    Checkbox problem

    Thank you TheAceMan1 It is not working. I want to track the user's names.Could you please give me more details.
  2. pcrmil

    query calculation

    I created a query1 with the expression to calculate minutes but it is giving an error. I tried to calculate the minutes on the cross tab query to based on the query1. When I ran the summary report on this cross tab query its giving each group the same value. I am doing something wrong that I...
  3. pcrmil

    Checkbox problem

    I have the datasheet form1 on the main form. When the user clicks on a particular record, it will open the form2. On form2 there is a check box. I want to know how to track information that is checked and then after that its unchecked. Thank you
  4. pcrmil

    minutes calculation

    KLmorgan, Thank you, I did what you said. Its still not working. Could you please write more dedtails about the syntax as soon as possible because there is a deadline to finish this report. I will greatly appreciate if some one could help me.
  5. pcrmil

    minutes calculation

    Hi, Users are entering the hours and mts 8, 7.3, 6.3,9 etc. Creating a report every day , and every month. I created the cross tab query and I used the code below on the total column = Int(Sum((([total] - Int([total])) * 100) + (Int([total]) * 60)) / 60) & "hrs " & _ Sum((([total] -...
  6. pcrmil

    minutes calculation

    TheAceMan1, Thank you very much, it works very well, I just changed the peranthesis on the code. It works in the report. Can I enter the same code in the query also?
  7. pcrmil

    minutes calculation

    Hi PHV, Thanks for your time. I didn't exactly remember the error message but part of the error message is a syntax error.
  8. pcrmil

    Form refresh automatically

    Hi, JBinQLD and Seethru Thanks to the both of you . Me.refresh is not showing the newly added records. I used Me.requery . I entered the time interval every two minutes and its requering, but while in the process of entering the data/editing etc the hour glass is staying until the...
  9. pcrmil

    minutes calculation

    JBinQLD Thnk you, users are entering mts 0.15. Is there any way to remove the decimals .
  10. pcrmil

    Form refresh automatically

    Hi JBinQLD and SeeThru Thanks to the both of you for your time explaining it to me,It works. JB that is correct, the cursor on the form is jumping into the first record. How can I use the bookmark to reset to the relevant record. Please explain it to me. Thanks so much
  11. pcrmil

    minutes calculation

    Hi JBinQLD, I broke down the syntax into three components and the results are below: After I removed the fix on line below sum([mts])/60)=0.02 sum([mts])=1.35 (fix(sum[mts]/60)*60)=00 PHV, I tried your syntax also but it is not accepting, I am getting an error message. thank you JBinQLD...
  12. pcrmil

    Form refresh automatically

    Thanks JB I am a new program. Could you please explain to me in detail about the Time intervel property so i can set it. Also please give me a step by step, on where can I write the code . Thank you.
  13. pcrmil

    Form refresh automatically

    Hi All, I have a database shared on a network. If a user is entering data on a form, how do I get the information updated to an open form on the second user's computer automatically with the timer every 2 mts, without hitting shift F9 or the refresh button? i will be greatly thankful if you can...
  14. pcrmil

    minutes calculation

    Hi JB Run the report based on the date parameter for 15 days .The Total calculated minutes are 135. When I apply the formula above, it is giving 2hrs 25 mts. Its suppose to be 2hrs15mts. i dont know what i am doing wrong, please explain it.
  15. pcrmil

    minutes calculation

    Thanks to the both of you. Hi JB I used your syntax,but the mts is not printing correctly. Also Remou I tried your syntax also, it is printing zero. Please let me know how I can print the mts correctly.
  16. pcrmil

    minutes calculation

    Hi All, I created a report,that report is about printed hrs and minutes totaled. Minutes are storing 0.15 0.40 0.15 0.15 etc. I used the formula on the report: group footer. Ex. if total minutes are 205 i used the formula below. Sum([mts]/60*100) to total. The minutes are...

Part and Inventory Search

Back
Top