ASP/VBScript/Access SQL

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
 - creating reciprocal links how can I create riciprocal links to other web sites ?? -- gerie Tag: ASP/VBScript/Access SQL Tag: 49308
 - 2
 - :: IN FRONTPAGE DATABASE Why in a frontpage database accessing ms access do you see double colons ::? ie,. where custname = '::whatever::' Tag: ASP/VBScript/Access SQL Tag: 49302
 - 3
 - :: IN FRONTPAGE DATABASE Why in a frontpage database accessing ms access do you see double colons ::? ie,. where custname = '::whatever::' Tag: ASP/VBScript/Access SQL Tag: 49301
 - 4
 - results view I have created a conformation page that displays the database results so that we can automaticly database and assing numbers to a request. It works fine and I figured out how to have FP display the last record. Now I want to Exclued, or hide the next and last buttons on this page. How do I do That? Tag: ASP/VBScript/Access SQL Tag: 49300
 - 5
 - passing data to another webpage I want to create a hyperlink to another web page that requires a userid and password. The userid and password are always the same for those that hyperlink from my webpage. Can I pass this data along without the user having to write down the information and log onto the other web page? I can't change the other web page only mine that hyperlinks. Thanks Tag: ASP/VBScript/Access SQL Tag: 49299
 - 6
 - How do I disable the Image Toolbar with HTML code (Front Page) so. I want to use HTML code that disables the Image Tool Bar on a web page so that the user cannot copy or print images from a page. Tag: ASP/VBScript/Access SQL Tag: 49289
 - 7
 - Cell/Table Auto Resizing FP2003 When I create a table the cells auto resized based on the size word that I type in the box. How can I disable this feature so that the cells are static regardless of the size of the word I type in? Thanks in advance Ed Tag: ASP/VBScript/Access SQL Tag: 49288
 - 8
 - Need to add rss news feeds in front page websites... I use frontpage 2000 Need to add rss news feeds in front page websites... I use FrontPage 2000 so any discussion please include this as the lowest common denominator.. What experiences have people had.... What addins or scripts are best which methods make them show up best to search engines? -- Thanks Ed Sharpe archivist for SMECC Please check our web site at http://www.smecc.org to see other engineering fields, communications and computation stuff we buy, and by all means when in Arizona drop in and see us. address: coury house / smecc 5802 w palmaire ave glendale az 85301 Tag: ASP/VBScript/Access SQL Tag: 49283
 - 9
 - Help! Ignorant user This is a multi-part message in MIME format. ------=_NextPart_000_0009_01C50623.D0BC23A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Being new to FrontPage but trying to learn. I created a website and = uploaded it. Access is fine. Beneath it I have two subwebs. When I type = http://www.company.com/Othercompany it opens the site if I type = http://www.company.com/othercompany it will not... note the only = difference is the caps on the Othercompany part of the url. In front page the subweb is named as Othercompany note caps. What have I done wrong and/or what can be done corrected to allow me to = type any case to attain access to these subsites as noted. TIA Dirk-Thomas ------=_NextPart_000_0009_01C50623.D0BC23A0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2900.2523" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV> Being new to FrontPage but trying to = learn. I created=20 a website and uploaded it. Access is fine. Beneath it I have two = subwebs. When I=20 type <A=20 href=3D"http://www.company.com/Othercompany">http://www.company.com/Other= company</A> it=20 opens the site if I type <A=20 href=3D"http://www.company.com/othercompany">http://www.company.com/other= company</A>=20 it will not... note the only difference is the caps on the Othercompany = part of=20 the url. In front page the  subweb is named = as=20 Othercompany note caps. What have I done wrong and/or what can be = done=20 corrected to allow me to type any case to attain access to these = subsites as=20 noted. TIA Dirk-Thomas</DIV></BODY></HTML> ------=_NextPart_000_0009_01C50623.D0BC23A0-- Tag: ASP/VBScript/Access SQL Tag: 49274
 - 10
 - Password Protect a Web Page I have followed the instructions contained in ID: 825498 but when I go to "test the logon web site" everything works except when I click on the non-protected link I get the code text instead of the logon on box. When I double click the logon file it comes up correct but not when I click on the link on the home page. Help please Tag: ASP/VBScript/Access SQL Tag: 49271
 - 11
 - Discussion web text area How can you create and maintain paragraphs in the Discussion Web Comments text area after it has been submitted? Tag: ASP/VBScript/Access SQL Tag: 49270
 - 12
 - Form Results Page Question How can I have form results populate a table on the form results page? Thanks, Keith Tag: ASP/VBScript/Access SQL Tag: 49269
 - 13
 - How do I insert a ScreenTip for a word without hyperlinking that w I want to have a ScreenTip definition pop up for visitors to my site who run their mouse pointers over a technical word. I do not want this word to be hyperlinked. The word will just be in a different color, not underlined. For example, the ScreenTip for alopecia would be "hair loss." The ScreenTips on this site are an example of what I want - http://www.dermatology.co.uk/phototherapy/uvbtreatment/article/article.asp?ArticleID=1398 Is there a way in the Design mode for doing this, or will I have to work with HTML code? I'm not proficient in coding. Tag: ASP/VBScript/Access SQL Tag: 49267
 - 14
 - Accessing FrontPage Someone said I had to click on the 'Edit Via FrontPage' option to access and edit a web page. Where exactly is this? I can't seem to get into FrontPage at all. On my Programs list is an entry for Internet Explorer which has a subentry for FrontPage Express. When I click on it I can choose 'File' 'Open' and enter the web address, but it locks up my machine. This is frustrating. Tag: ASP/VBScript/Access SQL Tag: 49266
 - 15
 - electronic newsletter I've seen newsletters that have the option to right click and download the graphics or they already have them "embedded" in the html code. I would like our graphics to be inserted without the need to download. Is there any easy way to do this without using attachments? Tag: ASP/VBScript/Access SQL Tag: 49265
 - 16
 - display database results as gallery Is it possible to display frontpage database results in gallery format and with direct page numbering and linking - and with possibly the a link that will display all results on one page in a gallery format, maybe 3 or 4 columns wide? All I seem to have available currently are arrows that allow me to scoll through database results only one page at a time and with only one column of results. Is this the only options available for database results display using Frontpage 2003? If so, are there any add-ons or even an external application that I might use to accomplish this? Tag: ASP/VBScript/Access SQL Tag: 49262
 - 17
 - upload file frontpage 2003. when I use a "upload file" field in a form, I get this mesage when I trie to send the form:( Cannot run the FrontPage Server Extensions' Smart HTML interpreter on this non-HTML page: "http://www.nettannonsen.no/annonse_brukerregistrering.htm")what am I doing wrong ? Tag: ASP/VBScript/Access SQL Tag: 49259
 - 18
 - Question .. I'm sure it's simple for someone I want to build a web site with Front Page for my catering business. On this site I want to be able to give prospective clients an opportunity to fill out a request form with several options on menu items. I can make the page OK, but I'm not sure how to program the request page to deliver the results of the request page , or where to have them arrive. Any help would be appreciated. Thanx Tag: ASP/VBScript/Access SQL Tag: 49254
 - 19
 - user text entered is not sent via email in a form I am running Frontpage 2003 and I am getting the email sent to me but the only data in it is part of the email message. There is not user entered data in the email. I am using this method: Set Mailer = Server.CreateObject("SMTPsvg.Mailer") to create the email message. Is this correct? Tag: ASP/VBScript/Access SQL Tag: 49248
 - 20
 - display db results in multiple columns Is there a way to display the results of one field (from db) in two or three columns? Tag: ASP/VBScript/Access SQL Tag: 49236
 - 21
 - Refresh page on browser resize Anyone have the code to refresh a page from cache after the user resizes the browser window? Thanks Tag: ASP/VBScript/Access SQL Tag: 49229
 - 22
 - table - cell and row spacing I see in many web pages that the header and left side are flushed and run seemly into each other with a background color. I have created a table and always get spaces between the cells even if I select 0 for the spacing and padding. Is there any way I can force the cells to not create spaces in the browsers. When I edit the table, everything looks ok. Donna Tag: ASP/VBScript/Access SQL Tag: 49225
 - 23
 - Changing BG via buttons I added some buttons to the top of an Include page (so the buttons will appear at the top of all pages) to let the reader change the current image background, but the buttons won't work. The background is displayed through an external style sheet: http://www.rc10.com/misc/css/test.htm The buttons work if there is no external stylesheet: http://www.rc10.com/misc/css/background.htm Does the stylesheet prevent the background from changing, or does the problem lie elsewhere? Regards, Steve H Tag: ASP/VBScript/Access SQL Tag: 49224
 - 24
 - Downloads from FP2000 page Hello, When visiting the form http://www.freisco.com/steals.htm, and double click on the "Jan 27, 2005" link; I get a different response depending on the browser in use. Using IE, the *.rtf file spawns itself onscreen. Using NetScape, I get the option box of "open using Word" or "save to disk" options. Is there a way I can control this mechanism? Ideally I'd like the user to get just the NetScape solution and not get the report spawned on their desktop. FWIW - I generate the report using Access 2000, then upload the *.rtf file to my site, then go to FP2K and establish the link to deliver the report upon request. Any and all insights welcomed. -Steve Tag: ASP/VBScript/Access SQL Tag: 49196
 - 25
 - FrontPage 2003 Theme Image Updating Hi, I am having a problem in FrontPage 2003, in which I have changed some graphics in a theme, and it update one graphic, but when I changed two additional graphics, they did not update. 1) from the menu, Format, Theme 2) right click In-Motion 3) Customize 4) Vertical Navigation 5) Changed selected picture graphic, and it changed fine. 6) Repeat steps 1-5, and change "selected graphic" and "hovered graphic". Neither of these would update. Also if I look in the "derived" directory for the website, the names of the graphics did not change. Does anyone know a workaround for this (appears to be a bug in FrontPage)? Is there some way to "force" FrontPage to update or refresh the website's derived files directory, because this directory seems to hold the graphics for the web pages? Thank you. Tag: ASP/VBScript/Access SQL Tag: 49189
- Next
 - 1
 - web form I would like to add a web form to my website, but I don't care for the validation "messages" that FrontPage sends when a required field(s) are not entered. For instance, if COMMENTS field is required and it is not entered, the message sent back on submit is.... Please enter value for the "Comment" field. I would prefer that it would say something like "Please enter Comment Information", or something else more professional sounding than the "generic" message that FrontPage sends; preferably a message that I can control. Is there any way to change the validation "messages" in FrontPage or is there some software or add-on available for creating professional forms. I tried searching Yahoo & Google and didn't find anything helpful. I did find some products that sounded promising, but the information in the my web forms would be sent to "their" servers and I don't want that. Appreciate any information you can give me. Tag: ASP/VBScript/Access SQL Tag: 49184
 - 2
 - W3Cs validator finding fault with nonexistent code When I use W3C's validator, I get warning messages that don't apply to the page. For instance, "bordercolor" does not occur on the page, but it brings up the issue anyway: # Line 173, column 132: there is no attribute "BORDERCOLORLIGHT" This was taken from my page: http://www.rc10.com/basicshub/aboutae/about_ae.htm Also, sometimes it refers to something on line 214, but there are fewer than 200 lines on the page, according to the numbering in FP2003. Should I just ignore things like this? Thanks, Steve H Tag: ASP/VBScript/Access SQL Tag: 49183
 - 3
 - CSS, Javascript, and Netscape I have a horizontal navigation menubar with five links. It is built with CSS inline style. Below it is a horizontal submenu bar. Each submenu bar initially is visibility: hidden, and when the user moves the mouse over the main level menu item, I wrote javascript telling the browser to display the appropriate submenu. The menu works great in IE but the submenus never become visible in Netscape. I like this menu style because it is similar to the two-tiered flash menus, but it doesn't use flash, allowing for much quicker page loading. Any suggestions? The site is at www.cbcwichita.org/testpage.shtml. Here's a sample of the code for one menu item: function showabout() { librarynav.style.visibility='hidden'; aboutusnav.style.visibility='visible'; radionav.style.visibility='hidden'; contactnav.style.visibility='hidden'; } Thanks, Robb Tag: ASP/VBScript/Access SQL Tag: 49177
 - 4
 - About wbsite designing Tag: ASP/VBScript/Access SQL Tag: 49168
 - 5
 - Website Display Question I designed my website on a laptop computer with a 1280x800 screen. The site looks good when I view it on the laptop. When I access the site on a desktop with a normal 17 inch display, it looks very large and unorganized. How can I make the site look good no matter what screen it's viewed on. Thanks! www.blueknightsca18.com Tag: ASP/VBScript/Access SQL Tag: 49156
 - 6
 - How do I get my website to look the same on a 17 inch monitor as . When I view my website on my laptop it looks good. When I view it on a desktop computer (with a 17 inch monitor) everything appears larger and it doesn't look as good. How do I get it to look the same no matter if it's being viewed on a laptop or a desktop monitor? Thanks! the site is located at www.blueknightsca18.com Tag: ASP/VBScript/Access SQL Tag: 49155
 - 7
 - send 2 emails from form Can anyone point to a tutorial to help me send 2 emails from form. I dont understand dbases very well so at present the email goes to my mobile phone account and forwards a text of message saying email is waiting at inbox but isnt 100% reliable. Its a simple booking form with dates and contact details Any ideas, thanks in advance. How do others get notification while on the move. Tag: ASP/VBScript/Access SQL Tag: 49153
 - 8
 - File Upload Component Hey All, Hope you can help with this. I am thinking it might be a user error on part of my client but correct me if I am wrong. I have created a page with about 15 upload forms to allow client to upload images to separate folders for a photo gallery. It always works fine for me. Never have a problem from 2 different computers. My client experiences the following problems. Unsure if there might be some utility on her machine that cause her to be unable to upload. Quote from my client. "I really think there is something wrong with photo album admin. I have tried for 3 days from home and I brought a cd to work to try from here. It doesn't work here either. This time when I clicked submit I got a blank screen, never the user id/pw screen. I tried again and got you are not authorized." Any insight? Thanks. Tag: ASP/VBScript/Access SQL Tag: 49151
 - 9
 - How can I centre a page, so that if opens in a browers, it is alw. Hai everyone, I would like to ask if it is possible, to center a page ( even with frames ) in the website. That when it's opened in a browser, you will get your site centert in de screen. I hope someone can help me. Thanx in advance Hermen Tag: ASP/VBScript/Access SQL Tag: 49145
 - 10
 - hyperlink text disappears when editing Hello. Two of us have recently taken over responsibility for our company website. The existing site was built using AdobeGoLive. We are going to support it using Front Page 2003. We've made several successful changes the past two months. Just to clarify we are not both on the site at the same time making chances. The other user has the main responsibility. I back her up and troubleshoot for her when necessary, but am far from an expert in Front Page 2003. Recently when we try to change an existing hyperlink to redirect it to a new target, the text disappears. For example: Click here for our VACATION specials site. VACATION was a hyperlink to www.oldwebsite.com/ourcompany. We wanted to redirect the hyperlink to a new site www.newwebsite.com/ourcompany. Regardless of whether you right click on the VACATION and then edit the hyperlink or whether you go into the Code Screen and change the target in html, the result is the same. You now see on the Design screen: Click here for our specials site. The word VACATION that was the hyperlink has now disappeared. We both have licenses for FrontPage 2003 and it happens to both of us. I have searched both Office Online and the Microsoft KB without success. Help would really be appreciated. Our owner is breathing down our necks. Thank you, Network Admin Terri Terri Tag: ASP/VBScript/Access SQL Tag: 49143
 - 11
 - Migrating from Dreamweaver MX 2004 Hello everyone, I'm migrating to FP from DW at a new job. I can't seem to figure out how to get Intellisense in FP to give me list properties for ASP objects, such as response. or request. In DW and in VS.NET, when I type "response." I am given a list of properties from which to choose to help me code faster. I have my Page Options > Intellisense, and told it to complete HTML and Script tags. It is working for HTML, but not for VB Script. Can someone please help me? TIA for your advice! Tag: ASP/VBScript/Access SQL Tag: 49138
 - 12
 - Saftey Settings on the machine prohibit access a datasource on another Domain I have insrted a web componant (spreedsheet) and went to commands and options datasource( SQL Database) and pointed it to a odc connections that I have set up and this error message pops up Tag: ASP/VBScript/Access SQL Tag: 49134
 - 13
 - Database Upgrading I currently use MySQL through my web hosting service to display my Frontpage 2003 data. I am considering switching to a host that utilizes Microsoft SQL Server. Does the Microsoft SQL work better with the Frontpage database wizard, or am i better off to stay with MYsql which seems to work fine with Frontpage? Any help would be appreciated. Tag: ASP/VBScript/Access SQL Tag: 49128
 - 14
 - Centering layer Is it posible to have a layer center across the page. Currently, the main layer always aligns to the left side of the browser window. I would like the layer to be centered in the browser window. Is this possible? If so, How do I do It. Tag: ASP/VBScript/Access SQL Tag: 49125
 - 15
 - Getting a a Binary Error I front Page capaiable of reading a jpg file. I have a created a asp page in front page that will pull data from a external SQL database Picture Name Description and Picture(its the actual jpg file stored in SQL) The ASP page runs fine I get Name Description but under Picture I get #Binary# no Image display I need the actual image to be inserted Thanks Tag: ASP/VBScript/Access SQL Tag: 49123
 - 16
 - Adding a Password Is it possiable to embeded a password into a asp or html document? Example User clicks a link to a secure page that is only accessed by that department. they are promped for a user name and password they use a generic one same for the whole deparment one size fits all Tag: ASP/VBScript/Access SQL Tag: 49119
 - 17
 - Looping in a Form I have Office XP with Front Page 2002. I have a form with 18 questions. Question 18 is a radio button response. I need to know where/what to code in the page that if the YES option is selected, the user is returned to questions 12-18 for each occurrence of a YES in question 18 (up to 10 loops). I also want to store the results of each occurrence/respones to questions 12-18 in its own cell in an Excel spreadsheet. I have the form page built for the first occurrence, but not the looping. I am totally stuck. I don't find IF THEN ELSE, DO WHILE, etc. options in FrontPage help files, are they there? Tag: ASP/VBScript/Access SQL Tag: 49116
 - 18
 - text is moving with screen ! i am trying to create my own web site and have only just started and have a problem already. i have placed a background image on the site which has coloured boxes on it, then i created a cell ontop of one of these colour boxes and added some text (so it looks like its in the box), when im in the working screen or preview screen it looks good but when i go to preview in internet explorer6 window the text all moves with the size of the explorer window thus moving the text away from the coloured box when i increase or decrease the explorer window size , how do i lock it in place so if you shrink your explorer window the text stays there and you need to scroll across to see it all, rather that it shrinking on its own trying to fit in the explorer window. Tag: ASP/VBScript/Access SQL Tag: 49115
 - 19
 - Copywrite symbol I have tried to upload the copywrite symbol and for some reason, it publishes as a question mark??? Tag: ASP/VBScript/Access SQL Tag: 49111
 - 20
 - How do I copy an existing frontpage web I created? I presently have a working website using frontpage 2003 and I want to duplicate it and rename it so that I can revise the copy and upload to my 2nd website. Any help would be appreciated. -- Kind regards, Steve Tag: ASP/VBScript/Access SQL Tag: 49102
 - 21
 - Font support is weak in Frontpage Note to Front Page development team\ Please review the font system; not all fonts are supported; i.e. TT versus T1 Tag: ASP/VBScript/Access SQL Tag: 49096
 - 22
 - HTML Validation I checked a free validator and found my conversion to CSS was pretty sloppy--59 errors on the first page checked alone! Yet my pages are showing up just fine in various web browsers. Is it worth changing over 1000 pages to get the code exactly right? Thanks, Steve H Tag: ASP/VBScript/Access SQL Tag: 49090
 - 23
 - Permission denied when publishing If I have "Changed pages only" option selected in the publishing options I get a 550 'xxxxxx': permission denied error when I try to publish my web site. This did not occurr until my dsl service changed the isp from gnat.net to pstel.net I suspect something on the Host ftp server causing this but they must sub their hosting out because their tech support is clueless. Anyone have suggestions? Dean Tag: ASP/VBScript/Access SQL Tag: 49088
 - 24
 - target tag within iframe element FrontPage 2003 insists on inserting the "target=_self" attribute within my iframe elements. (Not the links pointing to the iframe, the iframe itself.) Even when I remove that attribute from the code for the iframe, FrontPage puts it right back in when I save the page. HTML validators, including FrontPage's, flag the "target" attribute as invalid for the iframe element. How do I get FrontPage to stop fighting me on this and stop reinserting this invalid attribute? Am I missing something? Thanks! Tag: ASP/VBScript/Access SQL Tag: 49087
 - 25
 - Fill In Dates Hopefully someone out there has tried this. I'm trying to write an application that incorporates a timecard for contractor time entry. I have a date picker so that the contractor can pick the Monday start date on which the weeks time is for. What I want to do is take this value and fill seven corresponding text boxes (Sunday through Saturday) with dates driven off the text box the date picker fills in. Something wherein Sunday=startdate-1, Tuesday=startdate+1, Wednesday=startdate+2, etc. Yes, its being written in FP2003 interfacing with a SQL database. If anyone can give me a heads up on the javascript that would do this, I'd appreciate it. (I've searched in here and Googled to no avail) Thanks in advance -- John Cello John Cello Consulting Communications For Business www.johncelloconsulting.com Tag: ASP/VBScript/Access SQL Tag: 49085

Can anyone point me to a tutorial that will explain how to integrate a
SQL CURSOR into an ASP/VbScript/MS-ACCESS driven web page? I can use
CURSORS with other types of DB (DB2 for instance), but am not sure how
to get going using ACCESS.

Thanks

JW

Top

Re: ASP/VBScript/Access SQL by John

John
Sun Jan 30 18:45:41 CST 2005

John Whitworth wrote:
> Can anyone point me to a tutorial that will explain how to integrate a
> SQL CURSOR into an ASP/VbScript/MS-ACCESS driven web page? I can use
> CURSORS with other types of DB (DB2 for instance), but am not sure how
> to get going using ACCESS.
>
> Thanks
>
> JW

Have now solved my problem.

Thanks

JW

Top