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
|
|||
|
|||
Closing Records in Form
I have a table that several associates will enter Tasks. Some of the Task
Names will have the same name but a different form number field. How can I remove a Task Name from the "open" view once the Task Name has been closed? How do I make the driver the form number (since that is the different piece) rather than the Task Name? |
#2
|
|||
|
|||
Closing Records in Form
Have a field in your table to signify 'not open', something like CloseDate or
Yes/No field. Use that field in query criteria that feeds the form. -- KARL DEWEY Build a little - Test a little "Task Database Nightmare" wrote: I have a table that several associates will enter Tasks. Some of the Task Names will have the same name but a different form number field. How can I remove a Task Name from the "open" view once the Task Name has been closed? How do I make the driver the form number (since that is the different piece) rather than the Task Name? |
#3
|
|||
|
|||
Closing Records in Form
On Fri, 24 Oct 2008 07:15:01 -0700, Task Database Nightmare
wrote: I have a table that several associates will enter Tasks. Some of the Task Names will have the same name but a different form number field. How can I remove a Task Name from the "open" view once the Task Name has been closed? How do I make the driver the form number (since that is the different piece) rather than the Task Name? What does the term "form number" mean? Is that something within the structure of your table (which you have not posted), or something to do with an Access Form? Your question as posed seems to be about your own custom interface, rather than to Access. Access fields cannot be "closed" or "opened"; Access forms don't have "form numbers". Please explain, perhaps describing the structure of your table, and how your tables model "tasks" and "form numbers". -- John W. Vinson [MVP] |
#4
|
|||
|
|||
Closing Records in Form
In my table I have several fields. Three of which are
Task Name (Text Field - duplicates allowed) Form Number (Number Field - no duplicates) Status (Combo Box - choices are Open or Closed) Since there can be several records with the same Task Name but different Form Numbers, I need the query to drive off of Form Number when I choose to show only Open Tasks. That is what I don't know how to do. When I run the query if there are several tasks with the same name and all are closed by 1, it still shows me all the tasks with the same name whether they are opened or closed - that is why I am thinking I need to draw from form number. "John W. Vinson" wrote: On Fri, 24 Oct 2008 07:15:01 -0700, Task Database Nightmare wrote: I have a table that several associates will enter Tasks. Some of the Task Names will have the same name but a different form number field. How can I remove a Task Name from the "open" view once the Task Name has been closed? How do I make the driver the form number (since that is the different piece) rather than the Task Name? What does the term "form number" mean? Is that something within the structure of your table (which you have not posted), or something to do with an Access Form? Your question as posed seems to be about your own custom interface, rather than to Access. Access fields cannot be "closed" or "opened"; Access forms don't have "form numbers". Please explain, perhaps describing the structure of your table, and how your tables model "tasks" and "form numbers". -- John W. Vinson [MVP] |
#5
|
|||
|
|||
Closing Records in Form
Is anyone going to be able to help me with this? Please - thanks!
"Task Database Nightmare" wrote: In my table I have several fields. Three of which are Task Name (Text Field - duplicates allowed) Form Number (Number Field - no duplicates) Status (Combo Box - choices are Open or Closed) Since there can be several records with the same Task Name but different Form Numbers, I need the query to drive off of Form Number when I choose to show only Open Tasks. That is what I don't know how to do. When I run the query if there are several tasks with the same name and all are closed by 1, it still shows me all the tasks with the same name whether they are opened or closed - that is why I am thinking I need to draw from form number. "John W. Vinson" wrote: On Fri, 24 Oct 2008 07:15:01 -0700, Task Database Nightmare wrote: I have a table that several associates will enter Tasks. Some of the Task Names will have the same name but a different form number field. How can I remove a Task Name from the "open" view once the Task Name has been closed? How do I make the driver the form number (since that is the different piece) rather than the Task Name? What does the term "form number" mean? Is that something within the structure of your table (which you have not posted), or something to do with an Access Form? Your question as posed seems to be about your own custom interface, rather than to Access. Access fields cannot be "closed" or "opened"; Access forms don't have "form numbers". Please explain, perhaps describing the structure of your table, and how your tables model "tasks" and "form numbers". -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|