Search results

thank you, I was after the code as I do not understand the above and how and where to change my code even after reading the split link, I am in unknown territory now so it not sure what to do next.

Hi Both, it worked (almost) It didnt like the "Loop ArrayVariable"... ? **expected while or until or end of statement ** So it is just grabbing the 1st line from the email and adding it to the database, but at least its grabbing something now. I've tried a few do/loops but it just repeats...

Thanks again Paul, please could you edit my code and repaste with your code in? I've not used a split before so not sure where I'd add it. Thank you

Thanks i'll give this a try. The reason I add a loop it is because the emails could be 800 lines long, so I thought the loop would drop to the next line each time it adds a recordset, until the email body has ended. I'll also try the code without the loop as sugggested. If it helps the email...

Re: Logging Imports Thanks Paul - i updated with your coding but the error remains at line EOF Runtime 91 - Object variable or With Block not set updated below incase i have missed something from your post.. Sub getEmails() Dim olApp As Outlook.Application Dim olNamespace As...

hi - please can someone correct this code. I am scraping an outlook email into access. i can see it is doing that part successfully in the debug.print (immediate) window. i just cant seem to add the recordset to the database file (rst.AddNew) it is failing on "Do until EOF()" i've tried...

appologies, i hadnt called the field names exactly as you'd put before, however after matching them it still came up with the same message "too few parameters, expected 2" on this line. Set rs = CurrentDb.OpenRecordset(MySQL)

tblusers = Assign Percentage, Username tbljobs = Username, Datefield (this has no data in this column)

It stopped at this... Dim rs As dao.Recordset Dim MySQL As String MySQL = " SELECT tblUsers.* " & _ "compile error - invalid outside procedure" This is what I done to see if you can see where i've messed up (as I am clearly a novice)... I created a table called tblusers (with 2 usernames...

Hi thank you for your help, but I'm totally lost on what to put where now. I've tried these, but got the same message. Set rs = Me.[ALLOCATION DATE].OpenRecordset(MySQL) Set rs = Me.[PENDING WITH].OpenRecordset(MySQL) Set rs = Me.[DATA MASTER].OpenRecordset(MySQL)

I copied and pasted your string into a Form After Event.... but it came up with this: "too few parameters, expected 2" on this line. Set rs = CurrentDb.OpenRecordset(MySQL)

Ok so where abouts would I put your statement above please, on the form itself? and how? When I tab through the fields to the bottom of the form it then starts a new blank form. I dont know how many will be logged in 1 day/week, so I'm also not sure how it decides on the next users name? would...

Thank you Both, I'm not too sure where I would set up any of them though... namliam through an UpdateQuery? and Pr2 through a macro? I'll try and add a bit more detail. My Main Table is called DATA MASTER and User Name field is called PENDING WITH, date field ALLOCATION DATE I have got a...

Please can some expert tell me if this is possible, and how it can be done.... I have an access form which 1 person updates daily, but the task after that is split between 2 users. I have got most of the form data automated with a combo box from a supporting table. But I now want to...