Search results

I've added all 10 - No error comes up / still no data displaying

I pasted the following in the first field ID: GetParts(0,[Contents]) I get "Run time error 9 - Subscript out of range" Debug highlights: If UBound(varSplit) > 0 Then For x = 1 To UBound(varSplit) varParts(x) = varSplit(x) After adding all 1-9...

So In my "Main" Query I will just paste GetParts(0, [FieldName]) into the first field???

I have a query called "Main" which contains the following column: "Contents" within Contents it has the following strings: ID#NAME#AGE#DOB#EMAIL Ok so I copied the function into a Module (None Class) Then Created a form button and added: Private Sub Command0_Click() GetParts(0...

Many thanks for your Outlook advice, I have now applied it to my database successfully!!! :) But i'm still struggling with Parsing all those delimited text, even though you provided me with that I still have no clue on where to start. my coding head has completely gone! Do you have a sample...

Apologies. I have linked the .csv file via the wizard (where I can see the data doing to multiple rows.) Basically, I receive data in an email like this: (Outlook linked to Database) #Name#Tel#DOB#POSTCODE#EMAIL#ETC# I then export it to and .csv file then LINK it back to the Database...

new problem with delimited text. I have a field where the user can free text, if they use "=" or "(" ")" or use any other other characters it will cause a new row when importing delimited text. How can i stop this, so all delimited text is on ONE row. I have my .CSV files linked to my database

True, I didn't really want to use the requery method... Using cpu cycles.. I didn't know we could listen to emails.. And prompt access to action it. ..could this be an add on I need to apply to Outlook?... Anyone have experience with doing this?

Basically I've linked my outlook to access on one of my machines, the email contents is delimited.. So the ideal scenerio is... Email comes in... Delimited goes to columns then updates my share point table... I will set the timer to requery every 30 seconds to check for new emails Does this...

This is exactly what I'm trying to achieve.. Is the above possible? Import emails that contain delimited text, add to table as and when a new emails comes in

Apologies you are correct.. So by running this it will create a table and populate rows as and when data comes in... Complete noob in this bit of coding

Hi everyone, Basically i'm trying to link Access to Outlook to retrieve emails , When using the wizard to link outlook folder to Access it fails, i've been informed that this is due to the version of Access they have installed which is a ThinApplication. So i was wondering would it be possible...

You are amazing!! Big thank you! So rather than doing this in a query? I am adding this code to a form? then calling it?

Just wanted to say many thanks for all your replies! you are all very helpful!!! I love this forum! But I'm still struggling with split function, i'm very poor when its comes to using such functions. If possible could you give me more pointers or even a snippet of code relating to that...

Hi everyone, I'm trying to build a query that can parse Delimited text to columns, for example I have the following: ID,Name,Tel,Fax,Email,Directorate,DOB,AOCD,Reg,CD I would like to convert the above in 10 seperate columnns within a query? Is this possible? I know you can import delimited...

I could be wrong, but does this mean that it cant be done then?

Hi all, I'm trying to export my table using the following code: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "incidents", "c:\Incidents.xls", True But unfortunatly I get truncated errors upon export via the vba above. is it not possible to export memo fields to excel via vba...

I found the problem. There was 2 NewLine Characters within the text which was the equals sign "=" Once all "=" were removed all appeared to import correctly. Many thankss for your help!!

Please find attached CSV file Apologies there now commas there semi-colons i've used...anyway It contains 4 fields, 3 of which are non delimited and the 4th field contains lots delimited data, As you will notice, I have wrote ;this is a test;this is a test;this is a test between the...

Hi all I have a csv file with one row containing delimited text via a comma Example 1, James, Smith, Manchester, email, telephone, notes etc.. Think there are 50 comma separations all together. Anyway when I go to import / link my csv into access the data that is on the first row...