Importing report from access database

http://www.mrhcok.com/careers/career.asp

domino3 · Apr 5, 2004

Thanks for your suggestion. I've tried creating a database connection and a pick list and detail page, but am still finding that the results appear in a long table on the screen. As there twenty to thirty fields I wish to show for eacgh record, it isn't very practical.

Is there any way of showing the record selected in a columnar layout individually, rather than a long table row?

Thank you

Noconi · Apr 5, 2004

In one of hte last steps of the DRW you can choose a list format with one fields per row, either paragraph breaks or single line breaks between the fields.. for example:

This was done with the DRW and without a table layout for the results/data.

Tiffany

Microsoft MVP - FrontPage

domino3 · Apr 5, 2004

Thanks, that's great.

I still seem to have a problem, though.

I downloaded the demo database 'autos' from the website you suggested, and have followed the instructions to try to create a display sheet and a picklist. However, when I go into "Preview in Brlwser", I get "> instead of a list of cars, which then returns no cars.

I think I followed the instructions correctly, and can't work out what I am doing wrong.

Any ideas?

Noconi · Apr 5, 2004

It sounds like there is somethin small missing in the code, like a < before the displaying ">. It's hard to tell without seeing the code though.

Are you previewing in a browser on a server that supports ASP?

Tiffany

Microsoft MVP - FrontPage

domino3 · Apr 5, 2004

I'm previewing before publishing. Do I need to publish to see the results?

Noconi · Apr 6, 2004

You need to publish it to a server with support for ASP if you are not previewing it against PWS or IIS locally, yes.

Tiffany

Microsoft MVP - FrontPage

domino3 · Apr 7, 2004

The server does support ASP.

My problem seems to come when I try to add a parameter value to the hyperlink.

My database is called web with one table with a field called name and a field called address, my pick list is called health_pick.asp and my display page is called health links. When I try to add a parameter value, I select the name field, right click to go into the hyperlink box and select health_links.asp

I then click parameters, but the insert field value button is greyed out, and there is already health-links.asp in the path box.

I tried publishing anyway and got the following error message on the website

Microsoft VBScript runtime error '800a000d'

Type mismatch: 'FP_FieldVal'

/pick_health.asp, line 55

Do you have any idea how I might solve this problem?

Thank you

Noconi · Apr 7, 2004

Yes. Publish it to a server that supports ASP and then view it in the browser.

Tiffany

Microsoft MVP - FrontPage

domino3 · Apr 7, 2004

I've checked with the webhost and they confirm that they do support ASP. Could there be any other reason for the error message

Microsoft VBScript runtime error '800a000d'

Type mismatch: 'FP_FieldVal'

/pick_health.asp, line 55

Noconi · Apr 7, 2004

Can you post the URL?

Tiffany

Microsoft MVP - FrontPage

http://rettsyndrome.org.uk/pick_health.asp

domino3 · Apr 8, 2004

The pages are

and

http://rettsyndrome.org.uk/health_links.asp

Noconi · Apr 8, 2004

You wrote:
--------------------------------------------
My database is called web with one table with a field called name and a field called address, my pick list is called health_pick.asp and my display page is called health links. When I try to add a parameter value, I select the name field, right click to go into the hyperlink box and select health_links.asp

I then click parameters, but the insert field value button is greyed out, and there is already health-links.asp in the path box.
-----------------------------------------------

OK - your table should have a default ID field, which is an auto number field.

When you create the hyperlink - you should highlight the <<ID>> and open the hyperlink dialog box - select your health_links.asp page, then click Parameters, Add, click in the Path box, Insert Field Value, choose ID from the dropdown list.

the mismatch error usually indicates that there is a mismatch in field types - like a field in the database that is set as a numerical field and you are trying to add or pull text from a numerical field.

Tiffany

Microsoft MVP - FrontPage