MIcroSoft Access WBS/Tree function.

Statusi: Closed
Çmimi: $178
Kandidaturat e marra: 4
Fituesi: kmpal

Winner

Përmbledhja e konkursit

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.

Aftësi të rekomanduara

Winner

Posto një konkurs si ky

Vlerёsimi i punёdhёnёsit

“As Promised”

gehyman22002, United States.

Këndi publik i sqarimeve

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