MIcroSoft Access WBS/Tree function.

Stav: Closed
Odměna: $178
Přijatých návrhů: 4
Vítěz: kmpal

Winner

Instrukce k soutěži

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.

Doporučené dovednosti

Winner

Zadejte podobnou soutěž

Zpětná vazba od zaměstnavatele

“As Promised”

gehyman22002, United States.

Veřejná nástěnka k vyjasnění projektu

Pořadatel soutěže
- Před 7 let
Only tow days left
- Před 7 let
Pořadatel soutěže
- Před 7 let
Yes, if its a Parent/Sibling its children should move with it.
- Před 7 let
robinLow
- Před 7 let
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?
- Před 7 let
Zobrazit 1 další zprávu
1. Pořadatel soutěže
  - Před 7 let
  Good Moring. Did you submit a Locked version? If so, I did not receive it.
  - Před 7 let
2. robinLow
  - Před 7 let
  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
  - Před 7 let
robinLow
- Před 7 let
When an existing entry is moved to another part of the tree, should the entries' children move with it?
- Před 7 let
workbyz
- Před 7 let
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.
- Před 7 let
1. Pořadatel soutěže
  - Před 7 let
  Try messaging me "gehyman22002" and adding it as an attachment
  - Před 7 let
ouzmetu
- Před 7 let
Hello Sir, if you provide your data I will start to work for your WBS project. Feel free to contact me. Thank you
- Před 7 let
1. Pořadatel soutěže
  - Před 7 let
  Right now I do not have any data in a database. I can creat some data if that is easier for you.
  - Před 7 let
2. Pořadatel soutěže
  - Před 7 let
  I attached a copy of a WBS. It is currently being created manually in Excel.
  - Před 7 let
kmpal
- Před 7 let
Is it ok if db used is access but app is sepeate?
- Před 7 let
1. kmpal
  - Před 7 let
  *separate (made in .net with required functionality)
  - Před 7 let
2. Pořadatel soutěže
  - Před 7 let
  yes
  - Před 7 let
Pořadatel soutěže
- Před 7 let
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.
- Před 7 let
Pořadatel soutěže
- Před 7 let
Additional information in new attachment
- Před 7 let
workbyz
- Před 7 let
i've made a sample but am still unable to upload it, .accdb(access file extension) is not supported.
- Před 7 let
1. Pořadatel soutěže
  - Před 7 let
  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.
  - Před 7 let
robinLow
- Před 7 let
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)
- Před 7 let
1. Pořadatel soutěže
  - Před 7 let
  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.
  - Před 7 let
2. Pořadatel soutěže
  - Před 7 let
  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
  - Před 7 let
Pořadatel soutěže
- Před 7 let
It is possible that situation may happen
- Před 7 let