Updated Date and Updated by User (1 Viewer)

muralikreddy · Dec 25, 2008

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 fields in the table.

ArtMiles · Dec 25, 2008

muralikreddy said:
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 fields in the table.

Just run an update query for the 2 fields. Run it in the same macro.

Hope this helps.

muralikreddy · Dec 27, 2008

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 upload and not records previously uploaded.

Thanks & Regards,

ArtMiles · Dec 27, 2008

Hello,

Use the 'Criteria:' row of the update query to filter only the records you would like to update. One possiblity would be to add '>Date()' fo the date field.

Hope this helps

Art

raskew · Dec 27, 2008

If you are adding new data to an existing table, you need to be using an Append Query rather than an Update Query, which would be used to modify existing data.

HTH - Bob

Updated Date and Updated by User (1 Viewer)

muralikreddy

Kris Reddy

ArtMiles

Art

muralikreddy

Kris Reddy

ArtMiles

Art

raskew

AWF VIP

Similar threads

Users who are viewing this thread