MobileMobile | Continue

Excel Bar

Excel Bar

Your excel questions will be responsed by our excel experts within 24hrs.Our service is free.

 Forgot Pass?
 Register Now
Find
Hot Search: Vlookup Match VBA
View: 303|Reply: 7

CAn an Access Database be set to flag tasks to be carried out by individuals?

[Copy link]

1

Topics

3

Posts

9

Integral

Newbie

Rank: 1

Integral
9
Post on 9-14-2016 18:32:31 | All posts |Read mode
Hi,
as the title says, I need to be able to flag tasks that need doing but also point the task in the direction of an individual or individuals. Is this something that can be achieved with the Access Database. The task would need to be seen by the department responsible for completing the task and the individual reminded that the task is apparent. The task would need to be closed when complete.
I have been using Outlook email system but people are forever loosing, deleting or somehow changing the notifications and some important jobs are being overlooked!!!
TIA,
Lurch.




Reply

Props Report

7

Topics

551

Posts

1283

Integral

King

Rank: 6Rank: 6

Integral
1283
Post on 9-14-2016 19:55:18 | All posts



Any application capable of processing/tracking lists can do that... but it means you develop the system. You also need to develop some means of notifying users, progressing/closing tasks, chasing overdues etc etc etc...
There is an Team Task management template for Access (Simple search to find that) and newer versions of Acess can publish that to Sharepoint server, if you have one, so the database can be run in a browser.




Reply Support Opposition

Props Report

1

Topics

3

Posts

9

Integral

Newbie

Rank: 1

Integral
9
 Author| Post on 9-14-2016 20:48:22 | All posts



Thank for the reply cytop,
Wow, not a clue what any of that is about, I'm basically a total learner when it comes to the Access Database, so I take it that this is a bit more complicated for me to achieve and would need to get someone in to achieve this?
Cheers,
Lurch.




Reply Support Opposition

Props Report

7

Topics

551

Posts

1283

Integral

King

Rank: 6Rank: 6

Integral
1283
Post on 9-14-2016 20:59:21 | All posts



Developing anything is complicated, depending on your ability (Either to write the thing or pay for it to be written). You could try the Access template and see if it'll work out of the box. At least it's a start and you might be able to fiddle around the edges - or get someone to customise it for you.




Reply Support Opposition

Props Report

1

Topics

3

Posts

9

Integral

Newbie

Rank: 1

Integral
9
 Author| Post on 9-14-2016 22:16:35 | All posts



Thanks cytop,
I have found 'Use the Task Management Access Database template' using a google search, I will have a read and see if I can come up with anything,
Thanks again,
Lurch.
Reply Support Opposition

Props Report

11

Topics

130

Posts

283

Integral

Conqueror

Rank: 3Rank: 3

Integral
283
Post on 2-6-2017 23:46:45 | All posts



the simple formula












Reply Support Opposition

Props Report

13

Topics

1065

Posts

2355

Integral

King

Rank: 6Rank: 6

Integral
2355
Post on 2-7-2017 01:15:35 | All posts



What is the source of the #VALUE# error? My first thought would be to nest the current function in B so that it returns some kind of text string when it errors, then the sum function ImramBhatti suggested would work fine. Are you familiar with the IFERROR() function? https://support.office.com/en-us/art...6-63f3e417f611
Something like =IFERROR(current formula in B,error)











Reply Support Opposition

Props Report

14

Topics

436

Posts

1026

Integral

King

Rank: 6Rank: 6

Integral
1026
Post on 2-7-2017 02:38:12 | All posts



This is inappropriate language. Further offenses will result in a ban.

Common courtesy is the order of the day. Avoid coarse language, personal attacks and inflammatory remarks. Address your concerns at topics and not at people.
Reply Support Opposition

Props Report

Points policy of this forum

Archiver|Mobile|Small dark house|Contact us|Excel Bar

GMT-5, 11-18-2017 04:58 , Processed in 0.178485 second(s), 20 queries .

Powered by Discuz! X3

© 2001-2013 Comsenz Inc.

!fastreply! Top !return_list!