Event management (2007)

Topic

New Reply

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?

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

Reply | Quote

Replies

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

Reply | Quote

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.

Reply | Quote

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

Reply | Quote

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?

Reply | Quote

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

Macros

• are easier to write (until you learn VBA) because all the options are available in front of you, but
• do not allow for error handling
• don’t allow you to use variables
• 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.

Reply | Quote

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.

Reply | Quote

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

HTH John

Reply | Quote

Thanks, I will look into this.

Reply | Quote

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.

Reply | Quote