create a approval workflow form in ms access

[masoud_sedighy]

Hi
I need where the project gets assigned to the next department in a workflow automatically when completed and each person in that department gets notified that the project is now in their queue

I appreciate if you can address me for some samples like this for download and getting idea.

 

[Gasman]

Have a table with the workflow order, then lookup the next in sequence and assign accordingly.?
So as a dept marks complete, carry out that process.

 

[theDBguy]

Hi. When you use the term "workflow," I think of SharePoint. Are you using SharePoint? Just curious...

 

[masoud_sedighy]

Thanks alot Gasman for your help, for getting more idea If you know or have some templates or samples have used this solution please inform to me.

 

[masoud_sedighy]

I do not use Sharepoint now, just I need to do a workflow form in ms access.

 

[theDBguy]

I do not use Sharepoint now, just I need to do a workflow form in ms access.

Hi. Thanks for the clarification. I'll leave you alone then. Good luck!

 

[Gasman]

Thanks alot Gasman for your help, for getting more idea If you know or have some templates or samples have used this solution please inform to me.

No nothing I'm afraid. I just proposed how I would likely approach it.

Have a WorkFlowSeq assigned to each record, then using current number look for the next sequence and apply whatever process you need to do. That way if the process changes, you change data, not code.?

Use a DMax function to determine the last process each time, so you know when the process has reached it's last step.

As a sequence is marked as complete, find the next if not last, and then assign to that.

Allow for being rejected and assigned back to previous dept if required.?

HTH