Search results

TIA, How to get just the value, 50000000 from /FAMT/50000000,

At my work, I WinSCP to a folder where all these files of R01 file type reside. I need to import this and then parse the data into respective fields.

What is R01 file type and how can I import it into an Access table? TIA

in Access query, I am not sure if "Exists" can be used

Hi, Is there a way to delete the second occurrence from a table entry where there are duplicates sessions? For example, I need to delete the second occurrence of CDS4 since a Registrant cannot attend two courses in the same session. I need a query which deletes the second occurrence of all...

ahh...I missed a folder in between :( It's now outputting. Still not totally recovered from the weekend ....

My actual code is Public Function ExportTblToExcel() Dim FullFilePath As String Dim sDateTimeStamp As String Dim sFolderLocation As String Dim SourceFile, DestinationFile As String sDateTimeStamp = CStr(Year(Now())) & _ Pad(CStr(Month(Now())), 2) & _...

Hi, I am trying to save my file to a location in another server My SourceFile is in CurrentProject.Path My DestinationFile is something like " \\xx.xxx.xx.xxx\backup\LReports\ & "\" & "reportName_" & sDateTimeStamp & ".xlsm" When I try FileCopy SourceFile, DestinationFile, I get an error in...

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