Search results

Hi All, My VBA script uses a loop to download attachments from Outlook into a folder on C. It works well without issues but imports only 8-10 email attachments at a time. I do not get any error in the code and when I click the Import button on the Access Form, it again imports another 8-10...

Thanks much. It worked but for times like 2024-02-27 20:45:01 it updated to 2024-02-29 8:45:01 PM. Is it about settings?

Rather than now(), is it possible to retain the time part and just change the day from 27 to 29? If the value is 2024-02-27 10:18:38, i need it as 2024-02-29 10:18:38 and if it 2024-02-27 10:19:40 it need it as 2024-02-29 10:19:40

I tried an update query on my field, insertdatetime as update to :DateAdd("dd",2,[insertdatetime] and criteria as [insertdatetime] but it updated it to 2024-02-27 and left out the time part :(

We receive a csv file daily in which almost most fields are static except for few fields and the date. Since one daily file was missed , someone erroneously updated the Access table with the csv file of a previous date. The date time field is like 2024-02-25 10:18:38 . Is there a way to update...

Hello Everyone, Looking forwards to learn and exchange MS Access knowledge!