Search results

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...

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...

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...

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...

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

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

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

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...

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

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...

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)...

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

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...

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...

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...

It does not work! Thank you for your answer, but the code dose not work. I do not use PK for the table, because this is an update table based on a link table. I hope you can help me more... Thank you

Hi. I have used a lot of times and searched this forum to fin a solution for following problem without luck: I want to delete duplicate records from a table (Table1). I have made a query as following: Query name: DeleteEntries SELECT Query1.Field1, Query1.Field2 FROM Query1 INNER JOIN Query2...

Hi. I have an excel document witch I transfer to a new table in MS Access 2000. The transfer sheet includes a column for time without column (e.g. 1900). If the time is 0500 the transferred data shows 500. I have made a query bases on this table and I am able to fine the left and right digits...

I have a table with employees’ information. I want to copy all records in this table to another existing table “WorkTimes”. I do not want to edit my employee table, so therefore I want to copy all records to another table before editing/adding information in other fields. How I can do that with...

I have a table with employees’ information. I want to copy all records in this table to another existing table “WorkTimes”. I do not want to edit my employee table, so therefore I want to copy all records to another table before editing/adding information in other fields. How I can do that with...