My check boxes wont work

[Guest]

I have two table level feilds that are used to track whether or not staff
have been informed of a booking they have recieved, as well as wheter or not
they have confirmed their knowledge of that booking...

InstructorInformed & InstructorConfirmed

both are set to the Yes/No feild property.

I have 3 different uses for these feilds

1) I have a form that uses 1 of these feilds...

2) I have a query that searches for data stored in these feilds.

3) I have a form that runs off of the previously mentioned query.

My problem is that my check boxes work in the initial form, but for some
reason they do not respond at all in the query or in the second form which is
based on that query.

Is this normal?? I have never had a problem here before.

Any help would be appreciated.

Thanks

 

[Lynn Trapp]

Is your query and updatable query?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Guest]

UPDATE...

It seems as though I cannot make ANY changes at the query or query based
form level......

Im stumped.......

help?

 

[Guest]

Hi Lynn

apparently it isnt... haha...

I have designed it just like any other query I have... however this one
seems to be preventing me from updating.

 

[Dirk Goldgar]

UPDATE...

It seems as though I cannot make ANY changes at the query or query
based form level......

Im stumped.......

help?

Check out the help topic, "When can I update data from a query?", or its
equivalent in the help file of whichever version of Access you have.
There are a number of conditions that can render a query nonupdatable.
The help topic discusses them and gives workarounds, where possible.

If you post the SQL of the query here also, someone may be able to make
a suggestion.

 

[Lynn Trapp]

Check out Dirk's message below for information on how to know if a query is
updatable. While you designed it "like any other query," there is obviously
something different.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Guest]

This is the SQL view of my query... I think I would describe myself as
someone with an intermediate level of access knowledge.
From what I can tell... I have 2 tables being used by the query... those
two tables are linked via 1 common feild.

The feilds that I am concerned about not being able to update are unique to
ONE TABLE only... and have no other links to other tables or queries...

see the SQL below... thanks


SELECT LessonBooker.Date, LessonBooker.Time, LessonBooker.[First Name],
LessonBooker.Phone, LessonBooker.Type, LessonBooker.[SKI / BOARD],
LessonBooker.Duration, LessonBooker.Request, LessonBooker.[Informed
Instructor], LessonBooker.[Instructor Confirmed], LessonBooker.[# of People],
LessonBooker.Ability, LessonBooker.[Client Notes], [Staff Log].[First Inst],
[Staff Log].[Last Inst], [Staff Log].Phone, [Staff Log].Email, [Staff
Log].[Will Attend on Request], [Staff Log].[Special Notes]
FROM [Staff Log] INNER JOIN LessonBooker ON [Staff Log].[First Inst] =
LessonBooker.Request
WHERE (((LessonBooker.Date)>Date()));

 

[Dirk Goldgar]

This is the SQL view of my query... I think I would describe myself
as someone with an intermediate level of access knowledge.
From what I can tell... I have 2 tables being used by the query...
those two tables are linked via 1 common feild.

The feilds that I am concerned about not being able to update are
unique to ONE TABLE only... and have no other links to other tables
or queries...

see the SQL below... thanks


SELECT LessonBooker.Date, LessonBooker.Time, LessonBooker.[First
Name], LessonBooker.Phone, LessonBooker.Type, LessonBooker.[SKI /
BOARD], LessonBooker.Duration, LessonBooker.Request,
LessonBooker.[Informed Instructor], LessonBooker.[Instructor
Confirmed], LessonBooker.[# of People], LessonBooker.Ability,
LessonBooker.[Client Notes], [Staff Log].[First Inst], [Staff
Log].[Last Inst], [Staff Log].Phone, [Staff Log].Email, [Staff
Log].[Will Attend on Request], [Staff Log].[Special Notes]
FROM [Staff Log] INNER JOIN LessonBooker ON [Staff Log].[First Inst] =
LessonBooker.Request
WHERE (((LessonBooker.Date)>Date()));

What are the primary key fields of the two tables? If they aren't
already included in the list of selected fields, try adding the primary
key field from each table to the list.

 

[Guest]

AH HA... no success yet... but maybe a step closer

I realized that I had not set a primary key on one of the tables... for some
unknown reason... I have set a feild to auto # now to make up for that.

I have included the key's from both tables in the query... but still no luck
with the "updateability"

ready to give my computer a swift kick in the d: drive here.....

appreciating the help!!!

This is the SQL view of my query... I think I would describe myself
as someone with an intermediate level of access knowledge.
From what I can tell... I have 2 tables being used by the query...
those two tables are linked via 1 common feild.

The feilds that I am concerned about not being able to update are
unique to ONE TABLE only... and have no other links to other tables
or queries...

see the SQL below... thanks


SELECT LessonBooker.Date, LessonBooker.Time, LessonBooker.[First
Name], LessonBooker.Phone, LessonBooker.Type, LessonBooker.[SKI /
BOARD], LessonBooker.Duration, LessonBooker.Request,
LessonBooker.[Informed Instructor], LessonBooker.[Instructor
Confirmed], LessonBooker.[# of People], LessonBooker.Ability,
LessonBooker.[Client Notes], [Staff Log].[First Inst], [Staff
Log].[Last Inst], [Staff Log].Phone, [Staff Log].Email, [Staff
Log].[Will Attend on Request], [Staff Log].[Special Notes]
FROM [Staff Log] INNER JOIN LessonBooker ON [Staff Log].[First Inst] =
LessonBooker.Request
WHERE (((LessonBooker.Date)>Date()));

What are the primary key fields of the two tables? If they aren't
already included in the list of selected fields, try adding the primary
key field from each table to the list.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

 

[Dirk Goldgar]

AH HA... no success yet... but maybe a step closer

I realized that I had not set a primary key on one of the tables...
for some unknown reason... I have set a feild to auto # now to make
up for that.

I have included the key's from both tables in the query... but still
no luck with the "updateability"

ready to give my computer a swift kick in the d: drive here.....

Are the join fields indexed? If not, try that next, and then if that
doesn't work, post the SQL as it stands.

 

[Guest]

Heres the SQL


SELECT LessonBooker.Date, LessonBooker.Time, LessonBooker.[First Name],
LessonBooker.Phone, LessonBooker.Type, LessonBooker.[SKI / BOARD],
LessonBooker.Duration, LessonBooker.Request, LessonBooker.[Informed
Instructor], LessonBooker.[Instructor Confirmed], LessonBooker.[# of People],
LessonBooker.Ability, LessonBooker.[Client Notes], [Staff Log].[First Inst],
[Staff Log].[Last Inst], [Staff Log].Phone, [Staff Log].Email, [Staff
Log].[Will Attend on Request], [Staff Log].[Special Notes]
FROM [Staff Log] INNER JOIN LessonBooker ON [Staff Log].[First Inst] =
LessonBooker.Request
WHERE (((LessonBooker.Date)>Date()));

 

[Dirk Goldgar]

Heres the SQL


SELECT LessonBooker.Date, LessonBooker.Time, LessonBooker.[First
Name], LessonBooker.Phone, LessonBooker.Type, LessonBooker.[SKI /
BOARD], LessonBooker.Duration, LessonBooker.Request,
LessonBooker.[Informed Instructor], LessonBooker.[Instructor
Confirmed], LessonBooker.[# of People], LessonBooker.Ability,
LessonBooker.[Client Notes], [Staff Log].[First Inst], [Staff
Log].[Last Inst], [Staff Log].Phone, [Staff Log].Email, [Staff
Log].[Will Attend on Request], [Staff Log].[Special Notes]
FROM [Staff Log] INNER JOIN LessonBooker ON [Staff Log].[First Inst] =
LessonBooker.Request
WHERE (((LessonBooker.Date)>Date()));

So what are the primary key fields of tables LessonBooker and [Staff
Log]?

 

[Guest]

Both primary keys are Auto#'s
one is "Staff#" the other "lesson#"

im lost on this one.........

Thanks

Heres the SQL


SELECT LessonBooker.Date, LessonBooker.Time, LessonBooker.[First
Name], LessonBooker.Phone, LessonBooker.Type, LessonBooker.[SKI /
BOARD], LessonBooker.Duration, LessonBooker.Request,
LessonBooker.[Informed Instructor], LessonBooker.[Instructor
Confirmed], LessonBooker.[# of People], LessonBooker.Ability,
LessonBooker.[Client Notes], [Staff Log].[First Inst], [Staff
Log].[Last Inst], [Staff Log].Phone, [Staff Log].Email, [Staff
Log].[Will Attend on Request], [Staff Log].[Special Notes]
FROM [Staff Log] INNER JOIN LessonBooker ON [Staff Log].[First Inst] =
LessonBooker.Request
WHERE (((LessonBooker.Date)>Date()));

So what are the primary key fields of tables LessonBooker and [Staff
Log]?

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

 

[Dirk Goldgar]

Both primary keys are Auto#'s
one is "Staff#" the other "lesson#"

im lost on this one.........

Thanks

Heres the SQL


SELECT LessonBooker.Date, LessonBooker.Time, LessonBooker.[First
Name], LessonBooker.Phone, LessonBooker.Type, LessonBooker.[SKI /
BOARD], LessonBooker.Duration, LessonBooker.Request,
LessonBooker.[Informed Instructor], LessonBooker.[Instructor
Confirmed], LessonBooker.[# of People], LessonBooker.Ability,
LessonBooker.[Client Notes], [Staff Log].[First Inst], [Staff
Log].[Last Inst], [Staff Log].Phone, [Staff Log].Email, [Staff
Log].[Will Attend on Request], [Staff Log].[Special Notes]
FROM [Staff Log] INNER JOIN LessonBooker ON [Staff Log].[First
Inst] = LessonBooker.Request
WHERE (((LessonBooker.Date)>Date()));

So what are the primary key fields of tables LessonBooker and [Staff
Log]?

You said you had included the keys from both tables in the query, but I
see neither [Staff#] not [lesson#] in the list of selected fields in the
SQL statement above.