Group: microsoft.public.access.gettingstarted · Group Profile · Search for Column3 in microsoft.public.access.gettingstarted
Author: Douglas J. Steele
Date: May 13, 2010 10:30
Thank you, Now how could I find out how many columns are there? If rst!column3 does not exits the code stop executing: "Item not found in this collection" "Arvin Meyer [MVP]" <arvinm@mvps.invalid> wrote in message news:%%23RCBolq8KHA.5900@TK2MSFTNGP04.phx.gbl... In your example, it is the first column and second column, so: objSht.Cells(iRow, 1).Value = rst!column1 objSht
|