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
|
|||
|
|||
Task List with tasks link to daily, day of week or other
I am attempting to build a database that will generate a task list for
multiple workstations. I have tasks that need to be completed either daily, on a certain day of the week, or mutiple days of the week. I am unclear how to associate the task(s) with the appropriate frequency. Also, I would like to have the query use the system clock to determine the appropriate day of the week. Thoughts? Mark |
#2
|
|||
|
|||
Task List with tasks link to daily, day of week or other
There is a sample mdb for creating recurring events at
http://www.rogersaccesslibrary.com/O...p#Hookom,Duane. To get the "appropriate day of the week", you can use Date() in your queries. -- Duane Hookom MS Access MVP "MSEMD" wrote in message ... I am attempting to build a database that will generate a task list for multiple workstations. I have tasks that need to be completed either daily, on a certain day of the week, or mutiple days of the week. I am unclear how to associate the task(s) with the appropriate frequency. Also, I would like to have the query use the system clock to determine the appropriate day of the week. Thoughts? Mark |
#3
|
|||
|
|||
Task List with tasks link to daily, day of week or other
Mark,
Here's a suggestion --- Create these tables --- TblWorkstation WorkstationID WorkstationName etc TblTask TaskID TaskDescription TblWorkstationTask WorkstationTaskID WorkstationID TaskID WeekDayToBeDone Note: WeekDayToBeDone Is an integer. Sunday =1, Monday = 2, Tuesday = 3, etc. For data entry build a form/subform. Base the main form on TblWorkstation and the subform on TblWorkstationTask. You will have multiple records in the subform for the tasks that are performed on any workstation more than once per week. Set the Linkmaster/LinkChild properties to WorkstationID. For displaying the tasks to be done today, also use a form/subform. In the mainform, you need two unbound textboxes. Name the first textbox "TodaysDate" and put the following expression in its ControlSource: =Date() Name the second textbox "TodaysWeekDay" and put the following expression in its ControlSource: =WeekDay(Date()) For the subform, create a query based on all three tables and include the appropriate fields to identify the workstation and the task. Be sure to include WeekDayToBeDone from TblWorkstationTask. For the LinkMaster property, type in [TodaysWeekDay] and for the LinkChild property, type in [WeekDayToBeDone]. When this form opens, it will display a list of tasks for each workstation for today. I have a week calendar form and report module. It could be used to display the schedule of tasks for your workstations in a calendar layout. As the module name implies the form and report look like a page torn off a calendar. I can implement my calendar form and report module in your database for a very reasonable fee. If you are interested, contact me at my email address below and I will send you a screenshot. -- PC Datasheet Your Resource For Help With Access, Excel And Word Applications www.pcdatasheet.com Over 1000 Access users have come to me for help. My fees are very reasonable. "MSEMD" wrote in message ... I am attempting to build a database that will generate a task list for multiple workstations. I have tasks that need to be completed either daily, on a certain day of the week, or mutiple days of the week. I am unclear how to associate the task(s) with the appropriate frequency. Also, I would like to have the query use the system clock to determine the appropriate day of the week. Thoughts? Mark |
#4
|
|||
|
|||
Task List with tasks link to daily, day of week or other
"PC Datasheet" wrote in message
ink.net... Mark, I have a week calendar form and report module. It could be used to display the schedule of tasks for your workstations in a calendar layout. As the module name implies the form and report look like a page torn off a calendar. I can implement my calendar form and report module in your database for a very reasonable fee. If you are interested, contact me at my email address below and I will send you a screenshot. Still ignoring the rules? These newsgroups are for free support not an oppurtunity to harass users for money. John... Visio MVP |
#5
|
|||
|
|||
Task List with tasks link to daily, day of week or other
Ronbo, sorry about the inappropriate solicitation post you received in this
thread. the purpose of these unmonitored newsgroups is to offer free assistance, advice, and suggestions from fellow Access developers, to answer your question(s) and help you build a better database. hopefully MVP Duane Hookom's sample database (see his response elsewhere in this thread) will help you solve your current issue. if not you can always post back to this thread, or start a new thread, for additional help. hth "MSEMD" wrote in message ... I am attempting to build a database that will generate a task list for multiple workstations. I have tasks that need to be completed either daily, on a certain day of the week, or mutiple days of the week. I am unclear how to associate the task(s) with the appropriate frequency. Also, I would like to have the query use the system clock to determine the appropriate day of the week. Thoughts? Mark |
#6
|
|||
|
|||
Task List with tasks link to daily, day of week or other
Here's what another poster sais about John Marshall --
"That's good, you hypocritical piece of ****. " Also tell your friend Arno R to quit sending emails to my office. -- PC Datasheet Your Resource For Help With Access, Excel And Word Applications www.pcdatasheet.com "John Marshall, MVP" wrote in message ... "PC Datasheet" wrote in message ink.net... Mark, I have a week calendar form and report module. It could be used to display the schedule of tasks for your workstations in a calendar layout. As the module name implies the form and report look like a page torn off a calendar. I can implement my calendar form and report module in your database for a very reasonable fee. If you are interested, contact me at my email address below and I will send you a screenshot. Still ignoring the rules? These newsgroups are for free support not an oppurtunity to harass users for money. John... Visio MVP |
#7
|
|||
|
|||
Task List with tasks link to daily, day of week or other
Tina,
Where does it say "....the purpose of these unmonitored newsgroups is to offer free assistance, advice, and suggestions from fellow Access developers, to answer your question(s) and help you build a better database."? Your statement is false!!! -- PC Datasheet Your Resource For Help With Access, Excel And Word Applications www.pcdatasheet.com Over 1000 Access users have come to me for help. My fees are very reasonable. "tina" wrote in message ... Ronbo, sorry about the inappropriate solicitation post you received in this thread. the purpose of these unmonitored newsgroups is to offer free assistance, advice, and suggestions from fellow Access developers, to answer your question(s) and help you build a better database. hopefully MVP Duane Hookom's sample database (see his response elsewhere in this thread) will help you solve your current issue. if not you can always post back to this thread, or start a new thread, for additional help. hth "MSEMD" wrote in message ... I am attempting to build a database that will generate a task list for multiple workstations. I have tasks that need to be completed either daily, on a certain day of the week, or mutiple days of the week. I am unclear how to associate the task(s) with the appropriate frequency. Also, I would like to have the query use the system clock to determine the appropriate day of the week. Thoughts? Mark |
#8
|
|||
|
|||
Task List with tasks link to daily, day of week or other
PC Datasheet wrote:
Tina, Where does it say "....the purpose of these unmonitored newsgroups is to offer free assistance, advice, and suggestions from fellow Access developers, to answer your question(s) and help you build a better database."? Your statement is false!!! Not only have many people said it on this newsgroup and elsewhere, but it should also have been evident from the nature of the messages other people have posted. It doesn't take lots of intelligence to be able to infer this. (But I have seen some apparently helpful postings from you, and I expect that those are appreciated.) -- Vincent Johns Please feel free to quote anything I say here. |
#9
|
|||
|
|||
Task List with tasks link to daily, day of week or other
Many inferences can be made from your post by "intelligent" people. That
doesn't mean any of them are correct. Tina made an outright false statement and all I'm asking is for her to back up what she said or to quit making false statements. No response will be taken that she can not back up her statement and therefore by implication the statement is false. BTW, have you read the rules for the newsgroups? -- PC Datasheet Your Resource For Help With Access, Excel And Word Applications www.pcdatasheet.com Over 1000 Access users have come to me for help. My fees are very reasonable. "Vincent Johns" wrote in message news PC Datasheet wrote: Tina, Where does it say "....the purpose of these unmonitored newsgroups is to offer free assistance, advice, and suggestions from fellow Access developers, to answer your question(s) and help you build a better database."? Your statement is false!!! Not only have many people said it on this newsgroup and elsewhere, but it should also have been evident from the nature of the messages other people have posted. It doesn't take lots of intelligence to be able to infer this. (But I have seen some apparently helpful postings from you, and I expect that those are appreciated.) -- Vincent Johns Please feel free to quote anything I say here. |
#10
|
|||
|
|||
Task List with tasks link to daily, day of week or other
And by the way, if you are referring to Arno R, John Marshall, and Randy
Harris, count up how many helpful posts these dimwits have made and then judge their right to pollute the newsgroups with their worthless garbage and suck up bandwidth. "Vincent Johns" wrote in message news PC Datasheet wrote: Tina, Where does it say "....the purpose of these unmonitored newsgroups is to offer free assistance, advice, and suggestions from fellow Access developers, to answer your question(s) and help you build a better database."? Your statement is false!!! Not only have many people said it on this newsgroup and elsewhere, but it should also have been evident from the nature of the messages other people have posted. It doesn't take lots of intelligence to be able to infer this. (But I have seen some apparently helpful postings from you, and I expect that those are appreciated.) -- Vincent Johns Please feel free to quote anything I say here. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Week number and day number... | Michael | Running & Setting Up Queries | 13 | November 4th, 2005 07:14 AM |
Outlook today should show tasks based on Start Date, not due date | Rose | General Discussion | 10 | October 9th, 2005 03:14 AM |
How do I set daily print style to show just active tasks in task . | Colin | General Discussion | 1 | April 20th, 2005 02:15 AM |
synchronizing form and list box | Deb Smith | Using Forms | 8 | June 21st, 2004 08:15 PM |
How to hide completed tasks in task list in calendar view | news.rcn.com | General Discussion | 0 | June 19th, 2004 04:28 PM |