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!

Recent content by SgtMonty

  1. SgtMonty

    Does not exist query??

    This is what I wrote: Dim db As dao.Database Dim rs As dao.Recordset Dim strSQL As String Set db = CurrentDb strSQL = "select * [Time_In] =" & Code Set rs = db.OpenRecordset(strSQL, dbOpenDynaset) If rs.EOF Then MsgBox "Code Not Found" Else MsgBox "Code Found" rs.Close db.Close Set rs = Nothing...
  2. SgtMonty

    Does not exist query??

    Thanks for the help. Based on my data can you give me an example.
  3. SgtMonty

    Does not exist query??

    Can you give me an example. How?
  4. SgtMonty

    Does not exist query??

    I have a table that hold numeric codes. Example: Code 1000 1002 2000 2394 On a form I request for the code number. I need help to construct a query that if the code does not exist, it will return a message that the code does not exist. For example the code 1111 is not on the list. I already...
  5. SgtMonty

    Date Time Query

    Hello Everyone, I solved the problem. I appreciate the help. The query that I had needed two criterias. The exeptions I needed were for the time less than 24 and greater than 0. Now the data comes in perfectly with the right time and the right amount of hours/minutes worked.... Thanks...It has...
  6. SgtMonty

    Date Time Query

    Code Date_Time_In Date_Time_Out 1111 10/21/2010 9:00:00 AM 10/21/2010 4:00:00 PM 1111 10/21/2010 9:00:00 AM 10/22/2010 5:00:00 PM 1111 10/22/2010 10:00:00 AM 10/21/2010 4:00:00 PM 1111 10/22/2010 10:00:00 AM 10/22/2010 5:00:00 PM 9999 10/21/2010 10:00:00 AM 10/21/2010 4:00:00 PM 9999 10/21/2010...
  7. SgtMonty

    Date Time Query

    That is the problem. He punched in for example on the 21st and punched out on the 21st also at a later time. Then then next day he did the same but it display the actual time and it also takes the 21st as a starting time for the 22nd as another time. By the way the date/time is display in short...
  8. SgtMonty

    Date Time Query

    Example: An Individual Clocks in one day at 10am and Clocks out at 3PM. Then Next day at 9am and out at 4pm, etc. When I run the query that has both tables In and Out, it will show time in 10am out at 3pm in another line it will show 10am out at 4pm... It does not go to the next time in and...
  9. SgtMonty

    Date Time Query

    I created a Time Clock for a small office. When a person comes in to work, the person will login with his secret code and "will press the the Clock In button" at that time the system will record the time that the employee logged in. The same concept when it logs out. The problem is that the...
See more

Part and Inventory Search

Back
Top