Print report from database?

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Frontpage Programming
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - how do I set up password access for certain pages on my website I already have a company website. There are pages that I want just company employees to access. How do I go about setting up passwords to employees. I'm using FP2003 with extensions installed. Tag: Print report from database? Tag: 50844
  - 2
    - Drop down boxes I viewed the answers to other posted questions regarding drop down boxes in FP2003. I followed the link See www.interlacken.com/winnt/tips/tipshow.aspx?tip=28 and the directions but I nothing seems to work. Specifically, when I mouseover the main menu command my first leaf should appear but nothing happens. I am diskbased now and can't post yet (too many errors on site w/r/t main menu bar). I am not using a navigation link bar I developed a hyperlink table instead (as per the instructions) Can you help? YVLT Tag: Print report from database? Tag: 50841
  - 3
    - 2003 Front Page photo errors I am redoing my website in Front Page 2003. I have used the web component feature to redo the photo page. I took the photo's that were already on the webpage, and added them to web components to make a slide show and use the thumbnail capability. Everything looks good in the design page, and when I check it in multiple browsers, but when I look at it on the actual website, the pictures are all missing. Hovering over the boxes gives the caption, but not the picture. What am I doing wrong? My pictures are in a separate folder within the website, and I also tried to copy them to the photogallery folder itself, and neither works. On the design page, about 6 thumbnail photos show up with an arrow on each side for scrolling. On the actual web page, all the thumbnails are in a row and you need to use the bottom slider to get to the end of the long row and then the back arrow. Any way to fix that? I am sure a lot of people aren't aware of the slide bars. PS. I do not know how to use html code at all. Tag: Print report from database? Tag: 50836
  - 4
    - How do you do cell background swap when user has clicked a tab I am working a my coimpany's website. My boss wants users to know they have already clicked on a tab when the background changes, much like what you find on Amazon.com's top frame tabs. Can anyone help? Tag: Print report from database? Tag: 50835
  - 5
    - Files on the Desktop Hi, another question I am afraid. I have created a Dynamic Web Template from an existing page in a website and have set the editable regions. Now, whenever I update the DWT, and update all attached pages, I am left with .htm files and associated folder on my desktop. Why is this, and I how to I set my settings to cure this? This did not happen on two other sites that I have recently done, and I created the DWT in the same way. Kind regards, Peter -- Kind regards, Peter Tag: Print report from database? Tag: 50830
  - 6
    - exchange/outlook programming Where can I get information on how to program frontpage and exchange/outlook? Is there a download or something for me to resource? Thanks Tag: Print report from database? Tag: 50826
  - 7
    - Script - runat=server Hi, I am updating a website for a friend of mine and it has this script toward the top of the index.htm page. (This is not the format it is in, by my copy and past seems to have a mind of it's own). <SCRIPT RUNAT=Server Language=VBScript> SUB Session_OnStart Session.lcid=1033 END SUB </SCRIPT> She says that she did not put the script in, and I certainly did not. My question is, what does this script do? Kind regards, Peter Tag: Print report from database? Tag: 50825
  - 8
    - List Box Data Source Hi Everyone! TGIF!!!!!! I have been trying to find a way to make the contents of a list box on an input form use the values from a db table. I know how to do this for a results page but how do I do it for a form? Tia Jonathan Tag: Print report from database? Tag: 50812
  - 9
    - pictures from db access..help me! currently i'm doing a project for online shopping..i'm already save all the pictures in access as ole object in table =product n the field name is =prodpic. how is it to display the pictures in the form so and when someone upload any pic to the databse it will appear automatically in the form and database.help me! my project get stuck hear....:( -- farrah ------------------------------------------------------------------------ Posted via http://www.forum4designers.com ------------------------------------------------------------------------ View this thread: http://www.forum4designers.com/message197258.html Tag: Print report from database? Tag: 50811
  - 10
    - Photos in IMAGES FOLDER will not come up Photos that are filed in the IMAGES FOLDER do not show up. If they are placed in the main folder of a particular website, they appear okay, but I like to keep all images in their own folder. Why will those IN THE IMAGES FOLDER not show up? Tag: Print report from database? Tag: 50795
  - 11
    - Export to word Hi everyone lain new to asp and am getting really good at writing basic reports what I want to do is be able to let users export these report results into word - I know I'right click allows users to export to Excel but I to export txt not digits is this possible ? Tia Jonathan Tag: Print report from database? Tag: 50789
  - 12
    - Importing Multimedia Files I tried to import multimedia files into FP2000, but get a vague message: "An error occurred accessing your FrontPage web files. Authors - if authoring against a web server, please contact the webmaster for this server's site. WebMasters - please see the server's system log for more details." The microsoft kb has the error message, but their example doesn't cover my situation. There article: http://support.microsoft.com/default.aspx?scid=kb;en-us;838018 Anyway, so I used windows explorer and made a folder in my disk based web, put the multimedia files into it, then recalculated hyperlinks. frontpage then noticed the files, and so I built links to the files. Problem is, now the disk based web won't publish up to the server. I get "the server timed out" after a couple minutes. My server "Accuwebhosting.com" says they can publish a test page just fine, and so, I am left without a way to proceed. I am stuck. Can someone please help? Charles Tag: Print report from database? Tag: 50788
  - 13
    - Looking for ASP-based forums Any suggestions on what works and what is junk? Tag: Print report from database? Tag: 50787
  - 14
    - Photo Gallery Text problem Anybody know why text will not post on a photo gallery in Frontpage 2003? I've tried it on another pc with a different revision of FP 2003 (I have Frontpage 2003 (11.6356.6360) SP1.) and it works fine. I'm running Windows XP 2002. Tag: Print report from database? Tag: 50785
  - 15
    - how do i creat email page in frontpage 2000 hello respected i want to creat a web page of my site frome where people can send me email without using outlook or any other mailing softwear OR in other word is there any template of email page of frontpage 2000 if u know about it plz send me some information THANKS Tag: Print report from database? Tag: 50782
  - 16
    - SORT BY: I WANT TO PUT IN MY WEBSITE A SORT BY DROP LIST AND I DONT KNOW TO DO IT I NEED HELP AND ALSO HOW TO PUT IN A NICE SEARCH BOX SO ANYONE COULD SEARCH MY ITEMS Tag: Print report from database? Tag: 50781
  - 17
    - Truncating dates on active server pages I use active server pages in Front Page, in conjunction with Access. I am using a custom format for dates, "mmm dd", which is supposed to display March 1, 2005 as Mar 01. This works fine "off-line" in Access on reports. But on my website, which reads the dates from a database, the format is 03/01/2005. I like the mmm dd format much better--easier to read, less space used, and while I want the year in the database I don't need it displayed on the web page. Is there some script I could use to give me the desired format? Thanks, Dave Tag: Print report from database? Tag: 50776
  - 18
    - Want to have picture open on a seperate page? I have a webpage that contains a number of pictures. The pictures on this page are thumbnails. Currently when a visitor clicks on the thumbnail it opens up a new page replacing the gallery page and the user must hit the back button to return to the thumbnails. What I would like is for the selected thumbnail to open up a new page with the full size picture and have the gallery page still open. Thank you Rick Desjardins Tag: Print report from database? Tag: 50772
  - 19
    - database location in asp.net I setup a db web in frontpage 2003. It located the db in the FPDB folder. I need to tell the code to look at a different directory because the database has to move to the hosting supplied db folder with apprapro access. Can someone tell me how to direct my asp.net pages to look elswhere for the db?? Thanks!! Tag: Print report from database? Tag: 50765
  - 20
    - Robots: "index,follow"? I made my website with FrontPage 2003 - http://www.hairloss-reversible.com. My question, though, has to do with the Discus discussion forum I have on my site. Located under Description and Keywords for the ten topics on my discussion forum is the META tag box with four options. I'd like to know which one is best and for what reason. There is a radio button before each option: 1. No Setting 2. Do not index page ("NOINDEX,NOFOLLOW') 3. Index page and follow links ('INDEX,FOLLOW') 4. Custom: the field here is empty Of course I know not to use NOINDEX,NO FOLLOW, but how about the other choices? Tag: Print report from database? Tag: 50762
  - 21
    - downloading picture files How do I set up a page to allow visitors to download picture files. Tag: Print report from database? Tag: 50744
  - 22
    - Pictures I am trying to build a web page for Ebay. I need to know how to make a larger picture from a small picture preferrably in the same brouser. Currently I use a new brouser to open a larger version. Tag: Print report from database? Tag: 50743
  - 23
    - Gif's not showing up on the web What has suddenly gone wrong that my Gif's and Flash objects no longer show up on the web? Any help will he appreciated. XP Home and FP 2002 Tag: Print report from database? Tag: 50740
  - 24
    - Language Arabic Office 2003 Tag: Print report from database? Tag: 50736
  - 25
    - Do I want FrontPage 2003? I have FrontPage 2002 on a computer that I can use. I want to buy FrontPage 2003 for my own computer. 1. Or do I? 2. Will I find improvements that justify the expense? I'm not a power user, but am trying to get there. 3. Does it produce faster-to-load, smaller code? 4. I have my own legal copy of FrontPage 2000. I found the box, but the CD is missing - maybe in one of 75 or so moving boxes in storage. The old computer I had it on is not worth using now. I did register it, and the box shows a serial number. Will I be able to install the upgrade version on my newer computer? 6. How do I ask Microsoft before I purchase the upgrade? Answers to #1 and #6 would be the most helpful. TIA, Paul Tag: Print report from database? Tag: 50732
- Next
  - 1
    - If Then Else Hi, On a link that I send users via email I have a code number on the end that populates a field on the page and that number is fed into a database when the user clicks the submit button. Properties of this button is "Push Button" & "Submit" type. http://www.xxxx.com/survey/users_interface/Results/submission_form.asp?snumber=134 What I want to do is to code the submission_form.asp so that if snumber is greater than 400 then when the submit button is clicked, I want it to open http://www.xxxx.com/survey/executive_interface/Results/survey.asp otherwise I want it to automatically open http://www.xxxx.com/survey/departmental_interface/Results/survey.asp I really need help and I need to know exactly where to put the code. Tag: Print report from database? Tag: 50729
  - 2
    - Button to create Outlook appointment Can anyone get me started on how to create a button in FrontPage, that when clicked, will create an Outlook appointment item for the user? For example: User clicks button, up pops an appointment item with the relevant information filled in (time, reminder, location...), they hit save and close. Viola the appointment is in their calendar. Using FrontPage 2003, and Outlook 2000, with Exchange 5.5. I am a FrontPage beginner as far as vbscript programming... Thanks, Jim Tag: Print report from database? Tag: 50720
  - 3
    - Change default return string I have a search form that uses Access database as the back end and some of the form fields are Yes/No check boxes. The default results for these fields ar "True" and "False" and I would like to change these to read "Yes" and "No". Is this possible, and how is it done? Your input would be appreciated. Tag: Print report from database? Tag: 50717
  - 4
    - Editable Pages I have been designing html sites for a few years now but I have a real estate cleint who wants to add her own listings so that they appear in a category ie residential. Do I use a database driven website to do this - using an asp page template? Any tutorials that you can recommend I take so that I know how to configure it. Also have a rental that wants to add an availability calendar. Same thing I want her to be able to mark off days on a calendar - Any suggestions... Tag: Print report from database? Tag: 50715
  - 5
    - Drop down List for hyperlinks New to Front Page 2003 and can't find a refference to this common function. HELP!! (Drop Down list displays list of committee names which are hyperlinked to committee annual reports.) Tag: Print report from database? Tag: 50711
  - 6
    - Have Form REsults Rerwite or Replace File, not Append I would like to have the form results comeback in a new file or replace the previous entries, not append to it as in the default behavior. Basically, a user will fill out the form with information, and the result/confirmation page will show. But when the user comes back to make changes again, the new information will replace the old one, not append to it. Can this be done, such as using a new file variable? Thank you Tag: Print report from database? Tag: 50710
  - 7
    - Unable to create a disked based web because its parent web would not be a disked based web I am running an IIS server and I'm trying to create a new web in the staging part of that server in Frontpage 2003. I create a new folder in staging/opened staging in Frontpage/right click to convert to web and get the error messsage, "Unable to create a disk-based web". I created the web as a virtual web on the IIS server but still get the message. Can anyone help? thanks Erin Tag: Print report from database? Tag: 50690
  - 8
    - ASP Code I would like to know how to insert ASP code in FrontPage 2003. Tag: Print report from database? Tag: 50689
  - 9
    - Query I have used the query designed for the Select All values by using the wildcard "*" and using the word "contain". The problem that I am having now is that if I select Virginia, records with West Virginia are showing up. If I use the criteria using the word "equal" then the select all query results are not being displayed. Does anyone have any clues? Tag: Print report from database? Tag: 50688
  - 10
    - SDK example InitCaps confusion Hi -- trying to program my first FP2003 web component and I'm very confused. I'm not using FPSE or anything fancy, just FTP. Referring to the FP2002 SDK I looked at the Initcaps example. I put that into the _vti_bin directory of my web, recalculated hyperlinks, and inserted the webcomponent as described in the manual. I chopped out the preview paramter from the webbot tag so I can monitor what I'm looking at. In frontpage, it always shows [SmallCaps]. When I upload over FTP it says [Frontpage SmallCaps Component]. I even tried some programs of my own, followed the examples, and the ret.Append("Some sample text") doesn't show up like in the SDK examples.. I dont understand what I'm missing here. The built-in components like Navigation render properly in frontpage, and when they're uploaded via FTP they're static. What is the difference, are the built-in functions setting the preview property maybe? Thanks for the help. -joey Tag: Print report from database? Tag: 50687
  - 11
    - Deployed Support Hey Im a marine with MSSG31. We push out updates for our website but the thing is, when you open the updated website, it will bring up cached files. And you have to clear your temporary files then refresh in order for the webpage to load. Now I know that you have to clear your temporary internet files and hit refresh, but the common marine mom does not. So she just look at the page and thinks its not updated. I was curious if there is some kind of code you add to the script or some way to stop the website from displaying the the old files. Any help would be greatly appreciated. Respectfully Lcpl Martin E Geretz Tag: Print report from database? Tag: 50677
  - 12
    - Problems with Response.Redirect() and Frames Hi everybody... I've a small problem I copied a script to manage a Forum and I've adapted to my needs But I've a problem I cannot solve While logging out, the script calls page logout.asp In the bottom of the script there is this code: <%.... ......Response.Redirect("page1.htm") %> Well, everything works, but, since I use a Framed pages the behaviour is not what I was looking for, in the sense that, this page1.htm is not loaded in the main frame of the existing window (that's what I want), but in a new window. I'd like to add something like "Target", but I have no knowledge of such programming language and I do not know how to do Can you help me? Thank a lot Sergio Tag: Print report from database? Tag: 50676
  - 13
    - should the code for my forms have webbot-self My forms dont work on my server. the tech support thinks the problem is the WEBBOT-SELF could this be the reason they dont work if so what should it be? Tag: Print report from database? Tag: 50671
  - 14
    - How do i fix it so my website does not require a password/usename. How do i fix it so my website does not require a password/usename... you go to upload something to the site and it ask for a password/username. Tag: Print report from database? Tag: 50670
  - 15
    - Photo Gallery Text I have Frontpage 2003 (11.6356.6360) SP1. When I setup a photo gallery the text function does not work. I've used the correct layouts, but it still doesn't work. My business partner has FP 2003 (11.5...) no SP1 and his works fine. I have MANY photos to catalog for a client and photo gallery would be the best. Is there a patch to download? I've already ran a MS check for updates and I have the latest as far as I can tell -- Is there a patch to download? What can I do? Tag: Print report from database? Tag: 50667
  - 16
    - Pop up I want to have a menu pop up when someone mouses over it. Can anyone help me? Tag: Print report from database? Tag: 50664
  - 17
    - Adding text from a file to an html page I want my html page to insert text from another file. Can I do this with html or Java script. What are suggested ways without going to dynamic pages like .asp or .php Thanks Tag: Print report from database? Tag: 50650
  - 18
    - Need to check frontpage server extension file in windows xp machin Hi, I need to find the version of this file in windows xp machine. I am wondering, what is the name of the frontpage file name that I need to searc for with an exe extension. I appreciate any help in advance. Thanks. Tag: Print report from database? Tag: 50645
  - 19
    - Any advantage of doctype? I created my website, www.hairloss-reversible.com, with FrontPage 2003. I notice that many websites have a doctype when I click on View Source. Many have this specific one: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> Is there any advantage in putting a doctype at the top of my site in code view? If there is an advantage, how do I decide on which of the three or more doctypes to choose from? Tag: Print report from database? Tag: 50643
  - 20
    - how do I wrap a paragraph around a picture I'm trying to offset the words in a paragraph such that they wrap around a picture. Currently the words are either above or below the picture. I cannot get the paragraph to continue along side the picture. Tag: Print report from database? Tag: 50640
  - 21
    - Tabs in FrontPage I have two forms and all the tabs work great except for the first one in each. Should the first tab index number be zero or one? Tag: Print report from database? Tag: 50639
  - 22
    - Blocking entry to someone's website I know this is probably way too much out of the realms of programming, but I thought I'd give it a try. I am selling stain for my manufacturer at my website. Is there any way that I can prevent people who visit my website to go to the manufacture's website to try to get a better deal. Can I program something at my website to put a block on their browser from reaching www.xyzcompany.com after they have visited my website? JimStipe@Hotmail.com Tag: Print report from database? Tag: 50630
  - 23
    - Help with sorting Access table using ASP Hi all I have been trying to sort an Access table "calendar" by the field "Date" into ascending order. I've tried a straight SQL query, but I don't believe my server supports SQL although they do support ASP. I've tried using a stored query in Access "Gigdatesort" with no luck. Is anyone out there who is able to help? It would be appreciated. TIA. Tag: Print report from database? Tag: 50629
  - 24
    - New Windows Setup - Which comes first, development or application environment? Hi: I am going to replace the current primary drive with a new HDD and to perform a clean installation of Windows XP Pro because the current environment is getting slower and some components are messed up with different installation, removal, and updates of applications, Windows service packs, patches, and development packages. And based on the past experiences, I figured some problems seems to be related to the sequence of program installation, such as certain components have been changed or updated by a application or SDK installed later on but have not been updated for all other applications using it which eventually lead to certain problems. So my question is, after the initial installation of Windows XP and performed all updates for device drivers and Windows Update, shall I set up the development environment first or installing applications along with the environment? By saying development environment, it was referred to things such as FrontPage Extension, SharePoint Team Service, SDK, Starter Kits, database, database components, and/or any other components that will be required to develop web applications. By saying applications, it was referred to applications such as FrontPage, Dreamweaver, Office, and so on. I understand that some development components also come with applications and it might be updated when the application is being installed and updated. But my goal is to minimize the chance of system components being messed up as much as possible. Thanks for any advice. Tag: Print report from database? Tag: 50608
  - 25
    - US state listings in drop down list box I am trying to add a simple drop down list box to my site that lists all the US states.I can't find any code anywhere and I know it must exist in some form somewhere. Help!!!! Tag: Print report from database? Tag: 50601

On an intranet site, I have an Access database with some web pages to
display, add, modify, or delete a record using a Frontpage database
connection.

The database contains a report. Is there a way to print the report from a
web page? What I'm looking for is a button on a web page that's the
equivalent of opening the database in Access, selecting the report, and
clicking Print on the File menu.

Re: Print report from database? by Stefan

Stefan
Sat Mar 12 03:50:36 CST 2005

No
You need to generate the report in ASP (or attempt to use the DBR wizard)

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp
_____________________________________________

"Joe Blizzard" <replies@newsgroup.only.please> wrote in message news:OgmRH6rJFHA.1176@TK2MSFTNGP12.phx.gbl...
| On an intranet site, I have an Access database with some web pages to
| display, add, modify, or delete a record using a Frontpage database
| connection.
|
| The database contains a report. Is there a way to print the report from a
| web page? What I'm looking for is a button on a web page that's the
| equivalent of opening the database in Access, selecting the report, and
| clicking Print on the File menu.
|
|

Re: Print report from database? by Joe

Joe
Sat Mar 12 08:29:30 CST 2005

"Stefan B Rusynko" wrote
> No

Damn.