Workflow Approval Forms in Microsoft Access

[Alhakeem1977]

What is the best approach to achieve a splited database in Microsoft Access to generate an approval workflow forms dynamcly among the departments with a capobolaty to add a new forms from the back end database?

Thanks a lot in advance!

Sent from my HUAWEI NXT-L29 using Tapatalk

 

[GinaWhipp]

It sounds like you're asking about distributing updated Frontends. Though I don't get the adding new Forms to Backends because no Forms should be in the Backend.

So, if you want to do is distribute updated Frontends there are a multiple ways. Have a look at...
https://regina-whipp.com/blog/?p=184

https://access-programmers.co.uk/forums/showpost.php?p=743248&postcount=25

 

[MajP]

This is a pretty common question on this site. "How to create a workflow in Access?" As far as I know there is no good template, and I think you would have to create your own. At one time I outlined the table structure that would be required and you could probably search this site. I do not think the split database issue has anything to do with it, the design is the same either way. If you want to build it define the process and we can lay out a table structure to support.

 

[theDBguy]

What is the best approach to achieve a splited database in Microsoft Access to generate an approval workflow forms dynamcly among the departments with a capobolaty to add a new forms from the back end database?

Thanks a lot in advance!

Sent from my HUAWEI NXT-L29 using Tapatalk

You should try to define the work details as much as possible, so that you don't have to create more than one form. Being "dynamic" then means simply adding new tasks/work details instead of adding new "forms." The same form would simply display different data based on the work being processed.