Export to Word Table

[gstylianou]

Good morning my friend June7



Many thanks for you time and your help. Today i cannot check about the issue but i will do it tomorrow and i will let you know.

As an idea in order to fix the problem i want to tell you that, if you want we can work through skype and teamviewer .

[June7]

No Skype, not sure about Teamviewer.

[gstylianou]

Good morning my friend June7,

Now, the code works but when the word open is just write the no 157 on monday and breakfast..??????

As you can see on the attached pictures, i have selected 2 foods and then by pressing the command i'm getting the above number..

Please do something my friend...

Thanks in advance

[June7]

I have no idea where the 157 is coming from.

Would have to see your latest code.

[gstylianou]

Good morning

Maybe because the field "Food" its combo? Maybe must check this field and change the type?

Thanks

[June7]

Shouldn't matter if it is a combobox or textbox.

Why is the MealCode field in tblFoodAnalysis a multi-value? This might be part of the problem. I NEVER use multi-value field. Also, this field has a lookup set in the table.

Here is the database I built to replicate yours. That's really the limit of what I will be able to do to help.

[gstylianou]

Good morning my friend June7 and thank you very much for your help..

I god your sample but cannot open it because i'm using access 2007...

Thanks again.

[June7]

Access 2007 should be able to open it. I didn't use any 2010-exclusive features but Access seems to think I did. Here is mdb version.

[gstylianou]

Hi June7,

Its totally amazing... I'm trying to check your sample but when i tried to use the command i'm getting the attached error.. Really don't know how can i solve the proplem.. Really, it's so difficult to export these data from my database to word using vba?

Regards

[June7]

I don't know why this fails for you. I used your Word document with my db code.