Recent content by bensplace

  1. B

    calculate elapse hours and minutes between 2 date and time fields

    I thought this was going to be so simple, how wrong could i have been. I have 2 date/time fields which have date and time entered in to them eg. 01/01/1013 10:31:00 I then have a 3rd field which i want to display the elapse time between the first 2 fields. i managed to get the hours part...
  2. B

    Need to check if record exists or not

    A bit of a update. I have now been able to check for the date and it works. when it finds a valid date i then ask if my combo0 = day/night in the if statment but an error comes up " TYPE MISMATCH" Any ideas? Dim rs As DAO.Recordset Set rs = Me.RecordsetClone With rs .FindFirst "[Date1] = #"...
  3. B

    Need to check if record exists or not

    We want to write product logs at work one day log and one night log I have a date field and a day/night field there will always be two records with the same date, one will be a day record and one will be a night record i need to check if a record exists eg. date + day or date+night. the idea...
  4. B

    I need to know if a record exits or not

    I am embarrassed to ask the question as I thought I knew more than I do about VBA programming in Access. Ill spell my problem out and hope someone can point me in the right direction. I have a database called “e1 records” And two data fields called “Date1” and “Day/night” When I load a form...
See more
Back
Top Bottom