MIcroSoft Access WBS/Tree function.

Status: Closed
Prize: $178
Entries Received: 4
Winner: kmpal

Winner

Contest Brief

I am looking to be able to build what in my industry is called a Work Breakdown Structure (WBS) in Access (aka a Tree Function). If you know what a WBS is, you will have a big advantage. But please look at the attachment before you put time into this. The program should be able to number the Tasks automatically and there must be the ability to move a task or insert a task into the WBS as its being built (adding tasks out of sequence). It should be able to calculate the WBS Number.

Not getting many responses and not sure why. I did a little research and found a lot of information just by searching "MS Access Tree" in google. Looks like there is code already written for the Node function.

Someone asked for an example of the WBS. Obviously I don't have it in Access. Right now it is being done manually in Excel. Attached is an example

There is a Youtube Video (search MS Access Tree) presented by Andrew Vickers (its 58 min long). What he describes in this video is exactly what I need. The numbering of the WBS numbers... can easily be added to this. It gives you the node level and Parent so numbering from there is logical.

Recommended Skills

Winner

Post a Contest Like This

Employer Feedback

“As Promised”

gehyman22002, United States.

Public Clarification Board

Contest Holder
- 7 years ago
Only tow days left
- 7 years ago
Contest Holder
- 7 years ago
Yes, if its a Parent/Sibling its children should move with it.
- 7 years ago
robinLow
- 7 years ago
Will the user need a way to change the order of two entries that are under the same parent? If so, how would the user use the "Drop down" menu interface to request that?
- 7 years ago
View 1 more message
1. Contest Holder
  - 7 years ago
  Good Moring. Did you submit a Locked version? If so, I did not receive it.
  - 7 years ago
2. robinLow
  - 7 years ago
  I will submit but but before I start, please answer the question "When an existing entry is moved to another part of the tree, should the entries' children move with it?" #extended
  - 7 years ago
robinLow
- 7 years ago
When an existing entry is moved to another part of the tree, should the entries' children move with it?
- 7 years ago
workbyz
- 7 years ago
Hello, I am unable to upload my entry, I have a zip file. It seems that the only entries allowed are image files PNG,JPG and GIF.
- 7 years ago
1. Contest Holder
  - 7 years ago
  Try messaging me "gehyman22002" and adding it as an attachment
  - 7 years ago
ouzmetu
- 7 years ago
Hello Sir, if you provide your data I will start to work for your WBS project. Feel free to contact me. Thank you
- 7 years ago
1. Contest Holder
  - 7 years ago
  Right now I do not have any data in a database. I can creat some data if that is easier for you.
  - 7 years ago
2. Contest Holder
  - 7 years ago
  I attached a copy of a WBS. It is currently being created manually in Excel.
  - 7 years ago
kmpal
- 7 years ago
Is it ok if db used is access but app is sepeate?
- 7 years ago
1. kmpal
  - 7 years ago
  *separate (made in .net with required functionality)
  - 7 years ago
2. Contest Holder
  - 7 years ago
  yes
  - 7 years ago
Contest Holder
- 7 years ago
Not getting many responses and not sure why. I did a little research and found a lot of information just by searching "MS Access Tree" in google. Looks like there is code already written for the Node function.
- 7 years ago
Contest Holder
- 7 years ago
Additional information in new attachment
- 7 years ago
workbyz
- 7 years ago
i've made a sample but am still unable to upload it, .accdb(access file extension) is not supported.
- 7 years ago
1. Contest Holder
  - 7 years ago
  Were you going to submit a entry? The Help Chat function of Freelancer could help you or you can send it to my email if all else fails.
  - 7 years ago
robinLow
- 7 years ago
Do you need a drag-n-drop interface for moving the entries around?
If not, would the user "move" an entry by changing its parent field?

When an existing entry is moved, should the entries' children move with it?
(this question comes up in any tree-view implementation)

Do you need the sum-of-values computed as part of this software?

Do you want the contest entry submitted in the form of a protected Access file (so that you can test the solution, but not use the loosing entries, which would be unfair)
- 7 years ago
1. Contest Holder
  - 7 years ago
  Is a Drag and Drop a possibility? I didn't know Access could do that or not. Though a drag and drop would mean that the other WBS would need to renumber themselves if the user dragged.
  - 7 years ago
2. Contest Holder
  - 7 years ago
  No to the Sum. As to the submittal, if youre more comfortable with a protected copy, I am fine with that, but at some point I will need to review and approve the final. But for selecting a winner, a protected works for me
  - 7 years ago
Contest Holder
- 7 years ago
It is possible that situation may happen
- 7 years ago