What is the VBA

[Frank Situmorang]

Hello,

This is my VBA to merge words to all records, but waht I want is I have the
"selec" field, and I just want to merege to what I have selected. what is the
VBA, I am not too good in Access.
Private Sub cmdMergeAll_Click()

Me.Refresh
MergeAllWord ("select * from BukuAngKbyQuery")
'Note that you could use a condtion in the above sql


End Sub
Is this true?
MergeAllWord ("select * from BukuAngKbyQuery Where bukuangkby.Selec= True.")

Thanks for any idea

 

[Clifford Bass]

Hi Frank,

With a slight modification. Get rid of the period after True. Or,
since Selec is, I presume, a Yes/No field, you can also get rid of the = True
part.

Clifford Bass

 

[Frank Situmorang]

Thanks Clifford, yes it is a yes/no field, I just followed your advice and it
works perfectly.

 

[Clifford Bass]

Hi Frank,

Good to hear. You are welcome.

Clifford Bass