Prev: Using Functions in Queries/Assigning Values to Non-numericalEntri
Next: Parsing
From: babs on 12 Mar 2010 17:52
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
From: Jeff Boyce on 12 Mar 2010 18:51
"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" <babs(a)discussions.microsoft.com> wrote in message
news:0FDC14FA-6C13-459A-849B-A13BB5799889(a)microsoft.com...
>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


 | 
Pages: 1
Prev: Using Functions in Queries/Assigning Values to Non-numericalEntri
Next: Parsing