ref John vinson post 8/27/07(remove from dropdown when selected)

[babs]

Posted yesterday - and a while back - haven't heard back- any ideas???

I have a LIst of employess - in a query it is really One query Jeff employee
Info that the combo box for a form is based on - not sure how to set up the
select statement below - the subfomr the dropdown is on it Named cbomanname
on the subform JeffSchedLookAheadGenerate I created additional queries with
employee list [Jeff Employee Combo Box Time Card-Deleting for Dropdown] - not
really any different from Jeff employee info.

syntax I have - getting error -not what I am doing
I basically want to get rid of the name from the combo box when an employee
I scheduled for a given day has been sched.- at the end of that schedule day
I would like to refresh the list for the next day sched put them back - as
sched. each OnE want them gone from the dropdown for that day. I also added
a field to the subform - available(y/n)

not clear how to go about this

MY code
SELECT [Jeff Employee Info].[man name] FROM [Jeff Employee Info] WHERE [man
name] NOT IN (SELECT [man name] FROM [Jeff Employee Combo Box Time
Card-Deleting for Dropdown] WHERE [Jeff Employee Combo Box Time Card-Deleting
for Dropdown].[man name] = Forms! JeffSchedLookAheadGenerate!cbomanname);


post by John Vinson on 8/27/07
remove from dropdown when selected in
seems to be along same lines think my IssueDescID is Man name

SELECT t013IssueDesc.IssueDescID, t013IssueDesc.IssueDesc FROM t013IssueDesc
WHERE IssueDeskID NOT IN
(SELECT IssueDescID FROM tIssue WHERE tIssue.RiskID = Forms!fRisk!RiskID);

and I KNOW Man Name is a horrible ID but the company doesn't have that many
employees and WILL NOT DUPLICATE MAN NAME
- its been here an don't want to change PK

any ideas on how I can do this?? get rid of man name from combobox when
selected??

thanks soo much
Barb

 

[John W. Vinson]

Posted yesterday - and a while back - haven't heard back- any ideas???

sorry... I've been busy...

I have a LIst of employess - in a query it is really One query Jeff employee
Info that the combo box for a form is based on - not sure how to set up the
select statement below - the subfomr the dropdown is on it Named cbomanname
on the subform JeffSchedLookAheadGenerate I created additional queries with
employee list [Jeff Employee Combo Box Time Card-Deleting for Dropdown] - not
really any different from Jeff employee info.

syntax I have - getting error -not what I am doing
I basically want to get rid of the name from the combo box when an employee
I scheduled for a given day has been sched.- at the end of that schedule day
I would like to refresh the list for the next day sched put them back - as
sched. each OnE want them gone from the dropdown for that day. I also added
a field to the subform - available(y/n)

You'll need to use an "unmatched query" to join the Employee Info table to
whatever table you're basing this form on.

not clear how to go about this

MY code
SELECT [Jeff Employee Info].[man name] FROM [Jeff Employee Info] WHERE [man
name] NOT IN (SELECT [man name] FROM [Jeff Employee Combo Box Time
Card-Deleting for Dropdown] WHERE [Jeff Employee Combo Box Time Card-Deleting
for Dropdown].[man name] = Forms! JeffSchedLookAheadGenerate!cbomanname);

SOMETHING LIKE this should be adaptable:

SELECT [Jeff Employee Info].[man name] FROM [Jeff Employee Info]
LEFT JOIN [Jeff Employee Combo Box Time Card-Deleting for Dropdown]
ON [Jeff Employee Combo Box Time Card-Deleting
for Dropdown].[man name] = [Jeff Employee Info].[man name]
WHERE [Jeff Employee Combo Box Time Card-Deleting
for Dropdown].[man name] IS NULL;

assuming that [Jeff Employee Combo Box Time Card-Deleting
for Dropdown] is a query listing the Man Names that you don't want to include.

I'm not clear on your table structure so I'm not sure!!!

 

[babs]

assuming that [Jeff Employee Combo Box Time Card-Deleting
for Dropdown] is a query listing the Man Names that you don't want to include.

your post above
basically I have a dropdown based on Jeff employee Info query - and want to
eliminate that employee from the drop down if they have been sched. for That
day. - I guess that query [Jeff Employee Combo Box Time Card-Deleting for
Dropdown] should include a yes/no field that is yes sched. and it would show
all employess sched.(which would be people don't want in the dropdown since
already sched.) not sure best way to handle the given day - and reinclude All
in drop down at end of the each day-many times sched. days ahead on today.

thanks soooo much for helping,
Barb

Posted yesterday - and a while back - haven't heard back- any ideas???

sorry... I've been busy...

I have a LIst of employess - in a query it is really One query Jeff employee
Info that the combo box for a form is based on - not sure how to set up the
select statement below - the subfomr the dropdown is on it Named cbomanname
on the subform JeffSchedLookAheadGenerate I created additional queries with
employee list [Jeff Employee Combo Box Time Card-Deleting for Dropdown] - not
really any different from Jeff employee info.

syntax I have - getting error -not what I am doing
I basically want to get rid of the name from the combo box when an employee
I scheduled for a given day has been sched.- at the end of that schedule day
I would like to refresh the list for the next day sched put them back - as
sched. each OnE want them gone from the dropdown for that day. I also added
a field to the subform - available(y/n)

You'll need to use an "unmatched query" to join the Employee Info table to
whatever table you're basing this form on.

not clear how to go about this

MY code
SELECT [Jeff Employee Info].[man name] FROM [Jeff Employee Info] WHERE [man
name] NOT IN (SELECT [man name] FROM [Jeff Employee Combo Box Time
Card-Deleting for Dropdown] WHERE [Jeff Employee Combo Box Time Card-Deleting
for Dropdown].[man name] = Forms! JeffSchedLookAheadGenerate!cbomanname);

SOMETHING LIKE this should be adaptable:

SELECT [Jeff Employee Info].[man name] FROM [Jeff Employee Info]
LEFT JOIN [Jeff Employee Combo Box Time Card-Deleting for Dropdown]
ON [Jeff Employee Combo Box Time Card-Deleting
for Dropdown].[man name] = [Jeff Employee Info].[man name]
WHERE [Jeff Employee Combo Box Time Card-Deleting
for Dropdown].[man name] IS NULL;

assuming that [Jeff Employee Combo Box Time Card-Deleting
for Dropdown] is a query listing the Man Names that you don't want to include.

I'm not clear on your table structure so I'm not sure!!!

 

[John W. Vinson]

assuming that [Jeff Employee Combo Box Time Card-Deleting
for Dropdown] is a query listing the Man Names that you don't want to include.

your post above
basically I have a dropdown based on Jeff employee Info query - and want to
eliminate that employee from the drop down if they have been sched. for That
day. -

How in your tables can you tell which employees have been scheduled for that
day? What is the name of the table with the schedule? What is the fieldname of
the scheduled date field and of the employee ID ([Man Name] perhaps?)

I guess that query [Jeff Employee Combo Box Time Card-Deleting for
Dropdown] should include a yes/no field that is yes sched. and it would show
all employess sched.(which would be people don't want in the dropdown since
already sched.) not sure best way to handle the given day - and reinclude All
in drop down at end of the each day-many times sched. days ahead on today.

You would not need a Yes/No field - the query would be able to exclude them.

I will be glad to help but you will need to help me do so by posting the above
information.

 

[babs]

How in your tables can you tell which employees have been scheduled for that
day?What is the name of the table with the schedule?

The query that the schedule goes into is Jeff SchedNotes Qry ( based off of
the table Jeff SchedNotes, I added a field NotAvailable(yes/no)-not sure if I
need it.

What is the fieldname of
the scheduled date field
IT IS WorkDate

and of the employee ID ([Man Name] perhaps?)
Yes is [Man Name]

Thanks again soo much for helping don't know if I need the not availble field.
thanks Again sooo much,
Barb

assuming that [Jeff Employee Combo Box Time Card-Deleting
for Dropdown] is a query listing the Man Names that you don't want to include.

your post above
basically I have a dropdown based on Jeff employee Info query - and want to
eliminate that employee from the drop down if they have been sched. for That
day. -

How in your tables can you tell which employees have been scheduled for that
day? What is the name of the table with the schedule? What is the fieldname of
the scheduled date field and of the employee ID ([Man Name] perhaps?)

I guess that query [Jeff Employee Combo Box Time Card-Deleting for
Dropdown] should include a yes/no field that is yes sched. and it would show
all employess sched.(which would be people don't want in the dropdown since
already sched.) not sure best way to handle the given day - and reinclude All
in drop down at end of the each day-many times sched. days ahead on today.

You would not need a Yes/No field - the query would be able to exclude them.

I will be glad to help but you will need to help me do so by posting the above
information.

 

[John W. Vinson]

How in your tables can you tell which employees have been scheduled for that
day?What is the name of the table with the schedule?

The query that the schedule goes into is Jeff SchedNotes Qry ( based off of
the table Jeff SchedNotes, I added a field NotAvailable(yes/no)-not sure if I
need it.

What is the fieldname of
the scheduled date field
IT IS WorkDate

and of the employee ID ([Man Name] perhaps?)
Yes is [Man Name]

Thanks again soo much for helping don't know if I need the not availble field.
thanks Again sooo much,
Barb

Try adding a criterion to [Man Name] in [Jeff SchedNotes Qry] of

NOT IN(SELECT [Man Name] FROM [Jeff SchedNotes] WHERE [Jeff
SchedNotes].[WorkDate] = Date())

This will find all of the Man Name values which *ARE* scheduled for today, and
exclude them from the combo box.

You might need to requery the combo box in the AfterUpdate event of the form.

 

[babs]

This is the row source for the combo box on the subform

not clear on what qry or table should be where
should JeffSchedNotes Qry be anywhere below

SELECT DISTINCT [Jeff Employee Combo Box Time Card-Deleting for
Dropdown].[MAN NAME] FROM [Jeff Employee Combo Box Time Card-Deleting for
Dropdown] LEFT JOIN JeffSchedNotes ON [Jeff Employee Combo Box Time
Card-Deleting for Dropdown].[MAN NAME]=JeffSchedNotes.[man name];

I added the code below to the man name critera of as you suggested

Try adding a criterion to [Man Name] in [Jeff SchedNotes Qry] of

NOT IN(SELECT [Man Name] FROM [Jeff SchedNotes] WHERE [Jeff
SchedNotes].[WorkDate] = Date())

Added the refresh query to Jeffsched qry - on after update event of form but
have a feeling that that query is not feeding my combo box based on SELECT
code above

sorry - thanks again sooo much for helping - not clear onwhat should be in
the row source code for the combo box
Barb

How in your tables can you tell which employees have been scheduled for that
day?What is the name of the table with the schedule?

The query that the schedule goes into is Jeff SchedNotes Qry ( based off of
the table Jeff SchedNotes, I added a field NotAvailable(yes/no)-not sure if I
need it.

What is the fieldname of
the scheduled date field
IT IS WorkDate

and of the employee ID ([Man Name] perhaps?)
Yes is [Man Name]

Thanks again soo much for helping don't know if I need the not availble field.
thanks Again sooo much,
Barb

Try adding a criterion to [Man Name] in [Jeff SchedNotes Qry] of

NOT IN(SELECT [Man Name] FROM [Jeff SchedNotes] WHERE [Jeff
SchedNotes].[WorkDate] = Date())

This will find all of the Man Name values which *ARE* scheduled for today, and
exclude them from the combo box.

You might need to requery the combo box in the AfterUpdate event of the form.

 

[John W. Vinson]

This is the row source for the combo box on the subform

not clear on what qry or table should be where
should JeffSchedNotes Qry be anywhere below

SELECT DISTINCT [Jeff Employee Combo Box Time Card-Deleting for
Dropdown].[MAN NAME] FROM [Jeff Employee Combo Box Time Card-Deleting for
Dropdown] LEFT JOIN JeffSchedNotes ON [Jeff Employee Combo Box Time
Card-Deleting for Dropdown].[MAN NAME]=JeffSchedNotes.[man name];

Sorry... I was getting confused in all the back and forth.

This should be

SELECT DISTINCT [Jeff Employee Combo Box Time Card-Deleting for
Dropdown].[MAN NAME] FROM [Jeff Employee Combo Box Time Card-Deleting for
Dropdown] LEFT JOIN JeffSchedNotes ON [Jeff Employee Combo Box Time
Card-Deleting for Dropdown].[MAN NAME]=JeffSchedNotes.[man name]
WHERE [Jeff Employee Combo Box Time Card-Deleting for
Dropdown].[Man name] IS NULL ORDER BY [Jeff Employee Combo Box Time
Card-Deleting for
Dropdown].[MAN NAME];

If you have the left join you won't need the subquery.

Again, I'm assuming that these are table names not query names, though that
may not make much difference.

I'd REALLY suggest using shorter, simpler names without blanks or punctuation
though! Your long names might be good documentation but that can be done in
ways that won't lead to the Query Too Complex errors and other problems that
names such as [Jeff Employee Combo Box Time Card-Deleting for
Dropdown] can cause.

 

[babs]

I added the code you just suggested into the last post to the row source for
the combo box man name on the JeffSchedLookAheadGenerate Subform

I am getting a Blank Drop down

JeffSchedNotes Query is the Record Source for the Subform

Yes SchedNotes is a Table

[Jeff Employee Combo Box Time Card-Deleting for Dropdown] is a query based
on One table [Employees] - but has criteria to only include employee from
some dept. - here is the Sql for that Query
SELECT DISTINCT [Employee File].[MAN NAME], [Employee File].Rate, [Employee
File].Rate2BP, [Employee File].Position, [Employee File].[Cost ID], [Employee
File].Employee, [Employee File].Firestopper
FROM [Employee File]
WHERE ((([Employee File].[Cost ID])<=4) AND (([Employee File].Employee)=Yes)
AND (([Employee File].Firestopper)=No))
ORDER BY [Employee File].[MAN NAME];


not sure why not using info you suggest earlier about the date:
Try adding a criterion to [Man Name] in [Jeff SchedNotes Qry] of

NOT IN(SELECT [Man Name] FROM [Jeff SchedNotes] WHERE [Jeff
SchedNotes].[WorkDate] = Date())

anywhere??? in the row source? really want it to be By date -when get to new
date shows who is not sched. yet for That date.

This is the row source for the combo box on the subform

not clear on what qry or table should be where
should JeffSchedNotes Qry be anywhere below

SELECT DISTINCT [Jeff Employee Combo Box Time Card-Deleting for
Dropdown].[MAN NAME] FROM [Jeff Employee Combo Box Time Card-Deleting for
Dropdown] LEFT JOIN JeffSchedNotes ON [Jeff Employee Combo Box Time
Card-Deleting for Dropdown].[MAN NAME]=JeffSchedNotes.[man name];

Sorry... I was getting confused in all the back and forth.

This should be

SELECT DISTINCT [Jeff Employee Combo Box Time Card-Deleting for
Dropdown].[MAN NAME] FROM [Jeff Employee Combo Box Time Card-Deleting for
Dropdown] LEFT JOIN JeffSchedNotes ON [Jeff Employee Combo Box Time
Card-Deleting for Dropdown].[MAN NAME]=JeffSchedNotes.[man name]
WHERE [Jeff Employee Combo Box Time Card-Deleting for
Dropdown].[Man name] IS NULL ORDER BY [Jeff Employee Combo Box Time
Card-Deleting for
Dropdown].[MAN NAME];

If you have the left join you won't need the subquery.

Again, I'm assuming that these are table names not query names, though that
may not make much difference.

I'd REALLY suggest using shorter, simpler names without blanks or punctuation
though! Your long names might be good documentation but that can be done in
ways that won't lead to the Query Too Complex errors and other problems that
names such as [Jeff Employee Combo Box Time Card-Deleting for
Dropdown] can cause.

 

[babs]

Also wanted you to know that the query that is the record source for the
subfom is just Sorting the JeffSchedNotes Table by Workdate in Descending
order - but just based on JeffSchedNotes- no other table.
thanks!!

I added the code you just suggested into the last post to the row source for
the combo box man name on the JeffSchedLookAheadGenerate Subform

I am getting a Blank Drop down

JeffSchedNotes Query is the Record Source for the Subform

Yes SchedNotes is a Table

[Jeff Employee Combo Box Time Card-Deleting for Dropdown] is a query based
on One table [Employees] - but has criteria to only include employee from
some dept. - here is the Sql for that Query
SELECT DISTINCT [Employee File].[MAN NAME], [Employee File].Rate, [Employee
File].Rate2BP, [Employee File].Position, [Employee File].[Cost ID], [Employee
File].Employee, [Employee File].Firestopper
FROM [Employee File]
WHERE ((([Employee File].[Cost ID])<=4) AND (([Employee File].Employee)=Yes)
AND (([Employee File].Firestopper)=No))
ORDER BY [Employee File].[MAN NAME];


not sure why not using info you suggest earlier about the date:
Try adding a criterion to [Man Name] in [Jeff SchedNotes Qry] of

NOT IN(SELECT [Man Name] FROM [Jeff SchedNotes] WHERE [Jeff
SchedNotes].[WorkDate] = Date())

anywhere??? in the row source? really want it to be By date -when get to new
date shows who is not sched. yet for That date.

This is the row source for the combo box on the subform

not clear on what qry or table should be where
should JeffSchedNotes Qry be anywhere below

SELECT DISTINCT [Jeff Employee Combo Box Time Card-Deleting for
Dropdown].[MAN NAME] FROM [Jeff Employee Combo Box Time Card-Deleting for
Dropdown] LEFT JOIN JeffSchedNotes ON [Jeff Employee Combo Box Time
Card-Deleting for Dropdown].[MAN NAME]=JeffSchedNotes.[man name];

Sorry... I was getting confused in all the back and forth.

This should be

SELECT DISTINCT [Jeff Employee Combo Box Time Card-Deleting for
Dropdown].[MAN NAME] FROM [Jeff Employee Combo Box Time Card-Deleting for
Dropdown] LEFT JOIN JeffSchedNotes ON [Jeff Employee Combo Box Time
Card-Deleting for Dropdown].[MAN NAME]=JeffSchedNotes.[man name]
WHERE [Jeff Employee Combo Box Time Card-Deleting for
Dropdown].[Man name] IS NULL ORDER BY [Jeff Employee Combo Box Time
Card-Deleting for
Dropdown].[MAN NAME];

If you have the left join you won't need the subquery.

Again, I'm assuming that these are table names not query names, though that
may not make much difference.

I'd REALLY suggest using shorter, simpler names without blanks or punctuation
though! Your long names might be good documentation but that can be done in
ways that won't lead to the Query Too Complex errors and other problems that
names such as [Jeff Employee Combo Box Time Card-Deleting for
Dropdown] can cause.

 

[babs]

Jeff,

This code below - I put on the row source for the dropdown list and it gets
rid of the name if it is scheduled - but not able to Handle the date issue
with this code - anywhere to add the code to renew dropdown to show who is
still available for That given Day!


SELECT [Jeff Employee Combo Box Time Card-Deleting for Dropdown].[MAN NAME],
JeffSchedNotes.[man name], JeffSchedNotes.Workdate FROM [Jeff Employee Combo
Box Time Card-Deleting for Dropdown] LEFT JOIN JeffSchedNotes ON [Jeff
Employee Combo Box Time Card-Deleting for Dropdown].[MAN
NAME]=JeffSchedNotes.[man name] WHERE (((JeffSchedNotes.[man name]) Is Null))
ORDER BY [Jeff Employee Combo Box Time Card-Deleting for Dropdown].[MAN
NAME];

Thanks soo much for still helping - I feel like i am getting Close!
Barb

This is the row source for the combo box on the subform

not clear on what qry or table should be where
should JeffSchedNotes Qry be anywhere below

SELECT DISTINCT [Jeff Employee Combo Box Time Card-Deleting for
Dropdown].[MAN NAME] FROM [Jeff Employee Combo Box Time Card-Deleting for
Dropdown] LEFT JOIN JeffSchedNotes ON [Jeff Employee Combo Box Time
Card-Deleting for Dropdown].[MAN NAME]=JeffSchedNotes.[man name];

Sorry... I was getting confused in all the back and forth.

This should be

SELECT DISTINCT [Jeff Employee Combo Box Time Card-Deleting for
Dropdown].[MAN NAME] FROM [Jeff Employee Combo Box Time Card-Deleting for
Dropdown] LEFT JOIN JeffSchedNotes ON [Jeff Employee Combo Box Time
Card-Deleting for Dropdown].[MAN NAME]=JeffSchedNotes.[man name]
WHERE [Jeff Employee Combo Box Time Card-Deleting for
Dropdown].[Man name] IS NULL ORDER BY [Jeff Employee Combo Box Time
Card-Deleting for
Dropdown].[MAN NAME];

If you have the left join you won't need the subquery.

Again, I'm assuming that these are table names not query names, though that
may not make much difference.

I'd REALLY suggest using shorter, simpler names without blanks or punctuation
though! Your long names might be good documentation but that can be done in
ways that won't lead to the Query Too Complex errors and other problems that
names such as [Jeff Employee Combo Box Time Card-Deleting for
Dropdown] can cause.

 

[John W. Vinson]

Jeff,

This code below - I put on the row source for the dropdown list and it gets
rid of the name if it is scheduled - but not able to Handle the date issue
with this code - anywhere to add the code to renew dropdown to show who is
still available for That given Day!


SELECT [Jeff Employee Combo Box Time Card-Deleting for Dropdown].[MAN NAME],
JeffSchedNotes.[man name], JeffSchedNotes.Workdate FROM [Jeff Employee Combo
Box Time Card-Deleting for Dropdown] LEFT JOIN JeffSchedNotes ON [Jeff
Employee Combo Box Time Card-Deleting for Dropdown].[MAN
NAME]=JeffSchedNotes.[man name] WHERE (((JeffSchedNotes.[man name]) Is Null))
ORDER BY [Jeff Employee Combo Box Time Card-Deleting for Dropdown].[MAN
NAME];

"Handle the date issue"?

What would constitue handling it?

 

[babs]

I guess I really would like a check box for a field Not available to be the
default (that I already put in the JeffSched Notes Table that is tied to the
query that is the record source for the subform)- - but some people may be
able to be sched on two diff jobs in that Given Workday - 4hrs one job 4 hrs
another. Soooo if they need to be sched <1 x in a day they could Uncheck the
Not available field - - so I would like the dropdown of manname to show ALL
available(not Scheduled-All Available) FOR THAT GIVEN DAY - on a new day All
should be Available in dropdown until they are sched.ie.not available.) - not
sure of complete Code or where to Add it to handle this.

'thanks again soo much,
Barb

Jeff,

This code below - I put on the row source for the dropdown list and it gets
rid of the name if it is scheduled - but not able to Handle the date issue
with this code - anywhere to add the code to renew dropdown to show who is
still available for That given Day!


SELECT [Jeff Employee Combo Box Time Card-Deleting for Dropdown].[MAN NAME],
JeffSchedNotes.[man name], JeffSchedNotes.Workdate FROM [Jeff Employee Combo
Box Time Card-Deleting for Dropdown] LEFT JOIN JeffSchedNotes ON [Jeff
Employee Combo Box Time Card-Deleting for Dropdown].[MAN
NAME]=JeffSchedNotes.[man name] WHERE (((JeffSchedNotes.[man name]) Is Null))
ORDER BY [Jeff Employee Combo Box Time Card-Deleting for Dropdown].[MAN
NAME];

"Handle the date issue"?

What would constitue handling it?

 

[babs]

sorry - edit above to say Sched. >1X in a day
thanks,
barb

I guess I really would like a check box for a field Not available to be the
default (that I already put in the JeffSched Notes Table that is tied to the
query that is the record source for the subform)- - but some people may be
able to be sched on two diff jobs in that Given Workday - 4hrs one job 4 hrs
another. Soooo if they need to be sched <1 x in a day they could Uncheck the
Not available field - - so I would like the dropdown of manname to show ALL
available(not Scheduled-All Available) FOR THAT GIVEN DAY - on a new day All
should be Available in dropdown until they are sched.ie.not available.) - not
sure of complete Code or where to Add it to handle this.

'thanks again soo much,
Barb

Jeff,

This code below - I put on the row source for the dropdown list and it gets
rid of the name if it is scheduled - but not able to Handle the date issue
with this code - anywhere to add the code to renew dropdown to show who is
still available for That given Day!


SELECT [Jeff Employee Combo Box Time Card-Deleting for Dropdown].[MAN NAME],
JeffSchedNotes.[man name], JeffSchedNotes.Workdate FROM [Jeff Employee Combo
Box Time Card-Deleting for Dropdown] LEFT JOIN JeffSchedNotes ON [Jeff
Employee Combo Box Time Card-Deleting for Dropdown].[MAN
NAME]=JeffSchedNotes.[man name] WHERE (((JeffSchedNotes.[man name]) Is Null))
ORDER BY [Jeff Employee Combo Box Time Card-Deleting for Dropdown].[MAN
NAME];

"Handle the date issue"?

What would constitue handling it?

 

[babs]

John,
Any idea on what code to put where for to adjust dropdown for workdate - see
previous 2 posts and original post.

Thanks soo much for helping hoping to resolve soon - thanks
Barb

Jeff,

This code below - I put on the row source for the dropdown list and it gets
rid of the name if it is scheduled - but not able to Handle the date issue
with this code - anywhere to add the code to renew dropdown to show who is
still available for That given Day!


SELECT [Jeff Employee Combo Box Time Card-Deleting for Dropdown].[MAN NAME],
JeffSchedNotes.[man name], JeffSchedNotes.Workdate FROM [Jeff Employee Combo
Box Time Card-Deleting for Dropdown] LEFT JOIN JeffSchedNotes ON [Jeff
Employee Combo Box Time Card-Deleting for Dropdown].[MAN
NAME]=JeffSchedNotes.[man name] WHERE (((JeffSchedNotes.[man name]) Is Null))
ORDER BY [Jeff Employee Combo Box Time Card-Deleting for Dropdown].[MAN
NAME];

"Handle the date issue"?

What would constitue handling it?