Auto Opret af en tabel vha compare

You can use the following

Docmd.Runsql INSERT INTO SOMETABLE (fldtext) VALUES (" & rs1(n).Name & " indeholder værdierne " & rs1(n) & " og " & rs2(n) & ")"

You make a table named fro example SOMETABLE with just one field name for example fldtext.

then you place this line just after the line where Thomas has
besked = besked & .....

You can also empty the table before you start with
Docmd.runsql "DELETE * FROM SOMETABLE"

If you want to remove the warnings which will appear then use

docmd.setwarnings False
and
docmd.setwarnings True

False BEFORE you start running the code
True when your finished

Syntax Error (missing operator) in query expression 'Status indeholder værdierne Active og Deleted'.

? cant see what you have done, can you send it? dktebrsa@europe.lego.com

send

got it :o)

can you send the dB so that I can debug?

im not allowed to do that.

Ok, thought so!
is this the error you get when you run
Docmd.Runsql INSERT INTO SOMETABLE (fldtext) VALUES (" & rs1(n).Name & " indeholder værdierne " & rs1(n) & " og " & rs2(n) & ")"

Syntax Error (missing operator) in query expression 'Status indeholder værdierne Active og Deleted'.
?
what is Active og Deleted, are they field names or something?

Have you ceated the tabel a with the field name?

Yes its when i run the insert sentence.

Status is a fieldname and active and deleted is the two things that status can be.

Yes i have created a table named SOMETABLE and a fieldname called fldtext with the datatype as text.

I found the error myself

Its because there was a need for ' in the beginning and the end of the values sentence.

Docmd.Runsql INSERT INTO SOMETABLE (fldtext) VALUES ('" & rs1(n).Name & " indeholder værdierne " & rs1(n) & " og " & rs2(n) & "')"

OK, I found it too!

Yeah... and made some changes so it looks like this now.

DoCmd.RunSQL ("INSERT INTO SOMETABLE (name, fldtext, fldtext1) VALUES ('" & rs1(n).Name & "','" & rs1(n) & "','" & rs2(n) & "')")

And it works as it should :)

Tnx for the help!

thank you!