Lol, absolutely lame question

[Morris]

Ive got this action query qrySetTransferred. It changes the flag of one
of the yes/no fields from no to yes. I've got no idea how to invoke
this query from VB code? I do not need to collect any recordset, just
run the appending query and continue with my code.. What's the function
for that?

 

[Stefan Hoffmann]

hi Morris,

what has your subject to do with your question?

Ive got this action query qrySetTransferred. It changes the flag of one
of the yes/no fields from no to yes. I've got no idea how to invoke
this query from VB code? I do not need to collect any recordset, just
run the appending query and continue with my code.. What's the function
for that?

DoCmd.OpenQuery "qrySetTransferred"


mfG
--> stefan <--

 

[Guest]

Here you go;

DoCmd.openquery "qrySetTransferred"


Steve.

 

[Morris]

hi Morris,

what has your subject to do with your question?

Thanks for help.

Well the next person who wouldn't know how to do it realizing, hwo
simple must that be will look for "absolutely lame question" in google


Cheers