Recent content by metad

  1. M

    Audit Trail and only one Control/Field

    I have read treats about Audit Trail and downloaded the audittrail.zip database made by ghudson. My question is: Is it possible to track changes only for one control? I do not want to run code for whole form, and is just interested to track changes for one field. If I paste the code into the...
  2. M

    UTC (GMT) Time to Local time in query. Please help

    I got that to work Hi again. I got a new code, and this code is working perfect. Regards metad Const TIME_ZONE_ID_INVALID = &HFFFFFFFF Const TIME_ZONE_ID_UNKNOWN = &H0 Const TIME_ZONE_ID_STANDARD = &H1 Const TIME_ZONE_ID_DAYLIGHT = &H2 Private Declare Function GetTimeZoneInformation Lib...
  3. M

    UTC (GMT) Time to Local time in query. Please help

    OK. I get -60 as adjust your time value Now, I have made a module with the code and the function. When I test it in a form, I get -60 as "Adjust your time value", but We are in the timezone +1 GMT. Tha fact is that now is +2 hours GMT. In the function I have defined LocalTime as Time(). Is that...
  4. M

    UTC (GMT) Time to Local time in query. Please help

    Sorry! I do not understand Sorry for my limited knowledge, but I do not understand where to put the code when I don't use any form. I have made a module with the code (Without Sub_Form_Load) and named it GiveUTC. I have also pasted the function in the same module. Than I have made a field in...
  5. M

    UTC (GMT) Time to Local time in query. Please help

    Any suggestion? The problem is that I do not use any form. I have to find out the UTC time in the query, and I have realy problems with that. Have you any suggestion? Regards metad
  6. M

    UTC (GMT) Time to Local time in query. Please help

    OK. Here is my DB Hi agian, and thank you for your great help! Here is my database. Regrdas metad
  7. M

    UTC (GMT) Time to Local time in query. Please help

    Thank you! Could you please help me to implement this? Could you please tell me where I put the code (Module, I guess) and how I can call it (use it) in a query? Thank you very much metad
  8. M

    UTC (GMT) Time to Local time in query. Please help

    Norwegian Local Time Sorry. I am not talking about the equivlent of USA Daylight Savings Time. In Norway we adjust the clock +1/-1 on summer and winter. On Winter we are +1 GMT and on Summer +2 GMT. The time we adjust the clock is not equal every year. So it is not easy to code the changes...
  9. M

    UTC (GMT) Time to Local time in query. Please help

    Hi. I have a link table with a field in GMT time. I want to convert the times to local time in a query. I know that I should use DateAdd, but I am just wondering how to know summer and winter time. On the summer our local time is +2 GMT and on winter +1. Thanks in advance. metad
  10. M

    Daily Calendar

    Could you please help me with norwegian date format? I have used your database, and everything works well when I changed the field Date to Date1. But we use Norwegian date format, and it seems that the code only works with Date format as English (United Kingdom). Have you any advice to what...
  11. M

    Daily Calendar

    Please help with norwegian date format Hi. First of all thank you for good code. I have used your database, and everything works well when I changed the field Date to Date1. But we use Norwegian date format, and it seems that the code only works with Date format as English (United Kingdom)...
  12. M

    Track field value changes. Please help

    Thant you. Wokrs perfect I am just wondering one thing: Should the code be in BeforUpdate or AfterUpdate? Thank you again! metad
  13. M

    Track field value changes. Please help

    I do not understand! Thank you for your help. But I do not understand what are your field names in your code. I do not need to track all changes and insert it in a table as I understand you are doing in this code. I just need to know if a single field (Called GateArea) has been changed...
  14. M

    Track field value changes. Please help

    Hi. I have a form with many fields. I want to track changes av 1 field to know the field value has been changed or not. I know about onchange event, but this only works when user inserts or changes the value. My form is being updated by macro/visual Basic. Is there any way to fin out if the...
  15. M

    Delete records from table based on Inner Join query - Please help

    Duplicated records I have a table (Table1) which contains Fields as F1, F2 etc. This table is an update Table based on a link table. I could make a PK on this table, but that does not help me, because the PK for me is [F2] & " " & [F1]. Therefore I make a query based on this table and make a...
Back
Top Bottom