Recent content by Spiritwoman

Only able to add one line item for Service Hi again. Doing great with your help and setup a snazzy form with subform that adds a room and calculates the fee plus a prorated fee for additional hours. I can also add a service and all the calculations work as well. (Yay!) However, I can only...

Thanks for the link! I needed that info too.

Re-read your last note and followed your directions and guess what- it worked better :) When I select a ServiceName, how do I make it automatically fill in the appropriate cost? Currently, it offers me a drop down of costs to choose from. I'm making progress! Thanks.

I also deleted all my relationships and started from scratch in a more logical manner, so that fixed the problem with the child form not showing up. Thanks.

I setup the Parent form to use data from the Reservations table. The child form references the Services table. I can create a new reservation from here, but I cannot add a Service. It behaves as though I'm trying to create a new service rather than select an existing one. In the child...

Once my tables are setup correctly, is it better to make the invoice using linked queries or using form/subform? I've tried the form/subform, which displays all the info for whatever I set as parent form, but there is always an error with the child form and it shows blank once I leave design...

Great! Thanks for the speedy response! I removed all the spaces from names and titles. I broke services and amenities into two tables because rental fees for amenities go to the church but service fees go to independent contractors. I thought- in the long run- it would be better to have...

Hi. I'm bumbling along in Access and would appreciate your help. I think I am in way over my head here, so any point in the right direction would be great. I'm creating a reservation database for a church that creates a reservation for a fee per hour, adds an amenity like a stage extension...