Running list of a fourways garden bird list

  • mossie
  • mossie's Avatar
  • Visitor
  • Visitor
8 years 3 weeks ago #13253 by mossie
mossie replied the topic: Re: Running list of a fourways garden bird list
Anything to get to 900! :)

Please Log in or Create an account to join the conversation.

  • Doug
  • Doug's Avatar Topic Author
  • Visitor
  • Visitor
8 years 3 weeks ago #13256 by Doug
Doug replied the topic: Re: Running list of a fourways garden bird list
If you have a listing program you can get to 957 in 34 seconds. I have timed it :D
Use the following code

For x = 1 to 957

Set rs = New ADODB.Recordset
rs.Open "SELECT * FROM Sightings WHERE Sightings.Birdnum = " & X , con, adOpenDynamic, adLockPessimistic

rs.seen = "Yes"
rs.Update


rs.Close
next X

MsgBox "Well done! You have seen them all."



Hey presto... you've seen them all.
<!-- s:rotfl: --><img src="{SMILIES_PATH}/rotfl.gif" alt=":rotfl:" title="Laughing" /><!-- s:rotfl: --> <!-- s:rotfl: --><img src="{SMILIES_PATH}/rotfl.gif" alt=":rotfl:" title="Laughing" /><!-- s:rotfl: --> <!-- s:bouncy: --><img src="{SMILIES_PATH}/bouncy.gif" alt=":bouncy:" title="Enthusiastic" /><!-- s:bouncy: -->

Please Log in or Create an account to join the conversation.

  • Dave Shedman
  • Dave Shedman's Avatar
  • Visitor
  • Visitor
8 years 3 weeks ago #13257 by Dave Shedman
Dave Shedman replied the topic: Re: Running list of a fourways garden bird list
I've seen them all - in books! <!-- s:lol: --><img src="{SMILIES_PATH}/icon_lol.gif" alt=":lol:" title="Laughing" /><!-- s:lol: -->

Ô¿Ô

Please Log in or Create an account to join the conversation.

  • Doug
  • Doug's Avatar Topic Author
  • Visitor
  • Visitor
8 years 3 weeks ago #13258 by Doug
Doug replied the topic: Re: Running list of a fourways garden bird list
I have more books than you so I have seen more than you so there :P <!-- s:bouncy: --><img src="{SMILIES_PATH}/bouncy.gif" alt=":bouncy:" title="Enthusiastic" /><!-- s:bouncy: --> :D

Please Log in or Create an account to join the conversation.

  • Dave Shedman
  • Dave Shedman's Avatar
  • Visitor
  • Visitor
8 years 3 weeks ago #13259 by Dave Shedman
Dave Shedman replied the topic: Re: Running list of a fourways garden bird list

Doug wrote: I have more books than you so I have seen more than you so there :P <!-- s:bouncy: --><img src="{SMILIES_PATH}/bouncy.gif" alt=":bouncy:" title="Enthusiastic" /><!-- s:bouncy: --> :D


Most people have more birding books than me, even non-birders! <!-- s:shock: --><img src="{SMILIES_PATH}/icon_eek.gif" alt=":shock:" title="Shocked" /><!-- s:shock: -->

Ô¿Ô

Please Log in or Create an account to join the conversation.

  • Doug
  • Doug's Avatar Topic Author
  • Visitor
  • Visitor
8 years 3 weeks ago #13289 by Doug
Doug replied the topic: Re: Running list of a fourways garden bird list
summer is starting to grow the list with Europen Bee-eater as well as Black-throated Canary!

Please Log in or Create an account to join the conversation.

Powered by Kunena Forum