Search results

Hi, I want to capture the audit trial for the changes made to the records of a table to a seperate audit trial table. Could some body please help me to do this. Thanks & Regards,

Thanks a lot for your help. I'm using Access 2007. Is the procedure same? Regards,

Hi, I have created an access database. This database will be used by multi users. I have created various users and given password to access the same. When this database is accessed by various users from their systems, they are able to login without the user and password dialog. Please help...

Thanks a lot for the response. Its working but there is a small problem. Whenever i run the update query, the date for the entire table is getting changed. As I'm uploading the excel data into the table on a daily basis, actually the 'Uploaded Date' should be changed only for the current...

Hi, I have to upload an excel file on a daily basis into a access table. I have created a macro for the same in access. But I want to add two fields to the the table everytime the data is uploaded to the table which are "Updated date" and "User". Please help me how can I update the two...

Hi, I have a table which will be accessed and updated by various users, with the help of a form. I want to provide an option where the user can modify data keyed by him in the table through the form and he can only view the data entered by other users. In this table I'm capturing the userid...

Hi, I have a table in which daily movement of stock into various processes is loaded. The daily movements will be uploaded from an excel file. I want to write a macro to upload an excel file into a table and all the details in the excel file should be uploaded to the table.

Thanks a lot Bob

Hi, I want to create an expression in a query, which is a combination of one or more fields in a table. e.g., Concatenate function in excel. Is there any such function in access. Please help me. Thanks & Regards