Recent content by echo0001

  1. E

    Table update problem

    Ok will try it late after work, thank you for the quick reply
  2. E

    Table update problem

    Hello, I am having a spot of trouble. I have a check in and out system, when a person is checked in a new record is created on a table with the Now() data and the persons name, when they check out i want the Now() data to update on the last record made for that person. the problem i am having...
  3. E

    DateDiff to show hours and mins

    hello all, Basically I want a way to get the number of hours between two date/times, but with hours and minutes. Currently i use DateDiff("h",[Check In/Out].[Check In],[Check In/Out].[Check Out]) AS Hours But this only returns the number of hours. How do you get it to return the minutes as...
  4. E

    Between in IF statement

    sorry about that had to take the input mask out and it worked
  5. E

    Between in IF statement

    the code is running now, but the task of not letting it create another record isnt working, i have tried to change the >= to work but with no luck
  6. E

    Between in IF statement

    Getting a compile error on the "Between" part of the If Statement.
  7. E

    Between in IF statement

    The following code might clear up what im trying to do. Private Sub Command14_Click() Dim mySQL0 As String If Tables![Check In/Out].[Check In] = "Between Time() and (Time()-Minute(5))" Then MsgBox test Else mySQL0 = " INSERT INTO [Check In/Out] ([Childs Name], [Check In]...
  8. E

    Between in IF statement

    hello, Just need a second pair of eyes on this. If Tables![Check In/Out].[Check In] = "Between Time() and (Time()-Minute(5))" Then Not working, error 424, object required Cheers
  9. E

    Error 3134

    Where which naming conventions as far as i am aware im not
  10. E

    Error 3134

    Hello i have yet again came across the same error, i think i just need a fresh set of eyes Private Sub Command14_Click() Dim mySQL0 As String mySQL0 = " INSERT INTO [Check In/Out] (Childs Name, Check In, Date01) " mySQL0 = mySQL0 & " SET Childs Name AS Childs Name, Time() AS Check In...
  11. E

    Error 3134

    sorted now, forgot the simple [] around the table name
  12. E

    Error 3134

    ok got that, found the missing spaces and sorted that but still getting same error
  13. E

    Error 3134

    am i being stupid here but i did what you said and i get a compile error, Expected: Print or ? or Assert
  14. E

    Error 3134

    Hello, I have the following code and cannot get it to work i have been at it for hours and im getting the error 3134, Syntax Error in INSERT INTO Statement. Any help would be great Private Sub Command20_Click() Dim mySQL As String Dim rs As dao.Recordset Set rs =...
  15. E

    using a pin

    word such as Date, Time, Name are special words and are used in some way by access to save any trouble with this i just put an underscore after each word, once i did it with date on another table i just kept it the same.
See more
Back
Top Bottom