1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.
  2. November Photo Comp is now open with a great new theme.! Come and join in.
    Dismiss Notice

Flower Show Software

Discussion in 'Computer Corner' started by Palazzio, Jan 10, 2018.

  1. Palazzio

    Palazzio Apprentice Gardener

    Joined:
    May 22, 2015
    Messages:
    7
    Gender:
    Male
    Ratings:
    +5
    Hi, I'm looking to see if anyone has set up an Access Database or Excel software to automate paying prize money, counting points etc for their Flower Show. I'm looking for this for out local society and thought I'd ask before trying to set something up. Many thanks.
     
  2. Fat Controller

    Fat Controller Cuddly Scottish Admin! Staff Member

    Joined:
    May 5, 2012
    Messages:
    15,863
    Gender:
    Male
    Occupation:
    Public Transport
    Location:
    At me 'puter, GCHQ Ashford Office, Middlesex
    Ratings:
    +26,126
    I haven't got anything like this, but off the top of my head I would say that Access is going to handle it much better than Excel. Are you reasonably comfortable with Access and VBA?
     
  3. Irmemac

    Irmemac Total Gardener

    Joined:
    Jun 11, 2017
    Messages:
    1,018
    Location:
    West of Scotland
    Ratings:
    +1,649
    I would agree with FC that Access sounds more appropriate than Excel. I haven't designed a flower show database but I have designed them for university and school and find Access much more flexible. My only concern would be the bit about paying prize money automatically, whether you are just looking to create a record or actually carry out a financial transaction. That bit is beyond my knowledge.
     
    • Like Like x 1
    • Fat Controller

      Fat Controller Cuddly Scottish Admin! Staff Member

      Joined:
      May 5, 2012
      Messages:
      15,863
      Gender:
      Male
      Occupation:
      Public Transport
      Location:
      At me 'puter, GCHQ Ashford Office, Middlesex
      Ratings:
      +26,126
      I wouldn't be overly happy with Access processing financial transactions automatically - maybe as part of a process that a specified user can run, but not automatically.
       
    • Palazzio

      Palazzio Apprentice Gardener

      Joined:
      May 22, 2015
      Messages:
      7
      Gender:
      Male
      Ratings:
      +5
      Thanks

      I'm just looking for the calculation of Prize Money not actual paymet
       
    • Fat Controller

      Fat Controller Cuddly Scottish Admin! Staff Member

      Joined:
      May 5, 2012
      Messages:
      15,863
      Gender:
      Male
      Occupation:
      Public Transport
      Location:
      At me 'puter, GCHQ Ashford Office, Middlesex
      Ratings:
      +26,126
      I suppose it depends on how many entries (people), how many stages/parts to the competition, and how much you are looking to be able to hold and show history - - - this is where Access really benefits
       

    Share This Page