Recent content by IanDuk

  1. I

    Transferring Data From One Field To Another On Same Table.

    Cracked it! It should have been on the After Update on the end time before the Hours Calculation took place.
  2. I

    Transferring Data From One Field To Another On Same Table.

    I have and I have debugged it? This is the exact code. Private Sub DjRotaDetail_Hours_AfterUpdate() Me.DjRotaDetail_HrsAdj = Me.DjRotaDetail_Hours End Sub
  3. I

    Transferring Data From One Field To Another On Same Table.

    The code is programmed into the AfterUpdate on the Hours field.
  4. I

    Transferring Data From One Field To Another On Same Table.

    Hi theDBguy Yes that is one method I have tried but the data is not changing?
  5. I

    Transferring Data From One Field To Another On Same Table.

    Help Please! I am trying to do a Rota Application and need to copy data between two fields on a sub form. I have a calculated field called Hours and want to copy that value over to HoursAdj incase there are any adjustments that need making. I have tried a number of things on the AfterUpdate...
  6. I

    Hours Worked Calculation

    Little help? I am trying to create a table for entering times worked on a shift system to be calculated in hours. I have two fields, Start & End, which are formatted to General date so they have the date and time stored. I have tried the basic calculation End - Start but some shifts finish...
  7. I

    Dlookup!

    :) Thank you both! isladogs thanks for pointing out the differences. Now I am finally getting somewhere!
  8. I

    Dlookup!

    Hi I am trying to right an invoicing application and using Dlookup on a report to have it automatically bring in the billing addresses. I have trawled the web to find the correct code but it keeps giving me an error :banghead: So you can see what I am trying to achieve here is an example of...
See more
Top Bottom