A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Task List with tasks link to daily, day of week or other



 
 
Thread Tools Display Modes
  #1  
Old November 26th, 2005, 05:36 PM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default 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  
Old November 26th, 2005, 05:52 PM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default 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  
Old November 26th, 2005, 06:17 PM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default 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  
Old November 26th, 2005, 09:09 PM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default 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  
Old November 27th, 2005, 12:59 AM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default 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  
Old November 27th, 2005, 02:11 AM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default 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  
Old November 27th, 2005, 02:14 AM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default 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  
Old November 27th, 2005, 03:13 AM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default 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  
Old November 27th, 2005, 04:16 AM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default 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  
Old November 27th, 2005, 04:21 AM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Week number and day number... Michael Running & Setting Up Queries 13 November 4th, 2005 08: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


All times are GMT +1. The time now is 03:18 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.