Web Submissions form

Hi all,
I was hoping to get some help in locating a web based application that will take submissions of text and photos and then allow me to store the data in database form, and then use it in access, or have its own management app off the website.
If you have any idea of something that will allow me to do this, it would be greatly appreciated.
Thanks,
Dave

Let me get this straight.
Point 1
You want a form you your website that allows clients to upload text and photos to a MySQL database.
Point 2
You want to be able to pull those attachments from the Database into Microsoft Access?
Point 3
You want an application that handles the files and text in the Database?
Is the above correct?

1 - Yes, I want a form on my website to take information in the form of text as well as 3 or 4 images.
2 - I would like to take this information into a program like MS Access so it is viewable in a usable way.
3 - I dont follow. Ideally, I would be able to see the information and images gathered in MS access (or something similar) so I can search and print out individual records, or could e-mail the entire database to someone (or export it to excel file...?)
Thanks,
Dave

Quote:



Originally Posted by dagwag77


1 - Yes, I want a form on my website to take information in the form of text as well as 3 or 4 images.
2 - I would like to take this information into a program like MS Access so it is viewable in a usable way.
3 - I dont follow. Ideally, I would be able to see the information and images gathered in MS access (or something similar) so I can search and print out individual records, or could e-mail the entire database to someone (or export it to excel file...?)
Thanks,
Dave


Ok first of storing text and images in a MySQL database is possible using BLOB you can find a tutorial on how to use this function here:http://www.phpriot.com/articles/images-in-mysql
As for pulling the data from MySQL into MS Access this is possible using the ODBC Connections using the MySQL connector from www.mysql.com. This will only work if you can enable remote access to your database. Some hosts do not allow this.
You can then link the table to your access project.
This will work for the text but as standard Access will not handle BLOB you will have to write a VBA module. A good starting point is the following:http://www.jamiessoftware.tk/article...ingimages.html

do you know of any application already in existence that will allow me to do this that will be somewhat simple to install?

What exactly are you looking to achieve?

OK - heres the situation. I am looking to build a means which pawn shops can report to us their buys and sales, they currently copy the paper records and mail them, or, e-mail us the scans, and then it has to be manually enterred into an Access database so the information can actually be used to find stolen property, etc. I am looking for a way to get all this information collected on our website, by having the pawn broker enter it all via web form and uploads pics of the items pawned, and then have this information "download" to access where we can search/view/etc.

I think you may be better buidling the entire solution in PHP and SQL.
An Access front end connected to a SQL back end but can be quite slow if you are handling a lot of data. Are you set on the idea of using access?

I'm not dead set on using access, its just what I am familiar with. I'm not well versed in PHP or SQL

This may sound stupid, except for the MS office part, you can do all those things in a forum such as this one or PHPbb http://www.phpbb.com/about/features/






__________________▓ Hostirian (314) 216-7148Premier Colocation - Dedicated Servers▓ 24/7 365 NOC Tech Support sales@hostirian.com

Some of the information posted is considered sensitive/personal information regarding the persons buying/selling pawned merchandise, so a forum wouldn't be feasible. Thank you for the suggestion though.
Dave

hi
i do not understand

Quote:



Originally Posted by alans123


hi
i do not understand


Don't understand what?