If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#21
|
|||
|
|||
creating new database
LTOSH,
Is not the bound field for your list box ClientID? If it is not thatis the syntax error. To find out which field is the bound field...tell me what columns you have in your list box and which one is first, second... In the NameOfYourListBox goes the name of the list box from the form that has the button on it. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... yes Deeeeeeep breath...sorry get OCD when it comes to this hahaha. ok, in your code below. Do i put in the [nameofyourlistbox] the "workout date" for that list box? is that right or which listbox? when i put it in my code...the is the error i get...Syntax error (missing operator) in query expression '[ClientID]='. "Gina Whipp" wrote: Private Sub Add_Workout_Click() On Error GoTo Err_Add_Workout_Click DoCmd.OpenForm "Workout Details", , , "[ClientID]=" & Me![NameOfYourListBox] Exit_Add_Workout_Click: Exit Sub Err_Add_Workout_Click: MsgBox Err.Description Resume Exit_Add_Workout_Click End Sub -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... Private Sub Add_Workout_Click() On Error GoTo Err_Add_Workout_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "Workout Details" DoCmd.OpenForm stDocName, , , stLinkCriteria Exit_Add_Workout_Click: Exit Sub Err_Add_Workout_Click: MsgBox Err.Description Resume Exit_Add_Workout_Click End Sub This is on my weightlifting form...the button is Add Workout. This opens the Workout details screen. this is where i could type the workout date. then there is a command button named add exercise. here is the code for this button. Private Sub Add_Exercise_Click() On Error GoTo Err_Add_Exercise_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "Add Exercise" DoCmd.OpenForm stDocName, , , stLinkCriteria Exit_Add_Exercise_Click: Exit Sub Err_Add_Exercise_Click: MsgBox Err.Description Resume Exit_Add_Exercise_Click End Sub This opens a form to add the exercise that is a combo box so i can pick the exercise i want to add, then fill in sets, reps weight. i am able to do all this but it is not client specific. maybe i'm making this harder than it has to be? "Gina Whipp" wrote: You have a button that is opening the form but not with the correct information, so... Go to deisgn mode of the form that has the button... Click on the button and bring up properties and then go do to the On-Click event procedure and click the button with the dots on it... Then copy everything between Private Sub and End Sub -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... ClientID is my PK and is autonumber. copy/paste what code?? where do i get the code you are asking for? "Gina Whipp" wrote: LTOSH, Please copy/paste the code you are using and is ClientID text or numeric? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... my forms are opening fine. it's the information that is not associating with the specific client. eventhough i click one specific client and go into the weightlifting page and adding information it is not associated with that one specific client. does that make sense? "Gina Whipp" wrote: LTOSH, "...I'm a 'her' hehehe..." Oops, my mistake... Sorry about that! Did you try to use the command button wizard? If the wizard failed then tell me the exact name of the form(s) you are strying to open. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... Hi Gina...thanks for support here! By the way...I'm a 'her' hehehe. ok...here is where i am and need help i think with relationships. As i stated in first email i want to click a client name then add information specific only to that client. Here is what i have going on. Main Switchboard I have a list box with client name. Then I have command buttons to take me to other specific switchboards (ex. Weightlifting, Cardio). I want to click the client name then click the command button "WEIGHTLIFTING" to take me to this switchboard. Once on the "WEIGHTLIFTING" screen i have a list box "workout date" and a listbox "Workout". Here is where i want the relationship of "workout date' and "client" to be associated, to be specific to this client. I also want "workout date" to be specific to specific dates. Example. for 02/07/09 i have chosen specific exercises. for 02/08/09 i want specific exercises. How do i make these associations or relationships? i hope i make sense. Just for clarity...i have 3 tables..."CLIENT" "EXERCISES" "WORKOUT" "WORKOUT" table is where the new created workouts would be stored. Thanks so much for help! This is so exciting this coming together. "Gina Whipp" wrote: Keith, In his first eMail he asked about his table set-up and he now has a Client table, Exercise table and a Workout table pulling those the first two tables togehter. You might not have seen those postings, -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Keith Wilby" wrote in message ... "LTOSH" wrote in message ... i have a form (using as switchboard) where i want to put a command button to create workout. how can i put on that popup form a small window on the left that lists clients to click...then a window like a datasheet on the right Whoa! First things first! Get your tables, relationships and indexing sorted out before you start thinking about whistles and bells in your GUI. If you don't have a solid foundation of tables to build your application on then it may well end up collapsing around you and you'll have some re-work at the very least. 2p supplied Keith. www.keithwilby.co.uk |
#22
|
|||
|
|||
creating new database
In my client table...ClientID is the PK
In my Workout table...WorkoutID is the PK, then ClientID is next data type is number, then ExerciseID is next data type is number. in my form "Weightlifting" there is a listbox "Workout Date" (appears to be unbound, that is what it says in box in design form). the Command Button on that form that you gave me the code for is called "add workout" this is to open my "add exercise" form. i'm sorry i'm just struggling with this. thanks for your patience! "Gina Whipp" wrote: LTOSH, Is not the bound field for your list box ClientID? If it is not thatis the syntax error. To find out which field is the bound field...tell me what columns you have in your list box and which one is first, second... In the NameOfYourListBox goes the name of the list box from the form that has the button on it. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... yes Deeeeeeep breath...sorry get OCD when it comes to this hahaha. ok, in your code below. Do i put in the [nameofyourlistbox] the "workout date" for that list box? is that right or which listbox? when i put it in my code...the is the error i get...Syntax error (missing operator) in query expression '[ClientID]='. "Gina Whipp" wrote: Private Sub Add_Workout_Click() On Error GoTo Err_Add_Workout_Click DoCmd.OpenForm "Workout Details", , , "[ClientID]=" & Me![NameOfYourListBox] Exit_Add_Workout_Click: Exit Sub Err_Add_Workout_Click: MsgBox Err.Description Resume Exit_Add_Workout_Click End Sub -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... Private Sub Add_Workout_Click() On Error GoTo Err_Add_Workout_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "Workout Details" DoCmd.OpenForm stDocName, , , stLinkCriteria Exit_Add_Workout_Click: Exit Sub Err_Add_Workout_Click: MsgBox Err.Description Resume Exit_Add_Workout_Click End Sub This is on my weightlifting form...the button is Add Workout. This opens the Workout details screen. this is where i could type the workout date. then there is a command button named add exercise. here is the code for this button. Private Sub Add_Exercise_Click() On Error GoTo Err_Add_Exercise_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "Add Exercise" DoCmd.OpenForm stDocName, , , stLinkCriteria Exit_Add_Exercise_Click: Exit Sub Err_Add_Exercise_Click: MsgBox Err.Description Resume Exit_Add_Exercise_Click End Sub This opens a form to add the exercise that is a combo box so i can pick the exercise i want to add, then fill in sets, reps weight. i am able to do all this but it is not client specific. maybe i'm making this harder than it has to be? "Gina Whipp" wrote: You have a button that is opening the form but not with the correct information, so... Go to deisgn mode of the form that has the button... Click on the button and bring up properties and then go do to the On-Click event procedure and click the button with the dots on it... Then copy everything between Private Sub and End Sub -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... ClientID is my PK and is autonumber. copy/paste what code?? where do i get the code you are asking for? "Gina Whipp" wrote: LTOSH, Please copy/paste the code you are using and is ClientID text or numeric? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... my forms are opening fine. it's the information that is not associating with the specific client. eventhough i click one specific client and go into the weightlifting page and adding information it is not associated with that one specific client. does that make sense? "Gina Whipp" wrote: LTOSH, "...I'm a 'her' hehehe..." Oops, my mistake... Sorry about that! Did you try to use the command button wizard? If the wizard failed then tell me the exact name of the form(s) you are strying to open. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... Hi Gina...thanks for support here! By the way...I'm a 'her' hehehe. ok...here is where i am and need help i think with relationships. As i stated in first email i want to click a client name then add information specific only to that client. Here is what i have going on. Main Switchboard I have a list box with client name. Then I have command buttons to take me to other specific switchboards (ex. Weightlifting, Cardio). I want to click the client name then click the command button "WEIGHTLIFTING" to take me to this switchboard. Once on the "WEIGHTLIFTING" screen i have a list box "workout date" and a listbox "Workout". Here is where i want the relationship of "workout date' and "client" to be associated, to be specific to this client. I also want "workout date" to be specific to specific dates. Example. for 02/07/09 i have chosen specific exercises. for 02/08/09 i want specific exercises. How do i make these associations or relationships? i hope i make sense. Just for clarity...i have 3 tables..."CLIENT" "EXERCISES" "WORKOUT" "WORKOUT" table is where the new created workouts would be stored. Thanks so much for help! This is so exciting this coming together. "Gina Whipp" wrote: Keith, In his first eMail he asked about his table set-up and he now has a Client table, Exercise table and a Workout table pulling those the first two tables togehter. You might not have seen those postings, -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Keith Wilby" wrote in message ... "LTOSH" wrote in message ... i have a form (using as switchboard) where i want to put a command button to create workout. how can i put on that popup form a small window on the left that lists clients to click...then a window like a datasheet on the right Whoa! First things first! Get your tables, relationships and indexing sorted out before you start thinking about whistles and bells in your GUI. If you don't have a solid foundation of tables to build your application on then it may well end up collapsing around you and you'll have some re-work at the very least. 2p supplied |
#23
|
|||
|
|||
creating new database
LTOSH,
You're not struggling... you're learning! Let's start at the first form... You open that up and there is a list box containing all the Clients. What are the columns in the list box? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... In my client table...ClientID is the PK In my Workout table...WorkoutID is the PK, then ClientID is next data type is number, then ExerciseID is next data type is number. in my form "Weightlifting" there is a listbox "Workout Date" (appears to be unbound, that is what it says in box in design form). the Command Button on that form that you gave me the code for is called "add workout" this is to open my "add exercise" form. i'm sorry i'm just struggling with this. thanks for your patience! "Gina Whipp" wrote: LTOSH, Is not the bound field for your list box ClientID? If it is not thatis the syntax error. To find out which field is the bound field...tell me what columns you have in your list box and which one is first, second... In the NameOfYourListBox goes the name of the list box from the form that has the button on it. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... yes Deeeeeeep breath...sorry get OCD when it comes to this hahaha. ok, in your code below. Do i put in the [nameofyourlistbox] the "workout date" for that list box? is that right or which listbox? when i put it in my code...the is the error i get...Syntax error (missing operator) in query expression '[ClientID]='. "Gina Whipp" wrote: Private Sub Add_Workout_Click() On Error GoTo Err_Add_Workout_Click DoCmd.OpenForm "Workout Details", , , "[ClientID]=" & Me![NameOfYourListBox] Exit_Add_Workout_Click: Exit Sub Err_Add_Workout_Click: MsgBox Err.Description Resume Exit_Add_Workout_Click End Sub -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... Private Sub Add_Workout_Click() On Error GoTo Err_Add_Workout_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "Workout Details" DoCmd.OpenForm stDocName, , , stLinkCriteria Exit_Add_Workout_Click: Exit Sub Err_Add_Workout_Click: MsgBox Err.Description Resume Exit_Add_Workout_Click End Sub This is on my weightlifting form...the button is Add Workout. This opens the Workout details screen. this is where i could type the workout date. then there is a command button named add exercise. here is the code for this button. Private Sub Add_Exercise_Click() On Error GoTo Err_Add_Exercise_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "Add Exercise" DoCmd.OpenForm stDocName, , , stLinkCriteria Exit_Add_Exercise_Click: Exit Sub Err_Add_Exercise_Click: MsgBox Err.Description Resume Exit_Add_Exercise_Click End Sub This opens a form to add the exercise that is a combo box so i can pick the exercise i want to add, then fill in sets, reps weight. i am able to do all this but it is not client specific. maybe i'm making this harder than it has to be? "Gina Whipp" wrote: You have a button that is opening the form but not with the correct information, so... Go to deisgn mode of the form that has the button... Click on the button and bring up properties and then go do to the On-Click event procedure and click the button with the dots on it... Then copy everything between Private Sub and End Sub -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... ClientID is my PK and is autonumber. copy/paste what code?? where do i get the code you are asking for? "Gina Whipp" wrote: LTOSH, Please copy/paste the code you are using and is ClientID text or numeric? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... my forms are opening fine. it's the information that is not associating with the specific client. eventhough i click one specific client and go into the weightlifting page and adding information it is not associated with that one specific client. does that make sense? "Gina Whipp" wrote: LTOSH, "...I'm a 'her' hehehe..." Oops, my mistake... Sorry about that! Did you try to use the command button wizard? If the wizard failed then tell me the exact name of the form(s) you are strying to open. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... Hi Gina...thanks for support here! By the way...I'm a 'her' hehehe. ok...here is where i am and need help i think with relationships. As i stated in first email i want to click a client name then add information specific only to that client. Here is what i have going on. Main Switchboard I have a list box with client name. Then I have command buttons to take me to other specific switchboards (ex. Weightlifting, Cardio). I want to click the client name then click the command button "WEIGHTLIFTING" to take me to this switchboard. Once on the "WEIGHTLIFTING" screen i have a list box "workout date" and a listbox "Workout". Here is where i want the relationship of "workout date' and "client" to be associated, to be specific to this client. I also want "workout date" to be specific to specific dates. Example. for 02/07/09 i have chosen specific exercises. for 02/08/09 i want specific exercises. How do i make these associations or relationships? i hope i make sense. Just for clarity...i have 3 tables..."CLIENT" "EXERCISES" "WORKOUT" "WORKOUT" table is where the new created workouts would be stored. Thanks so much for help! This is so exciting this coming together. "Gina Whipp" wrote: Keith, In his first eMail he asked about his table set-up and he now has a Client table, Exercise table and a Workout table pulling those the first two tables togehter. You might not have seen those postings, -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Keith Wilby" wrote in message ... "LTOSH" wrote in message ... i have a form (using as switchboard) where i want to put a command button to create workout. how can i put on that popup form a small window on the left that lists clients to click...then a window like a datasheet on the right Whoa! First things first! Get your tables, relationships and indexing sorted out before you start thinking about whistles and bells in your GUI. If you don't have a solid foundation of tables to build your application on then it may well end up collapsing around you and you'll have some re-work at the very least. 2p supplied |
#24
|
|||
|
|||
creating new database
thanks for understanding!
ok the first form... the list box "client list"...is from a Client Name Query i created so i could combine the first and last name together. the only column that is in that query that is shown is Client Name. "Gina Whipp" wrote: LTOSH, You're not struggling... you're learning! Let's start at the first form... You open that up and there is a list box containing all the Clients. What are the columns in the list box? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... In my client table...ClientID is the PK In my Workout table...WorkoutID is the PK, then ClientID is next data type is number, then ExerciseID is next data type is number. in my form "Weightlifting" there is a listbox "Workout Date" (appears to be unbound, that is what it says in box in design form). the Command Button on that form that you gave me the code for is called "add workout" this is to open my "add exercise" form. i'm sorry i'm just struggling with this. thanks for your patience! "Gina Whipp" wrote: LTOSH, Is not the bound field for your list box ClientID? If it is not thatis the syntax error. To find out which field is the bound field...tell me what columns you have in your list box and which one is first, second... In the NameOfYourListBox goes the name of the list box from the form that has the button on it. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... yes Deeeeeeep breath...sorry get OCD when it comes to this hahaha. ok, in your code below. Do i put in the [nameofyourlistbox] the "workout date" for that list box? is that right or which listbox? when i put it in my code...the is the error i get...Syntax error (missing operator) in query expression '[ClientID]='. "Gina Whipp" wrote: Private Sub Add_Workout_Click() On Error GoTo Err_Add_Workout_Click DoCmd.OpenForm "Workout Details", , , "[ClientID]=" & Me![NameOfYourListBox] Exit_Add_Workout_Click: Exit Sub Err_Add_Workout_Click: MsgBox Err.Description Resume Exit_Add_Workout_Click End Sub -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... Private Sub Add_Workout_Click() On Error GoTo Err_Add_Workout_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "Workout Details" DoCmd.OpenForm stDocName, , , stLinkCriteria Exit_Add_Workout_Click: Exit Sub Err_Add_Workout_Click: MsgBox Err.Description Resume Exit_Add_Workout_Click End Sub This is on my weightlifting form...the button is Add Workout. This opens the Workout details screen. this is where i could type the workout date. then there is a command button named add exercise. here is the code for this button. Private Sub Add_Exercise_Click() On Error GoTo Err_Add_Exercise_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "Add Exercise" DoCmd.OpenForm stDocName, , , stLinkCriteria Exit_Add_Exercise_Click: Exit Sub Err_Add_Exercise_Click: MsgBox Err.Description Resume Exit_Add_Exercise_Click End Sub This opens a form to add the exercise that is a combo box so i can pick the exercise i want to add, then fill in sets, reps weight. i am able to do all this but it is not client specific. maybe i'm making this harder than it has to be? "Gina Whipp" wrote: You have a button that is opening the form but not with the correct information, so... Go to deisgn mode of the form that has the button... Click on the button and bring up properties and then go do to the On-Click event procedure and click the button with the dots on it... Then copy everything between Private Sub and End Sub -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... ClientID is my PK and is autonumber. copy/paste what code?? where do i get the code you are asking for? "Gina Whipp" wrote: LTOSH, Please copy/paste the code you are using and is ClientID text or numeric? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... my forms are opening fine. it's the information that is not associating with the specific client. eventhough i click one specific client and go into the weightlifting page and adding information it is not associated with that one specific client. does that make sense? "Gina Whipp" wrote: LTOSH, "...I'm a 'her' hehehe..." Oops, my mistake... Sorry about that! Did you try to use the command button wizard? If the wizard failed then tell me the exact name of the form(s) you are strying to open. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... Hi Gina...thanks for support here! By the way...I'm a 'her' hehehe. ok...here is where i am and need help i think with relationships. As i stated in first email i want to click a client name then add information specific only to that client. Here is what i have going on. Main Switchboard I have a list box with client name. Then I have command buttons to take me to other specific switchboards (ex. Weightlifting, Cardio). I want to click the client name then click the command button "WEIGHTLIFTING" to take me to this switchboard. Once on the "WEIGHTLIFTING" screen i have a list box "workout date" and a listbox "Workout". Here is where i want the relationship of "workout date' and "client" to be associated, to be specific to this client. I also want "workout date" to be specific to specific dates. Example. for 02/07/09 i have chosen specific exercises. for 02/08/09 i want specific exercises. How do i make these associations or relationships? i hope i make sense. Just for clarity...i have 3 tables..."CLIENT" "EXERCISES" "WORKOUT" "WORKOUT" table is where the new created workouts would be stored. Thanks so much for help! This is so exciting this coming together. "Gina Whipp" wrote: Keith, In his first eMail he asked about his table set-up and he now has a Client table, Exercise table and a Workout table pulling those the first |
#25
|
|||
|
|||
creating new database
You need two columns, so I need you to add ClientID before Client Name in
our query. Then for your list box, in design mode, Column Count = 2, Column Widths = 0";1.5", Bound Coulmn = 1 -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... thanks for understanding! ok the first form... the list box "client list"...is from a Client Name Query i created so i could combine the first and last name together. the only column that is in that query that is shown is Client Name. "Gina Whipp" wrote: LTOSH, You're not struggling... you're learning! Let's start at the first form... You open that up and there is a list box containing all the Clients. What are the columns in the list box? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... In my client table...ClientID is the PK In my Workout table...WorkoutID is the PK, then ClientID is next data type is number, then ExerciseID is next data type is number. in my form "Weightlifting" there is a listbox "Workout Date" (appears to be unbound, that is what it says in box in design form). the Command Button on that form that you gave me the code for is called "add workout" this is to open my "add exercise" form. i'm sorry i'm just struggling with this. thanks for your patience! "Gina Whipp" wrote: LTOSH, Is not the bound field for your list box ClientID? If it is not thatis the syntax error. To find out which field is the bound field...tell me what columns you have in your list box and which one is first, second... In the NameOfYourListBox goes the name of the list box from the form that has the button on it. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... yes Deeeeeeep breath...sorry get OCD when it comes to this hahaha. ok, in your code below. Do i put in the [nameofyourlistbox] the "workout date" for that list box? is that right or which listbox? when i put it in my code...the is the error i get...Syntax error (missing operator) in query expression '[ClientID]='. "Gina Whipp" wrote: Private Sub Add_Workout_Click() On Error GoTo Err_Add_Workout_Click DoCmd.OpenForm "Workout Details", , , "[ClientID]=" & Me![NameOfYourListBox] Exit_Add_Workout_Click: Exit Sub Err_Add_Workout_Click: MsgBox Err.Description Resume Exit_Add_Workout_Click End Sub -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... Private Sub Add_Workout_Click() On Error GoTo Err_Add_Workout_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "Workout Details" DoCmd.OpenForm stDocName, , , stLinkCriteria Exit_Add_Workout_Click: Exit Sub Err_Add_Workout_Click: MsgBox Err.Description Resume Exit_Add_Workout_Click End Sub This is on my weightlifting form...the button is Add Workout. This opens the Workout details screen. this is where i could type the workout date. then there is a command button named add exercise. here is the code for this button. Private Sub Add_Exercise_Click() On Error GoTo Err_Add_Exercise_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "Add Exercise" DoCmd.OpenForm stDocName, , , stLinkCriteria Exit_Add_Exercise_Click: Exit Sub Err_Add_Exercise_Click: MsgBox Err.Description Resume Exit_Add_Exercise_Click End Sub This opens a form to add the exercise that is a combo box so i can pick the exercise i want to add, then fill in sets, reps weight. i am able to do all this but it is not client specific. maybe i'm making this harder than it has to be? "Gina Whipp" wrote: You have a button that is opening the form but not with the correct information, so... Go to deisgn mode of the form that has the button... Click on the button and bring up properties and then go do to the On-Click event procedure and click the button with the dots on it... Then copy everything between Private Sub and End Sub -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... ClientID is my PK and is autonumber. copy/paste what code?? where do i get the code you are asking for? "Gina Whipp" wrote: LTOSH, Please copy/paste the code you are using and is ClientID text or numeric? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... my forms are opening fine. it's the information that is not associating with the specific client. eventhough i click one specific client and go into the weightlifting page and adding information it is not associated with that one specific client. does that make sense? "Gina Whipp" wrote: LTOSH, "...I'm a 'her' hehehe..." Oops, my mistake... Sorry about that! Did you try to use the command button wizard? If the wizard failed then tell me the exact name of the form(s) you are strying to open. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... Hi Gina...thanks for support here! By the way...I'm a 'her' hehehe. ok...here is where i am and need help i think with relationships. As i stated in first email i want to click a client name then add information specific only to that client. Here is what i have going on. Main Switchboard I have a list box with client name. Then I have command buttons to take me to other specific switchboards (ex. Weightlifting, Cardio). I want to click the client name then click the command button "WEIGHTLIFTING" to take me to this switchboard. Once on the "WEIGHTLIFTING" screen i have a list box "workout date" and a listbox "Workout". Here is where i want the relationship of "workout date' and "client" to be associated, to be specific to this client. I also want "workout date" to be specific to specific dates. Example. for 02/07/09 i have chosen specific exercises. for 02/08/09 i want specific exercises. How do i make these associations or relationships? i hope i make sense. Just for clarity...i have 3 tables..."CLIENT" "EXERCISES" "WORKOUT" "WORKOUT" table is where the new created workouts would be stored. Thanks so much for help! This is so exciting this coming together. "Gina Whipp" wrote: Keith, In his first eMail he asked about his table set-up and he now has a Client table, Exercise table and a Workout table pulling those the first |
#26
|
|||
|
|||
creating new database
ok i made that change to the query and to the list box.
"Gina Whipp" wrote: You need two columns, so I need you to add ClientID before Client Name in our query. Then for your list box, in design mode, Column Count = 2, Column Widths = 0";1.5", Bound Coulmn = 1 -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... thanks for understanding! ok the first form... the list box "client list"...is from a Client Name Query i created so i could combine the first and last name together. the only column that is in that query that is shown is Client Name. "Gina Whipp" wrote: LTOSH, You're not struggling... you're learning! Let's start at the first form... You open that up and there is a list box containing all the Clients. What are the columns in the list box? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... In my client table...ClientID is the PK In my Workout table...WorkoutID is the PK, then ClientID is next data type is number, then ExerciseID is next data type is number. in my form "Weightlifting" there is a listbox "Workout Date" (appears to be unbound, that is what it says in box in design form). the Command Button on that form that you gave me the code for is called "add workout" this is to open my "add exercise" form. i'm sorry i'm just struggling with this. thanks for your patience! "Gina Whipp" wrote: LTOSH, Is not the bound field for your list box ClientID? If it is not thatis the syntax error. To find out which field is the bound field...tell me what columns you have in your list box and which one is first, second... In the NameOfYourListBox goes the name of the list box from the form that has the button on it. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... yes Deeeeeeep breath...sorry get OCD when it comes to this hahaha. ok, in your code below. Do i put in the [nameofyourlistbox] the "workout date" for that list box? is that right or which listbox? when i put it in my code...the is the error i get...Syntax error (missing operator) in query expression '[ClientID]='. "Gina Whipp" wrote: Private Sub Add_Workout_Click() On Error GoTo Err_Add_Workout_Click DoCmd.OpenForm "Workout Details", , , "[ClientID]=" & Me![NameOfYourListBox] Exit_Add_Workout_Click: Exit Sub Err_Add_Workout_Click: MsgBox Err.Description Resume Exit_Add_Workout_Click End Sub -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... Private Sub Add_Workout_Click() On Error GoTo Err_Add_Workout_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "Workout Details" DoCmd.OpenForm stDocName, , , stLinkCriteria Exit_Add_Workout_Click: Exit Sub Err_Add_Workout_Click: MsgBox Err.Description Resume Exit_Add_Workout_Click End Sub This is on my weightlifting form...the button is Add Workout. This opens the Workout details screen. this is where i could type the workout date. then there is a command button named add exercise. here is the code for this button. Private Sub Add_Exercise_Click() On Error GoTo Err_Add_Exercise_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "Add Exercise" DoCmd.OpenForm stDocName, , , stLinkCriteria Exit_Add_Exercise_Click: Exit Sub Err_Add_Exercise_Click: MsgBox Err.Description Resume Exit_Add_Exercise_Click End Sub This opens a form to add the exercise that is a combo box so i can pick the exercise i want to add, then fill in sets, reps weight. i am able to do all this but it is not client specific. maybe i'm making this harder than it has to be? "Gina Whipp" wrote: You have a button that is opening the form but not with the correct information, so... Go to deisgn mode of the form that has the button... Click on the button and bring up properties and then go do to the On-Click event procedure and click the button with the dots on it... Then copy everything between Private Sub and End Sub -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... ClientID is my PK and is autonumber. copy/paste what code?? where do i get the code you are asking for? "Gina Whipp" wrote: LTOSH, Please copy/paste the code you are using and is ClientID text or numeric? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... my forms are opening fine. it's the information that is not associating with the specific client. eventhough i click one specific client and go into the weightlifting page and adding information it is not associated with that one specific client. does that make sense? "Gina Whipp" wrote: LTOSH, "...I'm a 'her' hehehe..." Oops, my mistake... Sorry about that! Did you try to use the command button wizard? If the wizard failed then tell me the exact name of the form(s) you are strying to open. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... Hi Gina...thanks for support here! By the way...I'm a 'her' hehehe. ok...here is where i am and need help i think with relationships. As i stated in first email i want to click a client name then add information specific only to that client. Here is what i have going on. Main Switchboard I have a list box with client name. Then I have command buttons to take me to other specific switchboards (ex. Weightlifting, |
#27
|
|||
|
|||
creating new database
Pardon delay... but I'm back now.
Now on the form Add WOrkout make ClientID is part of that query or table attached to that form. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... ok i made that change to the query and to the list box. "Gina Whipp" wrote: You need two columns, so I need you to add ClientID before Client Name in our query. Then for your list box, in design mode, Column Count = 2, Column Widths = 0";1.5", Bound Coulmn = 1 -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... thanks for understanding! ok the first form... the list box "client list"...is from a Client Name Query i created so i could combine the first and last name together. the only column that is in that query that is shown is Client Name. "Gina Whipp" wrote: LTOSH, You're not struggling... you're learning! Let's start at the first form... You open that up and there is a list box containing all the Clients. What are the columns in the list box? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... In my client table...ClientID is the PK In my Workout table...WorkoutID is the PK, then ClientID is next data type is number, then ExerciseID is next data type is number. in my form "Weightlifting" there is a listbox "Workout Date" (appears to be unbound, that is what it says in box in design form). the Command Button on that form that you gave me the code for is called "add workout" this is to open my "add exercise" form. i'm sorry i'm just struggling with this. thanks for your patience! "Gina Whipp" wrote: LTOSH, Is not the bound field for your list box ClientID? If it is not thatis the syntax error. To find out which field is the bound field...tell me what columns you have in your list box and which one is first, second... In the NameOfYourListBox goes the name of the list box from the form that has the button on it. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... yes Deeeeeeep breath...sorry get OCD when it comes to this hahaha. ok, in your code below. Do i put in the [nameofyourlistbox] the "workout date" for that list box? is that right or which listbox? when i put it in my code...the is the error i get...Syntax error (missing operator) in query expression '[ClientID]='. "Gina Whipp" wrote: Private Sub Add_Workout_Click() On Error GoTo Err_Add_Workout_Click DoCmd.OpenForm "Workout Details", , , "[ClientID]=" & Me![NameOfYourListBox] Exit_Add_Workout_Click: Exit Sub Err_Add_Workout_Click: MsgBox Err.Description Resume Exit_Add_Workout_Click End Sub -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... Private Sub Add_Workout_Click() On Error GoTo Err_Add_Workout_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "Workout Details" DoCmd.OpenForm stDocName, , , stLinkCriteria Exit_Add_Workout_Click: Exit Sub Err_Add_Workout_Click: MsgBox Err.Description Resume Exit_Add_Workout_Click End Sub This is on my weightlifting form...the button is Add Workout. This opens the Workout details screen. this is where i could type the workout date. then there is a command button named add exercise. here is the code for this button. Private Sub Add_Exercise_Click() On Error GoTo Err_Add_Exercise_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "Add Exercise" DoCmd.OpenForm stDocName, , , stLinkCriteria Exit_Add_Exercise_Click: Exit Sub Err_Add_Exercise_Click: MsgBox Err.Description Resume Exit_Add_Exercise_Click End Sub This opens a form to add the exercise that is a combo box so i can pick the exercise i want to add, then fill in sets, reps weight. i am able to do all this but it is not client specific. maybe i'm making this harder than it has to be? "Gina Whipp" wrote: You have a button that is opening the form but not with the correct information, so... Go to deisgn mode of the form that has the button... Click on the button and bring up properties and then go do to the On-Click event procedure and click the button with the dots on it... Then copy everything between Private Sub and End Sub -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... ClientID is my PK and is autonumber. copy/paste what code?? where do i get the code you are asking for? "Gina Whipp" wrote: LTOSH, Please copy/paste the code you are using and is ClientID text or numeric? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... my forms are opening fine. it's the information that is not associating with the specific client. eventhough i click one specific client and go into the weightlifting page and adding information it is not associated with that one specific client. does that make sense? "Gina Whipp" wrote: LTOSH, "...I'm a 'her' hehehe..." Oops, my mistake... Sorry about that! Did you try to use the command button wizard? If the wizard failed then tell me the exact name of the form(s) you are strying to open. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... Hi Gina...thanks for support here! By the way...I'm a 'her' hehehe. ok...here is where i am and need help i think with relationships. As i stated in first email i want to click a client name then add information specific only to that client. Here is what i have going on. Main Switchboard I have a list box with client name. Then I have command buttons to take me to other specific switchboards (ex. Weightlifting, |
#28
|
|||
|
|||
creating new database
Ok if i am following you right...We are now on the "weightlifting" form.
This is the location of the CMD Button "Add Workout". Once this button is clicked it is to take me to the form labeled "workout details". on this form the "workout date" box is located that I want to type the date of the workout. this all is based on the table "Workout" and in that table, ClientID is listed. WorkoutID is PK. CLientID is the second listed. Do i need to put "ClientID" on the form itself?? "Gina Whipp" wrote: Pardon delay... but I'm back now. Now on the form Add WOrkout make ClientID is part of that query or table attached to that form. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... ok i made that change to the query and to the list box. "Gina Whipp" wrote: You need two columns, so I need you to add ClientID before Client Name in our query. Then for your list box, in design mode, Column Count = 2, Column Widths = 0";1.5", Bound Coulmn = 1 -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... thanks for understanding! ok the first form... the list box "client list"...is from a Client Name Query i created so i could combine the first and last name together. the only column that is in that query that is shown is Client Name. "Gina Whipp" wrote: LTOSH, You're not struggling... you're learning! Let's start at the first form... You open that up and there is a list box containing all the Clients. What are the columns in the list box? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... In my client table...ClientID is the PK In my Workout table...WorkoutID is the PK, then ClientID is next data type is number, then ExerciseID is next data type is number. in my form "Weightlifting" there is a listbox "Workout Date" (appears to be unbound, that is what it says in box in design form). the Command Button on that form that you gave me the code for is called "add workout" this is to open my "add exercise" form. i'm sorry i'm just struggling with this. thanks for your patience! "Gina Whipp" wrote: LTOSH, Is not the bound field for your list box ClientID? If it is not thatis the syntax error. To find out which field is the bound field...tell me what columns you have in your list box and which one is first, second... In the NameOfYourListBox goes the name of the list box from the form that has the button on it. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... yes Deeeeeeep breath...sorry get OCD when it comes to this hahaha. ok, in your code below. Do i put in the [nameofyourlistbox] the "workout date" for that list box? is that right or which listbox? when i put it in my code...the is the error i get...Syntax error (missing operator) in query expression '[ClientID]='. "Gina Whipp" wrote: Private Sub Add_Workout_Click() On Error GoTo Err_Add_Workout_Click DoCmd.OpenForm "Workout Details", , , "[ClientID]=" & Me![NameOfYourListBox] Exit_Add_Workout_Click: Exit Sub Err_Add_Workout_Click: MsgBox Err.Description Resume Exit_Add_Workout_Click End Sub -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... Private Sub Add_Workout_Click() On Error GoTo Err_Add_Workout_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "Workout Details" DoCmd.OpenForm stDocName, , , stLinkCriteria Exit_Add_Workout_Click: Exit Sub Err_Add_Workout_Click: MsgBox Err.Description Resume Exit_Add_Workout_Click End Sub This is on my weightlifting form...the button is Add Workout. This opens the Workout details screen. this is where i could type the workout date. then there is a command button named add exercise. here is the code for this button. Private Sub Add_Exercise_Click() On Error GoTo Err_Add_Exercise_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "Add Exercise" DoCmd.OpenForm stDocName, , , stLinkCriteria Exit_Add_Exercise_Click: Exit Sub Err_Add_Exercise_Click: MsgBox Err.Description Resume Exit_Add_Exercise_Click End Sub This opens a form to add the exercise that is a combo box so i can pick the exercise i want to add, then fill in sets, reps weight. i am able to do all this but it is not client specific. maybe i'm making this harder than it has to be? "Gina Whipp" wrote: You have a button that is opening the form but not with the correct information, so... Go to deisgn mode of the form that has the button... Click on the button and bring up properties and then go do to the On-Click event procedure and click the button with the dots on it... Then copy everything between Private Sub and End Sub -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... ClientID is my PK and is autonumber. copy/paste what code?? where do i get the code you are asking for? "Gina Whipp" wrote: LTOSH, Please copy/paste the code you are using and is ClientID text or numeric? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... my forms are opening fine. it's the information that is not associating with the specific client. eventhough i click one specific client and go into the weightlifting page and adding information it is not associated with that one specific client. does that make sense? "Gina Whipp" wrote: LTOSH, "...I'm a 'her' hehehe..." Oops, my mistake... Sorry about that! Did you try to use the command button wizard? If the wizard failed then tell me the exact name of the form(s) you are strying to |
#29
|
|||
|
|||
creating new database
Yep, you are following me... No you do not need to put in on the form. Now
try the button with the code I provided and let me know what happens. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... Ok if i am following you right...We are now on the "weightlifting" form. This is the location of the CMD Button "Add Workout". Once this button is clicked it is to take me to the form labeled "workout details". on this form the "workout date" box is located that I want to type the date of the workout. this all is based on the table "Workout" and in that table, ClientID is listed. WorkoutID is PK. CLientID is the second listed. Do i need to put "ClientID" on the form itself?? "Gina Whipp" wrote: Pardon delay... but I'm back now. Now on the form Add WOrkout make ClientID is part of that query or table attached to that form. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... ok i made that change to the query and to the list box. "Gina Whipp" wrote: You need two columns, so I need you to add ClientID before Client Name in our query. Then for your list box, in design mode, Column Count = 2, Column Widths = 0";1.5", Bound Coulmn = 1 -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... thanks for understanding! ok the first form... the list box "client list"...is from a Client Name Query i created so i could combine the first and last name together. the only column that is in that query that is shown is Client Name. "Gina Whipp" wrote: LTOSH, You're not struggling... you're learning! Let's start at the first form... You open that up and there is a list box containing all the Clients. What are the columns in the list box? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... In my client table...ClientID is the PK In my Workout table...WorkoutID is the PK, then ClientID is next data type is number, then ExerciseID is next data type is number. in my form "Weightlifting" there is a listbox "Workout Date" (appears to be unbound, that is what it says in box in design form). the Command Button on that form that you gave me the code for is called "add workout" this is to open my "add exercise" form. i'm sorry i'm just struggling with this. thanks for your patience! "Gina Whipp" wrote: LTOSH, Is not the bound field for your list box ClientID? If it is not thatis the syntax error. To find out which field is the bound field...tell me what columns you have in your list box and which one is first, second... In the NameOfYourListBox goes the name of the list box from the form that has the button on it. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... yes Deeeeeeep breath...sorry get OCD when it comes to this hahaha. ok, in your code below. Do i put in the [nameofyourlistbox] the "workout date" for that list box? is that right or which listbox? when i put it in my code...the is the error i get...Syntax error (missing operator) in query expression '[ClientID]='. "Gina Whipp" wrote: Private Sub Add_Workout_Click() On Error GoTo Err_Add_Workout_Click DoCmd.OpenForm "Workout Details", , , "[ClientID]=" & Me![NameOfYourListBox] Exit_Add_Workout_Click: Exit Sub Err_Add_Workout_Click: MsgBox Err.Description Resume Exit_Add_Workout_Click End Sub -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... Private Sub Add_Workout_Click() On Error GoTo Err_Add_Workout_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "Workout Details" DoCmd.OpenForm stDocName, , , stLinkCriteria Exit_Add_Workout_Click: Exit Sub Err_Add_Workout_Click: MsgBox Err.Description Resume Exit_Add_Workout_Click End Sub This is on my weightlifting form...the button is Add Workout. This opens the Workout details screen. this is where i could type the workout date. then there is a command button named add exercise. here is the code for this button. Private Sub Add_Exercise_Click() On Error GoTo Err_Add_Exercise_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "Add Exercise" DoCmd.OpenForm stDocName, , , stLinkCriteria Exit_Add_Exercise_Click: Exit Sub Err_Add_Exercise_Click: MsgBox Err.Description Resume Exit_Add_Exercise_Click End Sub This opens a form to add the exercise that is a combo box so i can pick the exercise i want to add, then fill in sets, reps weight. i am able to do all this but it is not client specific. maybe i'm making this harder than it has to be? "Gina Whipp" wrote: You have a button that is opening the form but not with the correct information, so... Go to deisgn mode of the form that has the button... Click on the button and bring up properties and then go do to the On-Click event procedure and click the button with the dots on it... Then copy everything between Private Sub and End Sub -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... ClientID is my PK and is autonumber. copy/paste what code?? where do i get the code you are asking for? "Gina Whipp" wrote: LTOSH, Please copy/paste the code you are using and is ClientID text or numeric? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... my forms are opening fine. it's the information that is not associating with the specific client. eventhough i click one specific client and go into the weightlifting page and adding information it is not associated with that one specific client. does that make sense? "Gina Whipp" wrote: LTOSH, "...I'm a 'her' hehehe..." Oops, my mistake... Sorry about that! Did you try to use the command button wizard? If the wizard failed then tell me the exact name of the form(s) you are strying to |
#30
|
|||
|
|||
creating new database
It's been 30 minutes so I figure you're either happily coding or asleep at
the keyboard g! I am falling asleep at the keyboard... will check back tomorrow AM. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Gina Whipp" wrote in message ... Yep, you are following me... No you do not need to put in on the form. Now try the button with the code I provided and let me know what happens. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... Ok if i am following you right...We are now on the "weightlifting" form. This is the location of the CMD Button "Add Workout". Once this button is clicked it is to take me to the form labeled "workout details". on this form the "workout date" box is located that I want to type the date of the workout. this all is based on the table "Workout" and in that table, ClientID is listed. WorkoutID is PK. CLientID is the second listed. Do i need to put "ClientID" on the form itself?? "Gina Whipp" wrote: Pardon delay... but I'm back now. Now on the form Add WOrkout make ClientID is part of that query or table attached to that form. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... ok i made that change to the query and to the list box. "Gina Whipp" wrote: You need two columns, so I need you to add ClientID before Client Name in our query. Then for your list box, in design mode, Column Count = 2, Column Widths = 0";1.5", Bound Coulmn = 1 -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... thanks for understanding! ok the first form... the list box "client list"...is from a Client Name Query i created so i could combine the first and last name together. the only column that is in that query that is shown is Client Name. "Gina Whipp" wrote: LTOSH, You're not struggling... you're learning! Let's start at the first form... You open that up and there is a list box containing all the Clients. What are the columns in the list box? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... In my client table...ClientID is the PK In my Workout table...WorkoutID is the PK, then ClientID is next data type is number, then ExerciseID is next data type is number. in my form "Weightlifting" there is a listbox "Workout Date" (appears to be unbound, that is what it says in box in design form). the Command Button on that form that you gave me the code for is called "add workout" this is to open my "add exercise" form. i'm sorry i'm just struggling with this. thanks for your patience! "Gina Whipp" wrote: LTOSH, Is not the bound field for your list box ClientID? If it is not thatis the syntax error. To find out which field is the bound field...tell me what columns you have in your list box and which one is first, second... In the NameOfYourListBox goes the name of the list box from the form that has the button on it. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... yes Deeeeeeep breath...sorry get OCD when it comes to this hahaha. ok, in your code below. Do i put in the [nameofyourlistbox] the "workout date" for that list box? is that right or which listbox? when i put it in my code...the is the error i get...Syntax error (missing operator) in query expression '[ClientID]='. "Gina Whipp" wrote: Private Sub Add_Workout_Click() On Error GoTo Err_Add_Workout_Click DoCmd.OpenForm "Workout Details", , , "[ClientID]=" & Me![NameOfYourListBox] Exit_Add_Workout_Click: Exit Sub Err_Add_Workout_Click: MsgBox Err.Description Resume Exit_Add_Workout_Click End Sub -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... Private Sub Add_Workout_Click() On Error GoTo Err_Add_Workout_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "Workout Details" DoCmd.OpenForm stDocName, , , stLinkCriteria Exit_Add_Workout_Click: Exit Sub Err_Add_Workout_Click: MsgBox Err.Description Resume Exit_Add_Workout_Click End Sub This is on my weightlifting form...the button is Add Workout. This opens the Workout details screen. this is where i could type the workout date. then there is a command button named add exercise. here is the code for this button. Private Sub Add_Exercise_Click() On Error GoTo Err_Add_Exercise_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "Add Exercise" DoCmd.OpenForm stDocName, , , stLinkCriteria Exit_Add_Exercise_Click: Exit Sub Err_Add_Exercise_Click: MsgBox Err.Description Resume Exit_Add_Exercise_Click End Sub This opens a form to add the exercise that is a combo box so i can pick the exercise i want to add, then fill in sets, reps weight. i am able to do all this but it is not client specific. maybe i'm making this harder than it has to be? "Gina Whipp" wrote: You have a button that is opening the form but not with the correct information, so... Go to deisgn mode of the form that has the button... Click on the button and bring up properties and then go do to the On-Click event procedure and click the button with the dots on it... Then copy everything between Private Sub and End Sub -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... ClientID is my PK and is autonumber. copy/paste what code?? where do i get the code you are asking for? "Gina Whipp" wrote: LTOSH, Please copy/paste the code you are using and is ClientID text or numeric? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "LTOSH" wrote in message ... my forms are opening fine. it's the information that is not associating with the specific client. eventhough i click one specific client and go into the weightlifting page and adding information it is not associated with that one specific client. does that make sense? "Gina Whipp" wrote: LTOSH, "...I'm a 'her' hehehe..." Oops, my mistake... Sorry about that! Did you try to use the command button wizard? If the wizard failed then tell me the exact name of the form(s) you are strying to |
Thread Tools | |
Display Modes | |
|
|