File Upload to MS access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi;

I have inserted a file upload button in a form and linked this to Access db
assuming it would be that simple. Created a folder to upload the images to
and changed the folder properties to accept new file from the web. But when I
publish and try to upload a picture I receive the form page instead of the
confirmation page and there is nothing inserted in neither in the db nor the
folder.

I am not sure if thats when I should start using html vb or what. The
problem is I do not know any coding language. Can this be done without any
coding.

I created a real estate website and all I want to do is create a form that
collects new entries of houses and insert their pictures from the web. My
next step would be to create queries to show these properties on individual
pages.

Any help is appreciated.
by the way I am using fp02 and the page is created in .asp
 
See:
http://support.microsoft.com/?id=299763
&
http://support.microsoft.com/default.aspx?scid=kb;en-us;830324&Product=fp2002


--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WebMaster Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 
To do what you want without writint program code, you need to break the "new
listing" process into two steps.

1. First upload the picture, either by publishign through FrontPage or by
a file upload form dedicated to that purpose.

2. Develop a second form for adding all the other information, including
the picture file name.

I presume youl're going to use the Database Results Wizard to do your
searching. In that case, use a custom query with a field defined as:

SELECT ... , '<img src="foldername/' & [picname] & '">' as imgtag, ...

the report the imgtag field and in Column Value Properties select Column
Value Contains HTML.

Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
*-----------------------------­-----------------------
|\----------------------------­-----------------------
|| Microsoft Windows SharePoint Services Inside Out
|| Microsoft Office FrontPage 2003 Inside Out
||----------------------------­-----------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/----------------------------­-----------------------
*-----------------------------­-----------------------
 
Hi

Thank you for your answer. I have uploaded the file and it does work. I can
get the file in to a folder now. But ideally I would like to link this
picture to a certain upload.

For instance as I said I am developing a real estate website and the form
will have fields like number of rooms, location, price etc and it will give
the option to a user to upload a picture to relate to this property.

So when I extract results I can identify the property with an Id number and
the pictures will be linked to this property itself.

Via the link you have mentioned I have gone one step further but I need to
be using a database to insert the results instead of a folder.

Is there anyway I can achieve this.

Help is much appreciated as I am loosing it over this task.
--
Thanks
Hakan


Thomas A. Rowe said:
See:
http://support.microsoft.com/?id=299763
&
http://support.microsoft.com/default.aspx?scid=kb;en-us;830324&Product=fp2002


--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WebMaster Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
Click to expand...
 
Hi;

Thank you for your reply. Is there a step by step guide to the the following.
Also I am not sure how to use lists. I have FP02 with server extensions but
I have not got sharepoint. I beleive I need Sharepoint to enable List
function.

Is there any other way of uploading pictures and relating it to the relevant
information.

For instance as I mentioned on my previous post I am developing a real
estate website. I have many people who will be inserting data such as propety
information (number of rooms, price, location, pictures) to the database.

I have created the form to insert all the data into the databse but the
picture upload. If I was to create 2 different forms one to upload the info
and 2 to upload the picture how will I relate each entry to each other.

Any help is much appreciated asI am loosing it over this task.

--
Thanks
Hakan


Jim Buyens said:
To do what you want without writint program code, you need to break the "new
listing" process into two steps.

1. First upload the picture, either by publishign through FrontPage or by
a file upload form dedicated to that purpose.

2. Develop a second form for adding all the other information, including
the picture file name.

I presume youl're going to use the Database Results Wizard to do your
searching. In that case, use a custom query with a field defined as:

SELECT ... , '<img src="foldername/' & [picname] & '">' as imgtag, ...

the report the imgtag field and in Column Value Properties select Column
Value Contains HTML.

Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
*-----------------------------­-----------------------
|\----------------------------­-----------------------
|| Microsoft Windows SharePoint Services Inside Out
|| Microsoft Office FrontPage 2003 Inside Out
||----------------------------­-----------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/----------------------------­-----------------------
*-----------------------------­-----------------------

hakan said:
Hi;

I have inserted a file upload button in a form and linked this to Access db
assuming it would be that simple. Created a folder to upload the images to
and changed the folder properties to accept new file from the web. But when I
publish and try to upload a picture I receive the form page instead of the
confirmation page and there is nothing inserted in neither in the db nor the
folder.

I am not sure if thats when I should start using html vb or what. The
problem is I do not know any coding language. Can this be done without any
coding.

I created a real estate website and all I want to do is create a form that
collects new entries of houses and insert their pictures from the web. My
next step would be to create queries to show these properties on individual
pages.

Any help is appreciated.
by the way I am using fp02 and the page is created in .asp
Click to expand...
Click to expand...
 
You can do everything you want to do, but you will need to learn to hand code your own ASP and not
rely on the FP database components.

No matter what, it is not a good idea to store the image(s) directly in the database.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WebMaster Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

hakan said:
Hi

Thank you for your answer. I have uploaded the file and it does work. I can
get the file in to a folder now. But ideally I would like to link this
picture to a certain upload.

For instance as I said I am developing a real estate website and the form
will have fields like number of rooms, location, price etc and it will give
the option to a user to upload a picture to relate to this property.

So when I extract results I can identify the property with an Id number and
the pictures will be linked to this property itself.

Via the link you have mentioned I have gone one step further but I need to
be using a database to insert the results instead of a folder.

Is there anyway I can achieve this.

Help is much appreciated as I am loosing it over this task.
Click to expand...
 
If I was to create 2 different forms one to upload the info
and 2 to upload the picture how will I relate each entry to each other.
Click to expand...

You would have to hand-type the first record key on the second screen.

Realistically, the type of site you're describing is beyond the capabilities
of FrontPage. I know there are some tantalizing fragments but there are some
serious roadblocks as well.

Real estate listings are a popular type of site, so I'm sure there are
commercial packages and services that do this. Otherwise, you'll need to
sharpen (or develop) your programming skills.


Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Windows SharePoint Services Inside Out
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

hakan said:
Hi;

Thank you for your reply. Is there a step by step guide to the the following.
Also I am not sure how to use lists. I have FP02 with server extensions but
I have not got sharepoint. I beleive I need Sharepoint to enable List
function.

Is there any other way of uploading pictures and relating it to the relevant
information.

For instance as I mentioned on my previous post I am developing a real
estate website. I have many people who will be inserting data such as propety
information (number of rooms, price, location, pictures) to the database.

I have created the form to insert all the data into the databse but the
picture upload. If I was to create 2 different forms one to upload the info
and 2 to upload the picture how will I relate each entry to each other.

Any help is much appreciated asI am loosing it over this task.

--
Thanks
Hakan


Jim Buyens said:
To do what you want without writint program code, you need to break the "new
listing" process into two steps.

1. First upload the picture, either by publishign through FrontPage or by
a file upload form dedicated to that purpose.

2. Develop a second form for adding all the other information, including
the picture file name.

I presume youl're going to use the Database Results Wizard to do your
searching. In that case, use a custom query with a field defined as:

SELECT ... , '<img src="foldername/' & [picname] & '">' as imgtag, ...

the report the imgtag field and in Column Value Properties select Column
Value Contains HTML.

Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
*-----------------------------­-----------------------
|\----------------------------­-----------------------
|| Microsoft Windows SharePoint Services Inside Out
|| Microsoft Office FrontPage 2003 Inside Out
||----------------------------­-----------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/----------------------------­-----------------------
*-----------------------------­-----------------------

hakan said:
Hi;

I have inserted a file upload button in a form and linked this to Access db
assuming it would be that simple. Created a folder to upload the images to
and changed the folder properties to accept new file from the web. But when I
publish and try to upload a picture I receive the form page instead of the
confirmation page and there is nothing inserted in neither in the db nor the
folder.

I am not sure if thats when I should start using html vb or what. The
problem is I do not know any coding language. Can this be done without any
coding.

I created a real estate website and all I want to do is create a form that
collects new entries of houses and insert their pictures from the web. My
next step would be to create queries to show these properties on individual
pages.

Any help is appreciated.
by the way I am using fp02 and the page is created in .asp
Click to expand...
Click to expand...
Click to expand...
 
Back
Top