how to connect an html page with an access database to search it?

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
    - Problem with preloading page in hidden div Hi all, hope someone is able to help!... We have created this page: http://www.superhighstreet.com/George-Street-Richmond/splash The purpose of it is: * To catch visitors' e-mail addresses * To 'secretly' preload the large page that follows when you click the big button 1) Is there any way to stop the mouse cursor in IE and other browsers having a geriatric fit during the loading of the big page in the hidden div/iframe? This makes it unsightly and difficult for users to click inside the form field. 2) Although we have added <script>document.join.q.focus();</script> under the form, and added name=join to the form tag, the cursor still does not jump into the form field automatically. Yet this works fine at our other page www.superhighstreet.com/home where it is used. Thanks in advance for any tips. If you don't have an answer please don't feel a need to reply ;) -- Thanks, Me Tag: how to connect an html page with an access database to search it? Tag: 64112
  - 2
    - Can't modify Database wizard form to add new items to database. 1) Made a database and entry form using the FP03 wizard. 2) Trying to add a few new items to be entered into the form; have modified the database, expanded the array the form uses, but it doesn't pick up the new items. 3) Does this have anything to do with the "i-checksum" I can't find documentation on? Seems pretty simple to modify a form just to get a few more entries - don't tell me I'll have to hand-code/re-do 100+ form entries on the Wizard just to add a few new ones!?! Tag: how to connect an html page with an access database to search it? Tag: 64111
  - 3
    - Another Print Question Still trying to make some printer friendly pages. Using FrontPage 2003. Is it possible to put a page break code into a web page to tell the printer when to start a new page? Thank you again Tag: how to connect an html page with an access database to search it? Tag: 64096
  - 4
    - Using "Alt" tag for images I need some recommendations on using "Alt" tags 1. They are not "required" correct" 2. Best practice is to use them though? 3. If you don't have a low-res alternative should you leave it off or can you link to the same image? Hope this makes sense! Thanks! Tag: how to connect an html page with an access database to search it? Tag: 64095
  - 5
    - Need to code to make a interactive calendar Hi all I've been searching for code to make a interactive shared calendar for front page. danny Tag: how to connect an html page with an access database to search it? Tag: 64093
  - 6
    - Editing Password Protected Pages Hello again, I'm fairly familiar with password proteting pages, what I want to do is allow a privilaged person to edit specific pages through their browser. Is this possible? I'm thinking I'll likely have to create a form page with text boxes for each editiable area and have the form post to the page. Am I on the right track? Do you see anything I'm overlooking? Tag: how to connect an html page with an access database to search it? Tag: 64092
  - 7
    - Table in marquee format Hi I have a single row, 19 column table. Each cell in the table holds a very small jpg. I want to make the table continuously scroll across the screen like a marquee does. Is that possible??? Thanks! Tag: how to connect an html page with an access database to search it? Tag: 64087
  - 8
    - Linking spreadsheet to web page I am currently creating multiple web pages that have drop down boxes and textboxes. I need help linking the cells of my excel spreadsheet into the drop down boxes and to the textboxes. I want to be able to select the item out of the drop down box and the additional information auotmatically appears in the textboxes. I am very new to vbscript and javascript so any programming information is needed!!!! Thank You so much!!!! Gary Holmes Tag: how to connect an html page with an access database to search it? Tag: 64086
  - 9
    - how to set form fields for autoresponders tried everything.used form wizard for contact details.servers autoresponders won't work even with frontpage extentions installed.please help. all i want is save emailing nlist while at same time sending a follow up message automatically!seems impossible at moment. Tag: how to connect an html page with an access database to search it? Tag: 64079
  - 10
    - FrontPage 2003 Training Anyone have a good training course for FrontPage 2003? Either online, disk or training center(east coast) -- Have A Great Day Bill Meyer Tag: how to connect an html page with an access database to search it? Tag: 64076
  - 11
    - 80% of source code page blank I am having problems editing my website and found that the source code has a huge gap in it, on the home page. www.springhousecandles.com It shows up on explorer, but not on Mozilla. I have to edit through explorer. I edit right on the server, they told me to save the site on my computer or a disk, and they would fix it. Is there any way to fix this big gap without my server wiping out my website and me having to load it again? How do I save my site on a disk from the frontpage server? Think that I should have a back up. Thanks so much Tag: how to connect an html page with an access database to search it? Tag: 64075
  - 12
    - Access hyperlinks not showing correctly I'm creating a database in Access that I want to link to a webpage using Frontpage. The database contains scholarship information, so I want to display the scholarship name on the webpage, but have it link to the PDF file that has a description of the scholarship. I've figured out how to get a hyperlink into an Access database field, but I am having problems with the results that are coming up on the webpage. I'm following the instructions that say to put the TITLE that you want the viewer to see, then a "#" sign, and then the FILENAME. What is coming up, though, on the webpage is the entire string. For example, I type into the database: John Smith Scholarship#smithscholarship.pdf. I want "John Smith Scholarship" to show on the webpage as a hyperlink and then link to the smithscholarship.pdf that is in the same folder. What shows on the webpage is "John Smith Scholarship#smithscholarship.pdf" as a hyperlink. How do I get rid of the file name? The second problem I'm having is linking to the PDF that is in the same folder as the database and webpage. I've tried using "John Smith Scholarship#smithscholarship.pdf" and "John Smith Scholarship#\smithscholarship.pdf" and "John Smith Scholarship#/smithscholarship.pdf." The only thing that works and links to the file is if I use the entire web address: ""John Smith Scholarship#http://myschool.com/smithscholarship.pdf" But there again, it shows the entire string on the webpage instead of just what I'm telling it to show for text, which is "John Smith Scholarship." I hope that all makes sense. Please tell me why it's not working. I've followed all the instructions in Access and Frontpage Help, I thought... Tag: how to connect an html page with an access database to search it? Tag: 64074
  - 13
    - Graphics do not display Hi Everybody, A. I have Front Page 2002 SP3. B. I have WINDOWS XP with SP2 and Internet Explorer V9.0.2900. I have a large number of HTM files which I downloaded from the COREL graphics site over the years. Recently, I have found that when I open most of these files, the images do not display. They do not display in Internet Explorer, Front Page 2002, or Word XP. Yet at one time the images did indeed display along with the text. The original sub-folders with the same name still are in the same parent folder as the HTM file. Strangely enough, right clicking on the blank image and then clicking on properties, correctly identifies the image -- usually a JPEG or GIF. However, the only display within the file is a blank box with a red X. A few HTM files do open properly -- i.e. the images are displayed when the file is opened. Most do not. I can open the images in the sub-folder separately with a graphics program like Adobe PhotoShop. 1. What could have happened? 2. Is there a way to trouble shoot this problem? 3. Is there a way to tell the file to display the image along with the text? Thanks for any help and suggestions. Phil Tag: how to connect an html page with an access database to search it? Tag: 64068
  - 14
    - Query Database with 2 dropdowns I am trying to create a webpage that will allow users to specifiy what data they would like to look at in a database by using two dropdown menus. I have followed the wonderful instructions at http://spiderwebwoman.com/tutorials/doubledropdown.htm. I can get it to work on the demo database, but not with my data base. The first page is grade. The users selects a grade level and the results are suppose to go to subject page. The page displays but the dropdowns are blank. Below are the SQL statements for each dropdown: "SELECT DISTINCT grade FROM StateAchievementStandards WHERE (grade='::grade::')" "SELECT DISTINCT subject FROM StateAchievementStandards WHERE (grade='::grade::')" I have gone over steps many times and I can't see why it isn't working. Hopefully somebody else can see my error. Thanks in advance the help. Tag: how to connect an html page with an access database to search it? Tag: 64063
  - 15
    - Map to a network drive Hi, this the first time I have posted to this group. I am trying to create an easy method for end users to map to a network drive. Our current web-page development program is Frontpage. Is there an easy way in Frontpage to accomplish this or do I need to have some script. Currently, I have a link for each mapped drive so the user can open the mapped drive and then I give them the instructions on how to map to this drive, using the convential method of Tools--Map network drive--select drive letter--enter server name--enter directory. I am hoping there is an easy way to accomplish this. Thanks for your help..... Tag: how to connect an html page with an access database to search it? Tag: 64060
  - 16
    - Map to a network drive Hi, this the first time I have posted to this group. I am trying to create an easy method for end users to map to a network drive. Our current web-page development program is Frontpage. Is there an easy way in Frontpage to accomplish this or do I need to have some script. Currently, I have a link for each mapped drive so the user can open the mapped drive and then I give them the instructions on how to map to this drive, using the convential method of Tools--Map network drive--select drive letter--enter server name--enter directory. I am hoping there is an easy way to accomplish this. Thanks for your help..... Tag: how to connect an html page with an access database to search it? Tag: 64059
  - 17
    - Importing powerpoint slide as webpage theme I have a current powerpoint presentation slide that I would like to use a web page theme in sharepoint. I was thinking of using Frontpage 2003, to create a template and using in Sharepoint. Any other ideas ? Tag: how to connect an html page with an access database to search it? Tag: 64057
  - 18
    - I'm tring to use front page & can't get access to work on the web I use to be able to work on my pages & now it won't let me in & doesn't ask for pass word or anything like that.I have my web master work on it & I'm the one who can't get in & even put front page new on my lap top & can't get in. I've ckd with the dsl paople & my web host & say everything is fine. Tag: how to connect an html page with an access database to search it? Tag: 64052
  - 19
    - Adding a hotspot to an image makes F.P. blow up...any ideas?? When I add a hotspot to an image in Front Page, the program shuts down. Does anyone have any ideas why or how to fix this? Tag: how to connect an html page with an access database to search it? Tag: 64051
  - 20
    - Sharing Conten in a cell. I want to have a cell on each page of my website that has the same content. For example sponsors of an event. I would like to be able to update this content in one location and have every page updated instead of having to update every page manually. How do I do this? Tag: how to connect an html page with an access database to search it? Tag: 64042
  - 21
    - FP View of CSS Site I am trying to learn the use of CSS and am getting along slowly but surely. One issue I can't figure out is the design view in FP. I created a one page site from a template with CSS attached. Everything works fine but in the design view, the page appears as if there is not enough room on the 'table'. The text and buttons wrap to the next line and a strange column appears to the right of the area. When I click on preview, everything appears fine as does when I publish the site. If nothing else it has got me working a lot closer to the coding but it is a bit infuriating. Any enlightenment would be appreciated. Thanks in advance. Tag: how to connect an html page with an access database to search it? Tag: 64041
  - 22
    - Print Direction I am using FrontPage 2003. I am creating a calendar page. In order for the calendar page to print correctly for someone visiting the site, it must be printed in "Landscape." Is there a way to set this as the default printing orientation for a page? Thank you Tag: how to connect an html page with an access database to search it? Tag: 64036
  - 23
    - CSS & Images Hi, I've been wanting to experiment with use CSS's. Can you, and if so, how do you use CSS for images? -- TY Tag: how to connect an html page with an access database to search it? Tag: 64034
  - 24
    - How do I retrieve deleated file from FrontPage? I was prompted to remove a file from FrontPage. I clicked "yes" and it removed the file permanently from my desktop. Tag: how to connect an html page with an access database to search it? Tag: 64031
  - 25
    - Drop Down Buttons I am trying to put drop down buttons onto my webpage. Can anyone explain how do to do that? Tag: how to connect an html page with an access database to search it? Tag: 64025
- Next
  - 1
    - Using added table I have added a new table to a database that I have been using. I created a new page to display that table using the Database Results wizard. It allowed me to select the new table and created the page with SQL referencing it. However, when I publish the page and try to access the table I get an error that says â??Database Results Wizard Error The operation failed. If this continues, please contact your server administrator. Well, Iâ??m the administrator and I donâ??t know why this is happening. Can you help. Tag: how to connect an html page with an access database to search it? Tag: 64023
  - 2
    - Positioning graphic without absolute positioning I want to create a billboard on my web site and don't know how to position a graphic exactly without using layers. www.themilliondollarhomepage.com did this. As I can't write code, the 'source view' didn't help much. All I want is a header (masthead) and then all the graphics. Can anyone help? Tag: how to connect an html page with an access database to search it? Tag: 64009
  - 3
    - FP Templates & Javascript/Image Rollovers I've made a nice banner with image rollovers for the top of my page in Adobe Photoshop 6/ImageReady. Since I have triple-digit number of pages to create/update, I made a dynamic template to help speed-up page creation and quicken page updates. I had ImageReady export the HTML and setup the display of the images in CSS (instead of making a table), plus it created some JavaScript to handle the rollovers. Everything works fine, except that the relative links (i.e.- images/bannerimgs/image_01.jpg) don't change to reflect where it is in the site's directory tree. Therefore, if I make the template off the root, then apply it to a page in a subdirectory, none of the relative links work because it's still showing the same path as if it was from the root. FrontPage will change the relative links in hyperlink tags in the page, but not in the JavaScript. The only work-around I've been able to come up with is to create multiple templates of the same template, just change the javascript relative URLs in each template depending on what page it will be applied to. This to me seems like an inefficient way of doing it. Is there any way of making the javascript code more "universal" while still maintaining the relative paths so that I can use just ONE template for all pages - even ones buried 2 to 3 subfolders deep? Is there a way to "fool" FrontPage? I'd rather avoid using static URLs. Tag: how to connect an html page with an access database to search it? Tag: 64008
  - 4
    - Line and page numbers I have lost the running page and line numbers at the bottom of my documents. Tag: how to connect an html page with an access database to search it? Tag: 64006
  - 5
    - Insert TreeView control Please give me instructions / sample of TreeView control inserted into web page using FP. I do have programming experience in using TreeView control in VB forms (non-web related). Tag: how to connect an html page with an access database to search it? Tag: 64005
  - 6
    - Email confirmation - how's it done?? Hi Using FP2000 Does anyone know how to set up an email confirmation for a site? Like: New member supplies name and email address. Sends 'form'. When the user receives the email - they send it back so confirming that email address is valid. At some point I have got to include a password/login details. I'm new to this side of things. Is it done with JavaScript ? Any help would really be appreciated. Many thanks, Stephen Tag: how to connect an html page with an access database to search it? Tag: 64002
  - 7
    - Sync Problems Using FP 2000 with a Linux ISP and Front Page Extensions enabled. I have been using this setup for some time but the file sync doesn't seem to function the way I thought it would. I have at least one file that always is uploaded even though this file has not changed in over 3 months. I updated another file with the same name but with a newer time stamp and it did not get uploaded. I had to change the name in order to force it to update. FP did recognize that the old file was still on the server and ask me if I wanted to remove it, so that works OK. I noticed there are about 40 files, images, button gifs, etc that are on the server but are not on my devl system any more, why don't these guys get deleted? Is there a way to synchronize these two systems so that only files currently in use are present on both systems? TIA, GWB Tag: how to connect an html page with an access database to search it? Tag: 63989
  - 8
    - using Access database with FP2003 I'm starting an online store and I have many products and, therefore, many prices to keep track of. I have all my products, prices, etc stored in an Access database and I have already made the database connection with my site. Is there any way I can grab a specific price from my database and display it for a specific product on the product page in the website? So, in other words, is there a way I can type all my prices into my database, then have the prices on my website automatically update according to the changes I made in the database? Tag: how to connect an html page with an access database to search it? Tag: 63987
  - 9
    - creating a gallery frontpage template I want to create a page where I can upload new pictures and text to my gallery page on my website through a browser using frontpage 2003 can anyone help me find the easist solution Tag: how to connect an html page with an access database to search it? Tag: 63986
  - 10
    - creating a gallery frontpage template I want to create a page where I can upload new pictures and text to my gallery page on my website through a browser using frontpage 2003 can anyone help me find the easist solution Tag: how to connect an html page with an access database to search it? Tag: 63985
  - 11
    - save image with double click instead of right click I am creating a website for a client who has European visitors to their site. They need to have a page that contains high resolutions images for their European visitors to download. They tell me that these European visitors cannot or will not use the "right-click, save picture as.." function. What they want is the ability to simple "double-click" on an image and have the "save as" dialog box pop up. I am desperate for an answer to this. Tag: how to connect an html page with an access database to search it? Tag: 63981
  - 12
    - How do I expand on a word/sentence in a seperate box I want to be able to highlight a word or sentence so my visitors can click on this and an expanded explaination appears. Please help. Tag: how to connect an html page with an access database to search it? Tag: 63978
  - 13
    - HTML and PHP link Hi I have a html form page created in FrontPage 2003 where a user adds there info on and then it is send via a php page but all it does is only pulling through the titles not the users info, for example The html form has the following on it; Title*: Mr Mrs Ms Miss (with radio buttons to select) First Name*: (with a text box for name) Surname*: (with text box for surname) Then this is part of the php that is working but it only e-mails the Titles not the text box info. <? $to = "casper@firetech.co.nz"; $subject = "Message from the FPIS Contact Page"; $msg = "Title:" . $contact_gendertitle . "\n\n"; $msg .= "First Name:" . $contact_firstname . "\n\n"; $msg .= "Surname:" . $contact_surname . "\n\n"; What can I do to get it to pull through the info in the text boxes Regards Casper Tag: how to connect an html page with an access database to search it? Tag: 63977
  - 14
    - Frontpage 2003 Bug, IE6 Bug or Windows Font Bug? I have tried everything I can think of to figure this out. When I use Arial 1 (8 pt) for a vertical menu, and if the first character is a capital "W", when viewed in IE6, the first two stacked pixels forming the top left corner of the "W" are cutoff (cuts off pixels horizonally by one pixel). I have confirmed this by looking at the overlay files. Unfortunately, just editing the overlay files does not cure the problem. Can someone see if they can reproduce the problem. I am wondering if it is just my computer, or a bug in FP, IE, or Windows. Here are the steps (takes about two minutes, maybe less if you are a proficient FP user). 1) Start FP 2003, and create a new site using the Corporate Presence Wizard. Just keep clicking Next to get through the steps, and finally Finish. 2) After the site is created, go to Format, Theme, and select the Website Default Theme which is Journal. 3) Click the down arrow, and select Customize, click the Graphics button, then for item select "Vertical Navigation". Click the Font tab, and change the font to Arial size 1 (it is critical that this font be used, since the other fonts and sizes appear to be OK). 4) Click OK twice to save change, and rename theme to another temporary name. 5) Click the Website tab at the top, and click the Navigation button at the bottom. 6) Right click on "News", and select Rename. Change the name from "News" to "WNews". Make sure you use a capital "W", not lowercase. 7) Hit the F12 key to preview the page in the browser. Does your system cut the top left of the "W" off? Thanks everyone! Michael Tag: how to connect an html page with an access database to search it? Tag: 63975
  - 15
    - Banner ad manager I want to increase the size of my banners, but when I follow the directions to access the banner ad manager by right clicking on a banner in page view I do not see the manager. Help! I am using Frontpage 2002. Gary Tag: how to connect an html page with an access database to search it? Tag: 63968
  - 16
    - HIGHLIGHT SPOTS ON AN ARCHITECTURAL SITE PLAN I have a architectural site plan. There are 20 different thumbnail floor plans on one graphic. The graphic is black lines (floor plans) on a white background. I would like to when you mouse over each thumbnail floor plan, it highlights with a color. Then when you click on that thumbnail floor plan (which is highlighted with color) it will hyperlink to a more detailed floorplan. Is this possible? Thanks for your time, JD Tag: how to connect an html page with an access database to search it? Tag: 63967
  - 17
    - Frontpage Upload Component Is there a way to increase the maximum file size that the FP upload component can handle? Say from 1 MB to 10MB? Tag: how to connect an html page with an access database to search it? Tag: 63963
  - 18
    - Frontpage begineer's questions have several novice questions.. 1. I have windows XP, I thought it comes with frontpage, but I can not find it in my program files except for an empty folder named frontpage. So, do I have to still buy it? 2. What version should I buy, 2002 or 2003? 3. Where to buy it from, if I don't want it through free schemes? 4. My web hosting service supports only frontpage 2002, if I buy 2003, would it be a problem? Thanks. PV Tag: how to connect an html page with an access database to search it? Tag: 63961
  - 19
    - mis aligned page I have one page that I do not know what is wrong. the bottom footer is continuing to duplicate to the right. My other pages, that are similar are ok. Any ideas what might be causing it? thanks JJ http://www.palielementary.org/cgi-bin/calendar/big_calendar.cgi Tag: how to connect an html page with an access database to search it? Tag: 63954
  - 20
    - Email in Form code Hi, Since I am getting massive amounts of spam, I am changing all the email addresses to escapes - mail etc. It might help! But I noticed that in the code side of a FrontPage form, the email address shows up written normally. I wonder if it is possible to write the address, using the escape sequences, in the form properties, or to change them in the code (and still have them work!). Has anyone tried this, or have any thoughts on it? Or maybe have a better way? Thanks! J~ Tag: how to connect an html page with an access database to search it? Tag: 63952
  - 21
    - table scrollbars I want scroll bars on the side of table, but when do it with <Div class="table"> I loose my formating, It does gives the scrollbars with the div tag. What do I need to change? Thanks JJ <table class="table"> <tr> <td class="odd" height="33"> <a target="_blank" href="xx.htm">2006</a></td> <td class="odd" height="33">2-25-06</td </tr> </table> -----CSS---- .table { border: 5px ridge #274573; color: #000000; border-collapse: collapse; padding: 0px; border: 1px; font-size: 100%; margin: 0px 0px 0px 80px; text-align: center; overflow: auto; height: 100px; } Tag: how to connect an html page with an access database to search it? Tag: 63947
  - 22
    - Forms asks for password, why? After creating a form in frontpage and submitting it, it aks for a username and password. InCorrect uid & pw = You are not authorized to view this page Correct uid & pw = takes me to confirmation page. Any suggestions? Tag: how to connect an html page with an access database to search it? Tag: 63943
  - 23
    - CI Host Information Hey......Anyone who has any information on CI Host please let me know or email it to me. I am going down on Monday to file a civil claim against them for Failure To Pay For Services Rendered and could use all the information I can get on CI Host, Creative Innovations, and Christopher Faulkner. Thanks in advance! Tara Tag: how to connect an html page with an access database to search it? Tag: 63941
  - 24
    - Static Template Uses Absolute Pathnames! I'm new to FrontPage 2003. I created a static template for a new website. When I create a page using this template and look at the code I see absolute paths like: <link rel="stylesheet" type="text/css" href="file:///C:/Documents%20and%20Settings/user3/My%20Documents/My%20Webs/test/_private/default.css"> instead of <link rel="stylesheet" type="text/css" href="_private/default.css"> Obviously absolute paths mean nothing when published to a server. What am I doing wrong? FP2000 always used relative paths. My thanks to anyone who helps me out. Tag: how to connect an html page with an access database to search it? Tag: 63940
  - 25
    - Is FP altering my form data? I've got a simple form on a site where people can send a plain text message. It all works OK except for the text field, which is a standard textarea. If the person types in, say, "I'd love to see you. Let's get together." the message is received like this: "I'd love to see you. Let's get together." The form data is all plain text, so this is baffling to me. Is this something in the code generated by FP? Tag: how to connect an html page with an access database to search it? Tag: 63937

how can i connect my html page with an access database to search the access
database for a specific word and display the result?

Top

Re: how to connect an html page with an access database to search it? by Stefan

Stefan
Thu Jun 22 03:14:26 CDT 2006

See http://www.asp101.com/samples/db_search.asp

--

_____________________________________________
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.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________

"Badawy" <Badawy@discussions.microsoft.com> wrote in message news:5A6639E9-A090-46F5-AB2B-A83AE4A17B49@microsoft.com...
| how can i connect my html page with an access database to search the access
| database for a specific word and display the result?

Top