create dropdown based on all people Not selectedyet to work onWork

[babs]

I have a dropdown based on all employee. Once the person is Scheduled to
work on a given Workdate (of the record I am Sitting on ) field Name is
workdate I would like that name to be eliminated from the dropdown

when to new workdate- would LIke drop down to show All People Not scheduled
yet for that Given record(workdate that is active) I am seting up a query
(recordset) for the dropdown but not sure what to put in the criteria for
workdate

<>[workdate]

get No records or do I reference the Control on the subform the???
me!subformname??? not sure of correct syntax???

Thanks,
Barb

 

[Jeff Boyce]

"How" depends on "what" ... and you haven't really described your data
structure in much detail.

A generic (lack of detail) approach would be to store all
Employee_Scheduled_On_Workdate data in a table, so that you can run a query
on All Employees_Not_In_Your_Scheduled_Employees table.

You'd do this by first getting all employees, then using an unmatched query
to find which ones are not scheduled. That provides your combobox a list of
(remaining) candidates.

You'll still need a way to limit the list to a particular date/time range.

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[babs]

Yes, I am doing what you have said above -but don't know how to handle the
for the current DATE of the record I am presently ON

You'll still need a way to limit the list to a particular date/time range.

Do you have any ideas for this??? do I handle the date in the unmatched
query?? and what syntax -- my field name is workdate???

thanks,
barb

"How" depends on "what" ... and you haven't really described your data
structure in much detail.

A generic (lack of detail) approach would be to store all
Employee_Scheduled_On_Workdate data in a table, so that you can run a query
on All Employees_Not_In_Your_Scheduled_Employees table.

You'd do this by first getting all employees, then using an unmatched query
to find which ones are not scheduled. That provides your combobox a list of
(remaining) candidates.

You'll still need a way to limit the list to a particular date/time range.

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

I have a dropdown based on all employee. Once the person is Scheduled to
work on a given Workdate (of the record I am Sitting on ) field Name is
workdate I would like that name to be eliminated from the dropdown

when to new workdate- would LIke drop down to show All People Not
scheduled
yet for that Given record(workdate that is active) I am seting up a query
(recordset) for the dropdown but not sure what to put in the criteria for
workdate

<>[workdate]

get No records or do I reference the Control on the subform the???
me!subformname??? not sure of correct syntax???

Thanks,
Barb

.