Column3
  Home FAQ Contact Sign in
 
Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...

found 2 articles for 0.239 sec
rst.Columns.Count -- Doug Steele, Microsoft Access MVP http://www.AccessMVP.com/DJSteele (no e-mails, please!) "Bre-x" <cholotron@hotmail.com> wrote in message news:O8ZsrAr8KHA.1892@TK2MSFTNGP05.phx.gbl... > 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     

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
Show full article (0.91Kb) · Show article thread
    

Group: microsoft.public.access.gettingstarted · Group Profile · Search for Column3 in microsoft.public.access.gettingstarted
Author: Bre-x
Date: May 13, 2010 08:22

Show full article (0.66Kb) · Show article thread