Search results

  1. 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...
  2. 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...
  3. 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
  4. 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 =...
  5. E

    using a pin

    Hello, I have a textbox "Text2" with a 4 digi pin typed into it, when i click on a command botton i want it to check table "Admins" for that pin in field "Pin_". If it is the correct pin, it will then fill in another table "Access History" with the Date, time and Name of admin in the fields...
  6. E

    Delete me

    Hello I need the code for taking the value entred into a text box and then deleting its record from a table. this will happen on the OnClick event of a command button. The text box is named "Text40" The field the value will be added to is named "Allocated To" The Table the field is located in...
  7. E

    Text boxs and tables

    Hello I need the code for taking the value entred into a text box and then adding it to a new record in a table. this will happen on the OnClick event of a command button. The text box is named "Text40" The field the value will be added to is named "Allocated To" The Table the field is...
  8. E

    Function

    Hello Im new to VBA and i would like help with getting a macro to run a VB script. i have tryed runcode but the marco cannot find my module as function. Can anyone help.
  9. E

    Can this be done and how?

    Hello all, I have a query with the following code.... SELECT NRTS.[Item], NRTS.[Description], NRTS.[NRTS No], NRTS.[Serial Number], NRTS.[Cal Due], NRTS.[Allocated To], NRTS.[Image] FROM NRTS WHERE [Cal Due]=DateAdd("D",30,date()); What I need is when the query returns a record from the...
  10. E

    Combobox misbehaving

    Can someone tell me why this combobox on main is not working. Thank you for your time.
  11. E

    Dates

    I need to run a query that will return all records for a due date within 30 days from the computers date this is the code i have so far. SELECT NRTS.Item, NRTS.Description, NRTS.[NRTS No], NRTS.[Serial Number], NRTS.[Cal Due], NRTS.[Allocated To] FROM NRTS WHERE [Cal Due] thank you for...
  12. E

    Using a Combobox to run a query

    I need the code or any help to be able to get a combobox to run a query based apon the value selected within the combobox, i also dont know how to make the query variable and linked to the combobox so that i dont have to produce loads of queries. I so far have this SQL code SELECT NRTS.Item...
Back
Top Bottom