creating new database

G

Gina Whipp

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 said:
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 said:
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 said:
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?

:

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

ClientID is my PK and is autonumber.

copy/paste what code?? where do i get the code you are asking for?


:

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

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?

:

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

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.

:

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


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
 
L

LTOSH

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 said:
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 said:
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 said:
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

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?

:

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

ClientID is my PK and is autonumber.

copy/paste what code?? where do i get the code you are asking for?


:

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

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?

:

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

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.

:

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


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 :)
 
G

Gina Whipp

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 said:
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 said:
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 said:
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]='.

:

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

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?

:

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

ClientID is my PK and is autonumber.

copy/paste what code?? where do i get the code you are asking
for?


:

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

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?

:

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

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.

:

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

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 :)
 
L

LTOSH

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 said:
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 said:
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 said:
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

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]='.

:

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

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?

:

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

ClientID is my PK and is autonumber.

copy/paste what code?? where do i get the code you are asking
for?


:

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

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?

:

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

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.

:

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
 
G

Gina Whipp

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 said:
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 said:
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 said:
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!

:

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

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]='.

:

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

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?

:

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

ClientID is my PK and is autonumber.

copy/paste what code?? where do i get the code you are asking
for?


:

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

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?

:

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

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.

:

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
 
L

LTOSH

ok i made that change to the query and to the list box.

Gina Whipp said:
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 said:
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 said:
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

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!

:

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

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]='.

:

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

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?

:

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

ClientID is my PK and is autonumber.

copy/paste what code?? where do i get the code you are asking
for?


:

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

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?

:

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

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,
 
G

Gina Whipp

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 said:
ok i made that change to the query and to the list box.

Gina Whipp said:
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 said:
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.

:

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

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!

:

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

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]='.

:

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

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?

:

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

ClientID is my PK and is autonumber.

copy/paste what code?? where do i get the code you are
asking
for?


:

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

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?

:

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

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,
 
L

LTOSH

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 said:
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 said:
ok i made that change to the query and to the list box.

Gina Whipp said:
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

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.

:

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

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!

:

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

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]='.

:

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

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?

:

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

ClientID is my PK and is autonumber.

copy/paste what code?? where do i get the code you are
asking
for?


:

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

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?

:

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
 
G

Gina Whipp

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 said:
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 said:
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 said:
ok i made that change to the query and to the list box.

:

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

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.

:

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

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!

:

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

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]='.

:

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

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?

:

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

ClientID is my PK and is autonumber.

copy/paste what code?? where do i get the code you are
asking
for?


:

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

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?

:

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
 
G

Gina Whipp

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 said:
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 said:
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 said:
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

ok i made that change to the query and to the list box.

:

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

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.

:

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

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!

:

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

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]='.

:

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

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?

:

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

message
ClientID is my PK and is autonumber.

copy/paste what code?? where do i get the code you are
asking
for?


:

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

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?

:

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top