Search results

Hi there, so thanks to Joe I now have a working (kind of) exercise database, the only problem is that it stores by workoutID and I want it to store by MemberNo, with each member able to have 3 workouts maximum, can anyone help me with this, I have attached a copy of my database for you to look...

Hi there, thanks so much for this again. How would I go about getting the form to sort the workouts by membership number, is it as simple as adding MembershipNo as a forgien key in the workout table? I've editied the rest of the form to get what I need from it, I have an add exercises form and...

I know that code "should" work but I keep getting a syntax error after I put it in. Can you explain exactly where I have to enter it? Sorry about this.

I cant seem to get this to work. P.S My members table is "Customers" and my attendance table (where the AttendDate is stored, with MembershipNo as a FKey) is "Attendance" I've tried changing your code while changing your table names for my own but that doesnt work, infact I get a syntax error...

Do i put this in the query builder under criteria or somewhere else? Sorry I am really bad when it comes to building queries! in reply to DatabaseDonr I already have the relevant info (name, address etc) on the query im just trying to figure out this last thing!

The problem is that the attendance table records *every* date the member came in, therefore I need to select the more current date they attended and compare this to todays date using the query you wrote above.

Nobody has any idea how to do this?

Thanks that would be great! Pat has been a great help but, I hate to say this but I dont think I have the visualisation to get around what he is saying, even though I know it makes perfect sense! It would be great to have a look at a finished example to see how you got to where you did, as the...

Hi, I want to create a simple training form which would allow a personal trainer to input a series of exercise types, name, sets / reps for a member which then could be printed out as a "Session" for them. I have completed the rest of the database which deals with members, payment and so on...

Hi there, I have created a gym database, within it you can push a button each time a member attends and the date they attended is stored in a table "Attendance", multiple values are stored in this table because i want to see each time the member attends. The problem comes when I went to create...

Perfect, Thanks! Is there anyway I could encorporate that code into my query? Or do I have to try the SQL code above

Hi there, I am trying to put a query on my form which selects the most recent date of a members attendance from an attendance table and displays it in a text box, the code I am using is: Private Sub Text41_BeforeUpdate(Cancel As Integer) SELECT MAX(Attendance.AttendDate) as "LastAttended" FROM...

Thanks SO much for laying the tables out in a way I understand, As I probabbly mentioned I have to have this up and running for the gym on Wednesday! If I am being rude I apologise but how could I best fit this into a form, or forms. I've linked below to a rough layout of what I kind of wanted...

Thanks, now I just need to figure out how to put this into a form!

I'm trying to set up a training program for my gym database but I'm having alot of problems, I will be in debt to anyone who can help me out! My current "training" tables" ExAttributes ExID - PKEY ExType - (Sets, Reps etc) ExerciseTypes ExerciseID - PKEY TrainingType - (Lookup from...

I know there are other threads on this but I have tried all the solutions and none have worked. I currently have 2 forms, a customer form and a customer health form. I want to pass the membershipNo from the customer form to a newly opened customer health form. this is the code I am using but...

Hi, I have had a gym database designed for me by a friend, he had to give me an unfinished product and now I have been left with some problems and 1 week until my gym opens. My problems are as follows: I need to have a system on the database whereby you can goto a customers record when they...

Hi, sorry to Hijack this thread but the problem for you seems to be solved so no point in making another, i want *Exactly* the same thing except I dont have an expiry date in my table, i have another table with membership type .. this can be changed or upgraded etc. So say the member joined on...

Hi, based on previous advice I had merged my customers and owners into one table and selected whether a client was a customer, owner or both via a lookup table. This is working fine, however I must assign a rep to each owner, I'm not quite sure how to do this, I need to be able to assign a rep...

Well lets see, I've made alot of changes to the database now, such as taking out the spaces in object names and combining tables to make things easier, maybe someone could look into my database and give some advice. To the above poster, thanks, I will try to sort out a query for the booking...