Search results

correct, it was the code behind frmDone! it opens the db, runs the code on the form load event and then closes the form and the db. Thanks!

Hi, I inherited a Access database, which runs data downloaded from Wufoo forms. I then run a .vbs script, which saves the excel into a path and then opens the database to import excel data and then run queries. The database part of the code in the .vbs script is as below. ...

Currently, a VBA module in Outlook runs a code where it reads the emails and moves the attachments to a folder in the Share drive and the email with attachment to the archive folder within the mailbox. This action is set up as a Outlook rule. I am using a Access DB to import the contents of the...

Hello, How to run a Outlook rule, which runs a module, from a Access Form Command action? TIA

This morning there was only one item so I was unable to recreate the error. But this is my code, which stopped after the 16th item yesterday. Set OlItems = MYFOLDER.Items 'For Each olMail In OlItems y = olMail.Count Do Until y = 0 If olMail.subject Like...

two things.. it still stopped import after the 16th item, when there was 17 in total. Also, it throws an error at .Name

I modified my code to use Do Loop and count mails first and also used the .Name Set OlItems = MYFOLDER.Items 'For Each olMail In OlItems y = olMail.Count Do Until y = 0 If olMail.subject Like "*Proceeding ID*" Then strFile = olMail & ".XML"...

I am confused by "not deleting the attachments". I am just going through the emails and moving them to a folder. Can you tell me which line(s), I need to modify? Thanks

I modified but still it stops after importing few items.If there are 30+ items, it stops at 18 and I again click the event. Set OlItems = MYFOLDER.Items For Each olMail In OlItems If olMail.subject Like "*Proceeding ID*" Then strFile = olMail & ".XML"...

Can you help with my code with how to loop backwards? TIA

Hi, I had been on vacation and just joined this week. I tried your suggestion but it failed. Probably the For loop wasn't correct. This is my code. How to modify to include your advise? ............................................ Set MYFOLDER =...

I am not sure what you mean by to save all the attachments before moving them? I would need help to modify the above code. Thanks

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!