Käynnissä

MS Project VBA & sql database

The project requires knowledge of VBA and MS Project Server 2003.

We have a SQL database and want to create enterprise projects from this database, using Enterprise resources , we also want to post actuals automatically from our sql database and update automatically. Also tasks may be added or deleted from our proprietary sql database , the solution must be smart enough to check for updates and additions and change the project accordingly.

More info:
Our company makes concrete pieces, like columns, wall caps, pavers, balustrades etc... we make molds then pour concrete into molds and wait a day, then we remove the piece from the mold so that the mold can create another piece.

- we currently have 2 sql databases, 1 holds the information to create the project (our bid system) the other tracks our product manufacturing via barcode scanning.
- A project can be created from the first database, it includes unique ID, name, overall completion date, production complete by date, phase #, phase completion date, (pieces x 6 hrs = duration), maybe other fields
from these fields production tasks are created, also mold production tasks are created (for each piece created a mold must be created) - (some tasks have premade molds so these tasks do not need a new mold created)

- each piece of concrete gets a barcode tag attached to it, with this tag we can track completion and track location. from this data our actuals can be entered into ms project to show percentage complete.


the Project server 2003 component and SQL database are quite complex and I do not really have time to do this myself, time is important, I am looking to get this done in 2 weeks from the start of the job.

I have had questions on our current systems. To describe it more ....
We bid on construction projects, we calculate all the pieces needed for construction and enter them into a custom VB program that is saved to SQL.
Our barcode program saves directly to SQL via another VB program.

attached is more detail

Much of what I am asking to be done is basic functionality, and much of it could be done by recording a macro. The only special pieces are getting the data from SQL.
Many of the time estimates are too long, if you are over 14 days then you will not be considered.

Although not a VBA programmer I am an ASP programmer, so I want to pay someone to fill in the basic gaps to give me a start.
I can handle all the sql queries but I do not know how to do anything in project.
So I want to get some kind of button put into project, that will ask for a uniqueID to query in my proprietary database and go get information and creates a new project with tasks.
another button enters the actuals as % complete.
So all I should need to provide is an example project file, and the sample database with 2 tables (1 for actuals, 1 for project)
the vba code must create a project with the same content as the sample project.

I have attached a crude example in microsoft project format, which may help you see what is required.

in the attached project file there are notes for most tasks that indicate any parameters that are set for that task.
I have not included any leveling requirements. i will deal with that later.

Taidot: tietojenkäsittely, projektinhallinta, Visual Basic

Näytä lisää: project vba sql, project vba, project sql database, vba project 2003 sql, project database vba, project vba examples, project vba database, ms processing, project 2003 sql, project server 2003 vba, vba project database, project 2003 vba sql, project vba combined find, vba project actual cost period calculation, vba update project, vba microsoft project, open sql database vba, microsoft project vba examples, vba sample open database, vba database update, vba project sql statement, project vba sql server connection example, access data project vba, simple sql database, microsoft project vba

Tietoa työnantajasta:
( 1 arvostelu ) west palm beach, United States

Projektin tunnus: #7077

Myönnetty käyttäjälle:

TLearningC

By utilizing vb.net you could certain create an application that will do all that you have asked for. I am a bit curious what systems are in place currently that you are leveraging to update and manage this system? D Lisää

500 $ USD 10 päivässä
(0 arvostelua)
3.4

25 freelanceria on tarjonnut keskimäärin 439 $ tähän työhön

siddhartha1

Dear sir, We have gone through ur requirements, we are a team of professionals and we have a programmer who has in depth knowledge of VBA and MS Project Server 2003. We can do it as per ur requirement. Pls contact Lisää

480 $ USD 12 päivässä
(4 arvostelua)
5.2
tanuj99

please see pmb for details

500 $ USD 9 päivässä
(1 arvostelu)
3.0
sunita123

Hello, I have wide area experience in open source technology like php/c++/linux/so files/fusebox AND WINDOW based ASP,COM,DCOM,MTS,VB,VC++,.NET,Flash Please forward me your mail ID so i can forward you project proposal Lisää

470 $ USD 15 päivässä
(1 arvostelu)
2.0
mail2veejay

we are a group of 2 programmers and one designer having proficiency in providing customized database driven application part from dynamic and static sites with a combined experience of over 12 years in VB, ASP MSSQL an Lisää

480 $ USD 31 päivässä
(2 arvostelua)
2.1
RRAJKUMAR

It can be done.

450 $ USD 20 päivässä
(0 arvostelua)
4.0
vivekranga

dear sir i got ur requirement and i m sure i can fullfill ur requirement. i can manage ur further requirements also as i have team of programmers. expecting this project from ur side. vivek

450 $ USD 30 päivässä
(0 arvostelua)
0.0
aquasofts

Dear Sir/Madam, We are happy to serve you our extraodinary work. We are in the IT Market for the past 4 years and done numerous successful projects. We assure you that we do the work to satisfy you to the best. So Lisää

350 $ USD 12 päivässä
(0 arvostelua)
0.0
davegosline

i am company sales manager usa, we are outsourcing firm called matirp co-operation based in india. i can do this for real cheap and can provide support too. but if you are still looking for a freelancer or outsourcing Lisää

450 $ USD 15 päivässä
(0 arvostelua)
0.0
sevenappsdotnet

i will do that please open PMB for more details. regards admin, sevenapps [url removed, login to view]

500 $ USD 15 päivässä
(0 arvostelua)
0.0
tinto

Hello. We are confident to deliver your project in quality on time within budget. We could help to strengthen your concept further by sharing our experience and expertise

300 $ USD 10 päivässä
(0 arvostelua)
0.0
bid2

we can do it.

500 $ USD 10 päivässä
(0 arvostelua)
0.0
handylogix

We are group of talented techies providing freelance software solutions in web development, application consulting, infrastructure consulting, client server development. We have experience in developing applications Lisää

400 $ USD 10 päivässä
(0 arvostelua)
0.0
DENISH

we will provide fastest and best quality software.

450 $ USD 30 päivässä
(0 arvostelua)
0.0
Prislogix

you can visit some of the following sites which are developed by our company or by the high tech professionals who are working with us in PrisLogix. [url removed, login to view] [url removed, login to view] Lisää

500 $ USD 35 päivässä
(0 arvostelua)
0.0
zeeshansyed

Please see PMB.

400 $ USD 14 päivässä
(0 arvostelua)
0.0
pankajtak

i can do it

500 $ USD 40 päivässä
(1 arvostelu)
0.0
anshumesh

"We are with the name Infinite Outsourcing experts in Web development,Search Engine Optimisation and BPO from India .Kindly go through our url [url removed, login to view] . Kindly Lisää

500 $ USD 25 päivässä
(0 arvostelua)
0.0
qweb

We have checked your requirement, We can do it, Pls contact via pmb for further discussion. Thanks

425 $ USD 10 päivässä
(0 arvostelua)
3.2
AYAZUL

i am in ms project consultancy

410 $ USD 10 päivässä
(0 arvostelua)
0.0
balajijk

Hi, I have good technical experience in these kind of work, I have done projects of this kind and many. I assure you of timely response for all the queries and support and with good quality. Please reply back we Lisää

200 $ USD 10 päivässä
(0 arvostelua)
0.0