Recent content by DCXtreme

Hi there, I have this sports center database. Basically what I have is a appointments or "bookings" form which I want to be able to modify to be able to add / delete groups that want to book time in the sports center, whenever I try to do this though however the bookings fail to show up on...

Hi again, I have now come to the point where I need to setup a billing section (although the Large Calendar problem is not fixed) I was wondering if you had any further advice.

No you're right there is no billing query. I actually have found out why it doesnt work on my computer. It is using the US dates format, but my copy of access / windows uses the UK time and date format. When I click on September the 12th 12/09 is get December the 9th Any easy way of fixing this?

What version of office did you try it with? I have office 2007 beta - probabbly why, I can work out the billing section of it myself I think. I think i'll have to get my hands on office 2003 to see if it works!

Its one big room. Edit: infact I found the perfect thing for it, its attached, however I am having great problems trying to get it to work - are there any obvious code errors you can spot?

Hi There guys, I need to create a timetable for my sports center database, the center is hired out monday - sunday in half hour slots, i would in effect need a calander with places to input each booking every 30 minutes. Can this be done, has it been done before? Jon

Damn, that really messes up my plans, don't really know why it cant show both!

Sorry small typo! I have it minus cardio. It currently shows sets, weight and reps

Ok, I had a hunch that weight and cardio wouldnt work together. I now have a query which works perfectly to show all the information minus the weights, how could I put cardio into there with the minimal amount of fuss? I've sorted the query names etc too :)

Thanks again Joe! I am having the worst kind of trouble trying to get a report on the workouts for a certain member, it just shows workouts for exeryone, and only shows the first exercise. Any ideas anyone, the query is called tblWorkoutQuery

I have my exercise database designed and I wanted to make a report which will show all of the exercises a specific member has scheduled within a 2 week period from the current day. I want to display the following information: Membership No First Name / Last Name Date of Workout Exercise Name...

THanks again Joe thats great! exactly what I wanted, unfortunatly I cant seem to attach it to a membership number now like I did before, this is my FINAL problem, honest! then I can put it to use starting this weekend. The gym is in pendine, west wales! Attached my "attempt" at incorporating...

Have people just been stealing my exercise database? :p 14 views and not one reply! Joe I could really do with your help here I think I've messed things up big time, attached my *attempt* at a cardio/strength form.

I wouldnt be looking at code to do that really. I would just do a query to tell access to pull out all workouts for a certain member within a 2 week period (i kept the date field in). So basically the % thing would not be needed, I may just print out weekly ones which they pick up monday, and...

What I wanted to do in that aspect you talked about last was print out a 2 week plan for a customer if they wanted me to set one up for them, obviously the exercises and weights would get heavier as the weeks progress, this could then be printed off and kept by them for reference. As for...