Exporting Reports to HTML

[Jeff Gregor]

I'm making a fairly basic webpage for an agricultural marketing
association, tha will display a list of farms who have a certain
product (corn, etc) when selected from a list on the web page.

So I make a quick database in Access XP, which works fine.
I believed that after setting up a nice report, I could export it as
HTML. Well, it did export, but to several linked pages, instead
of one long one, and the images on the report (That are displayed
conditionally on a Yes\No Field being true) that appear in the report
correctly before exporting, do not appear.

I'd also lke to put a seperator between records, but again, any lines
I put dont appear after exporting.

Can I make this work? I'm I bit lost on this...

 

[Chris Nebinger]

You are probably better of recreating the reports in ASP.
A good reference site is ASP101.com. Also, picking up a
good book would be of immediate value as well.


Chris Nebinger

 

[Guest]

Hi Jeff
I resolved the problem you have by the following method.
I created a web page in front page with the desired layout, inserting dummy pictures and text into a table (allows you to have lines or boxes) and create space
You will need a cell each for images and text as required.
I then copied the resulting HTML code into a an event procedure attached to the On Click of a Command Button
I then converted the HTML code to force access to write the HTML Code
I modified the code to include For Next Loops based on the number of records found and inserted fields instead of the actual image name or text.
I have setup a number of databases where products are delt with eg prices, adding or removing stock etc. The user vthen hits the 'Create Web Pages' button then FTP's the changes to the Web Site
I have asked for notification of a reply so if you need additional help I could e-mail examples of the coding in Access.

 

[Bullschmidt]

I'm making a fairly basic webpage for an agricultural marketing

association, tha will display a list of farms who have a certain
product (corn, etc) when selected from a list on the web page.

So I make a quick database in Access XP, which works fine.
I believed that after setting up a nice report, I could export it as
HTML. Well, it did export, but to several linked pages, instead
of one long one, and the images on the report (That are displayed
conditionally on a Yes\No Field being true) that appear in the report
correctly before exporting, do not appear.

I'd also lke to put a seperator between records, but again, any lines
I put dont appear after exporting.

Can I make this work? I'm I bit lost on this...

For a "quick and dirty" generic ASP open source solution to putting databases
on the Web (often works well for the admin area of a Web site) that just
requires setting up a configuration page for each table or query and uploading
the database to the Web as long as there is an autonumber field in each table
(and you'll probably also separately want to create login capabilities),
perhaps try something like this:
GenericDB by Eli Robillard
http://www.genericdb.com and then click on the Tips link to see an example

Best regards,
J. Paul Schmidt, Freelance Access and ASP Developer
www.Bullschmidt.com/Access - Sample Access Database
www.Bullschmidt.com/login.asp - Web Database Demo