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 SkipVought 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: hongbin81
  • Order by date
  1. hongbin81

    Total Number of Records?

    ok thanx
  2. hongbin81

    Total Number of Records?

    How do I display the total number of records? Is there a function? for example: total sum has function DSum so what would total records be
  3. hongbin81

    Password Protect the Code.

    Is there a way?
  4. hongbin81

    Updating using a Function

    heh..I didn't even know you can give a "STAR". ^_^ Thanks!
  5. hongbin81

    Updating using a Function

    ahh~~ that was the problem. NO RETURN! Thank You so MUCH! ^_________________^
  6. hongbin81

    Updating using a Function

    the SpotRate's should be "Cost"
  7. hongbin81

    Updating using a Function

    Function fGetCost(iDate As Date, iTime As Date, iDuration As Integer) As Double Dim Week As Integer Week = Weekday([iDate], 2) If (Week = 6) Or (Week = 7) Then Select Case iTime Case #7:00:00 AM# To #8:49:59 AM If iDuration = 15 Then Cost = 33 ElseIf iDuration = 30...
  8. hongbin81

    Updating using a Function

    I don't have any criteria that limits the number of records. This is my function. There's nothing wrong is there? Function fGetCost(iDate As Date, iTime As Date, iDuration As Integer) As Double Dim Week As Integer Week = Weekday([iDate], 2) If (Week = 6) Or (Week = 7) Then Select Case...
  9. hongbin81

    Updating using Function

    It only updates one record...ahhh~!
  10. hongbin81

    Updating using Function

    I have a function that I made in Modules called modFunc... fGetCost([Date],[Time],[Duration]) This function results in indicating a Cost according to Date, Time and Duration. I need to update ALL RECORDS using this function. Is there a way of applying this function using update query to...
  11. hongbin81

    Updating using a Function

    The function I wrote is in Module. So do I have to direct which Module I wrote the function in order to use the function in SQL?
  12. hongbin81

    Updating using a Function

    I'm not sure how to do it with a function. I tried putting in fGetCost([Date],[Time],[Duration]) in a field, but that only updated one record, not all.
  13. hongbin81

    Updating using a Function

    I have a function... fGetCost([Date],[Time],[Duration]) This function results in indicating a Cost according to Date, Time and Duration. I need to update ALL RECORDS using this function. Is there a way of applying this function using update query to update all records in my table?
  14. hongbin81

    calculating ALL records at once

    Actually it didn't work! It only updated ONE record. Not ALL.
  15. hongbin81

    calculating ALL records at once

    Question: Why does the Expression fGetCost([Time],[Duration]) dissapear everytime i close the query?
  16. hongbin81

    calculating ALL records at once

    Thank you! It worked nicely!
  17. hongbin81

    calculating ALL records at once

    I'll give it a try now.
  18. hongbin81

    calculating ALL records at once

    I've been using access for a little over a month now. So the function made would be used in update query? How is a function used in query?
  19. hongbin81

    calculating ALL records at once

    The code I have is this: Select Case Me![Time] Case #7:00:00 AM# To #8:49:59 AM# If Duration = 15 Then Cost = 33 ElseIf Duration = 30 Then Cost = 55 ElseIf Duration = 45 Then Cost...
  20. hongbin81

    calculating all records

    It's not a simple formula. The code I have is this: Select Case Me![Time] Case #7:00:00 AM# To #8:49:59 AM# If Duration = 15 Then Cost = 33 ElseIf Duration = 30 Then Cost = 55 ElseIf Duration =...

Part and Inventory Search

Back
Top