If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Exporting Reports to HTML
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... |
#2
|
|||
|
|||
Exporting Reports to HTML
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 -----Original Message----- 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... . |
#3
|
|||
|
|||
Exporting Reports to HTML
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. "Jeff Gregor" wrote: 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... |
#4
|
|||
|
|||
Exporting Reports to HTML
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 |
Thread Tools | |
Display Modes | |
|
|