Consult to Insert Data

[gatarossi]

Dear all,

I'm trying to insert into another table (ex. table2) some information
from one table (ex. table1), but in one field of table2 I would like
that the consult to insert data put YES for each data added in table2.

How can I do this?

Thanks!!!

André.

 

[ruralguy via AccessMonster.com]

Are you talking about turning OFF the Warning Messages? If you use CurrentDB.
Execute then you get no warnings. If you want to just turn off the Warnings
then DoCmd.SetWarnings False will do that BUT be sure and issue a DoCmd.
SetWarnings True when you are done or you loose all of your warning messages.

 

[John W. Vinson]

Dear all,

I'm trying to insert into another table (ex. table2) some information
from one table (ex. table1), but in one field of table2 I would like
that the consult to insert data put YES for each data added in table2.

How can I do this?

Create an Append query with a calculated field containing the YES - if it's a
yes/no datatype field, use True or -1.

John W. Vinson [MVP]

 

[gatarossi]

Dear RuralGuy/John

John, I think you understand my problem; in one field I need to put
Yes/No, but in another field I need to put some text information. Is
it possible?

RuralGuy, I'm afraid, because I don´t need to turning OFF the Warning
Messages, because I'm doing it in the excel.

Thanks a lot!!!

André.

 

[John W. Vinson]

Dear RuralGuy/John

John, I think you understand my problem; in one field I need to put
Yes/No, but in another field I need to put some text information. Is
it possible?

RuralGuy, I'm afraid, because I don´t need to turning OFF the Warning
Messages, because I'm doing it in the excel.

Thanks a lot!!!

André.

If you are doing this in Excel, you would do better to ask in an Excel
newsgroup. This newsgroup is for the database software Microsoft Access, not
for Excel.

To put text into another field... just put the text in the other field in
exactly the same way. I'm not sure I understand the problem.


John W. Vinson [MVP]