If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
create dropdown based on all people Not selectedyet to work onWork
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 |
#2
|
|||
|
|||
create dropdown based on all people Not selectedyet to work onWork
"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" wrote in message ... 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 |
#3
|
|||
|
|||
create dropdown based on all people Not selectedyet to work on
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 "Jeff Boyce" wrote: "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" wrote in message ... 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 . |
#4
|
|||
|
|||
create dropdown based on all people Not selectedyet to work on
Again, since we're not there, you'll have to give us a bit more to work
with. What is the SQL statement of the query you are using? 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" wrote in message ... 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 "Jeff Boyce" wrote: "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" wrote in message ... 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 . |
Thread Tools | |
Display Modes | |
|
|