I wonder if someone can help us out. We've got a database hosted as separate tables on an SQL server, which we interrogate through an Access front-end.
Every year, we send a survey out to all our members. We've previously written it in Word, sent it in the post, people have filled it in, then someone has entered it into an Excel sheet, which I've then laboriously managed to get into SQL using Enterprise manager. It seems a ridiculous waste of time and money to pay someone to data entry, and to ask people to write out forms and for us to pay them.
It seems much better to design a web form that has all the questions in it, with answers entered via drop-downs, radio buttons and the like, the ensure answers get entered properly, which then passes all the answers to the appropriate tables in our SQL server.
Obviously, this takes time and thus money, but as this process already cost us in terms of hiring someone to data enter and the postsage and printing costs, we've got a small budget for it. If anyone is interested, I'd love to hear from you.
Any expressions of interest would be most welcome by tomorrow to be honest; ideally, I'd like to get this live in the next week, so if you could indicate how much you reckon it would be, and how long it would take (which are probably the same thing!), that'd be great. Probably best to email me provately if you are interested.
― Dave B (daveb), Thursday, 25 May 2006 10:48 (nineteen years ago)
are you putting this new information into an existing table? That's the only thing that might be a bit difficult, otherwise it sounds pretty easy (even for someone like me who barely knows what they're doing). If you're making a whole new table (2006 Survey Results), you can probably do it yourself using something like this:
http://phpformgen.sourceforge.net/― teeny (teeny), Thursday, 25 May 2006 11:32 (nineteen years ago)
oh and I'd certainly be happy to help if you think it's beyond your capabilities.
― teeny (teeny), Thursday, 25 May 2006 11:49 (nineteen years ago)
Yeah - it goes into an existing table, I'd be _so_ grateful if you could.
― Dave B (daveb), Thursday, 25 May 2006 13:35 (nineteen years ago)
If Teeny runs into trouble let me know. I've just done that exact thing for one of our departments.
― Miss Misery xox (MissMiseryTX), Thursday, 25 May 2006 13:43 (nineteen years ago)
is it SQL or mySQL? I'm gonna gmail you, it may be beyond my capabilities, someone like koogs or sam or forest pines or well any number of people might be more helpful but then again they have jobs and I don't!
xp haha speak of the devil!
― teeny (teeny), Thursday, 25 May 2006 13:47 (nineteen years ago)
I'd like our new person in charge of our databases to be able to do this, but she just wants to use excel for everything it seems :(
― beanz (beanz), Thursday, 25 May 2006 15:10 (nineteen years ago)
doesn't Access form designer allow you to save as (or export) thing that'll work on a webpage? (don't use access here so my knowledge is limited)
http://www.cs.stthomas.edu/faculty/resmith/c/qmcs110/m/accchsh.html
might allow everyone in the world to see all the data (which is a bad thing) but...
― koogy wonderland (koogs), Thursday, 25 May 2006 15:26 (nineteen years ago)
what I would do is a SQL database (through Access) and PHP. B/c that's all I know how to. ;)
― Miss Misery xox (MissMiseryTX), Thursday, 25 May 2006 15:33 (nineteen years ago)
I've been using
Visual Web Developer the past month to implement C# and ASP.NET for this sort of thing. Fairly straightforward drag-n-drop tools and simple SQL connections. It does help to have a decent command of html and SQL queries/stored procedures though.
― Jaq (Jaq), Thursday, 25 May 2006 15:36 (nineteen years ago)