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

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

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

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

Hi. I know how to import data from an excel file to a table. But my problem is to exclude some rows. I have tried following, but it does not work: DoCmd.TransferSpreadsheet acImport, 8, "FlightInfo", "C:\Avgang.xls", False, "A, B, D, G, J, L" It works, if I write "A:L", but I do not want C, E...

Hi. I use MS Access 2002 and I have a database with 2 forms, one in continuous view. I want to change background colors (or text colors) when a field “ActionTime” is closed to the actual time. I have studied a lot of threats here, but still I have problems to make it works. To test the...

Hi. I have a form which has a lookup function. The lookup field (a combination box) is collect information about 8 fields from a query. The problem is that I can not see the information before I close an reopen the form. When the form reopens, it goes to the last record. I know that I can get it...