Results 1 to 10 of 10
  1. #1
    5 Star Lounger
    Join Date
    Oct 2001
    Location
    San Bernardino, California, USA
    Posts
    734
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Event management (2007)

    A friend asked for some help (that means me doing the work) in creating a database application to manage a party rental business where events are booked, servers are scheduled for these events, vendors (caterers, magicians, musicians, etc.) booked, and a number of reports can be printed including delivery sheets for the events. I have not found such an application on-line so will probably create it in Access but wanted to first ask here if anyone has seen such an app?

    <span style="background-color: #FFFF00; color: #000000; font-weight: bold">Note this was originally posted in the Other S/W applications forum with no response. Requirements have changed slightly so I have modified and reposted here where it may be more appropriate</span hi>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Event management (2007)

    RentMaster rental software is geared towards party rental and event planning. It's not free, but you can download a 30-day evaluation copy.

  3. #3
    5 Star Lounger
    Join Date
    Oct 2001
    Location
    San Bernardino, California, USA
    Posts
    734
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Event management (2007)

    Thanks Hans, i will take a look at it. I would sure like to find something in Access, though, as I am certain there will be customization needed.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Event management (2007)

    I've searched extensively, but I haven't been able to find an Access template for this purpose, sorry.

  5. #5
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Event management (2007)

    Don

    You may be able to find components for your system for the price of a book

    Check out the following

    Re: How do I keep resource schedule from overlapping? (2000)
    <post#=483438>post 483438</post#>

    HTH John

  6. #6
    5 Star Lounger
    Join Date
    Oct 2001
    Location
    San Bernardino, California, USA
    Posts
    734
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Event management (2007)

    Thanks - I saw that.. it may provide inspiration but I really hate installing apps only to remove them later...they are never fully removed. I like the interface in rentmaster.

  7. #7
    5 Star Lounger
    Join Date
    Oct 2001
    Location
    San Bernardino, California, USA
    Posts
    734
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Event management (2007)

    Thanks, I will look into this.

  8. #8
    5 Star Lounger
    Join Date
    Oct 2001
    Location
    San Bernardino, California, USA
    Posts
    734
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Event management (2007)

    I found a couple on the Microsoft site and I like this one the best. I will be asking some questions about it as I don't understand some of the inner workings. For example, I notice that some controls use event procedures while others use macros... when is it appropriate to use a macro rather than an event procedure? Or the other way around?

  9. #9
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Event management (2007)

    You can use whatever you like, whenever you like...but

    Macros
    <UL><LI> are easier to write (until you learn VBA) because all the options are available in front of you, but
    <LI>do not allow for error handling
    <LI>don't allow you to use variables
    <LI>don't do everything that VBA does[/list]In 2007 they have improved macros by adding error handling and allowed variables to be used, and microsoft promotes them as safer than VBA (hence the security stuff you bumped into the other day). But I think most people who have become used to writing VBA will keep doing it.

    I suspect in this case they have done a bit of both just to show you the alternatives.
    Regards
    John



  10. #10
    5 Star Lounger
    Join Date
    Oct 2001
    Location
    San Bernardino, California, USA
    Posts
    734
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Event management (2007)

    Okay, thank - that clears things up for me. I don't really know VBA but I have picked up a lot of pointers here on Woody's and i can even writ some simple code myself. More importantly, I am getting better at understanding what I read in other code and am able to made modifications to fit my needs.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •