asp from relational access db

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
 - Launch and Edit button on the tool bar Trying to learn Frontpage. I have designed the template in Fireworks. Now I am trying to adapt it for FrontPage. I cannot seem to locate the Launch and Edit button. This is supposed to create a Fireworks image so it can be worked with in FrontPage. Tag: asp from relational access db Tag: 33423
 - 2
 - Hyperlink to Access? Does it take a great deal of programming knowledge to create a hyperlink in a Front Page html file that transfers control to Access, so Access reports can be run? I don't have the programming knowhow to do the more complex code involved in integrating the two together, and the wizards in both programs (DRW/Data Access Pages) don't go far enough for what our company wants. Would this require a plug in? Thank you. Tag: asp from relational access db Tag: 33419
 - 3
 - banner ad is there any way to make a banner ad manager in fp 2003? i remember i could in 2000, but i upgraded and now it seems i can't find this feature. Tag: asp from relational access db Tag: 33418
 - 4
 - The Only Font is the Default Font That's exaggerating a bit, but other than a small selection of fonts, when I change the font on FrontPage 2002 into a new font, it automatically becomes the default font. The strange thing is that if I set the default font to one of these usually-undisplayed fonts, they display fine (of course, all others become that one default). If I preview it in the browser it looks fine, and the fonts are installed.... Tag: asp from relational access db Tag: 33416
 - 5
 - can't publish anymore - FrontPage 2000 version 4 Hi there! I edit and re-publish my site every month. I never had any problem until today. When publishing, I get the following message: This FTP server doesn't support folder names that contain spaces. Rename the source web's folder corresponding to "microsoft frontpage" and any other folders that have spaces in their names and try again... I don't understand...which spaces? I've checked the folder and their is no name with spaces. Please help Thanks daniel Tag: asp from relational access db Tag: 33414
 - 6
 - eliminating top margin on Netscape When I preview my page in Netscape, it always shows a top margin of about 15 pixels. This does not show up when I preview in IE with page option set to zero top margin. Does anyone know how to get rid of this top margin in Netscape? Thanks. Tag: asp from relational access db Tag: 33413
 - 7
 - Hit counter Hello: I have mde my first web site with front page. after publishing it everything works fine except... the hit counter. the counter reads 1 all the time. it never advances and i have tried from logging on from several different ip addresses but it still never advances. the address to my space is an http address but the adress i was given to publish my page to is and ftp address. My ISP has a section where i needed to activate front page extensions and i have done that. they tell me it should work fine and the problem is on my end. can anyone shed some light on my problem? Thanx Luke Tag: asp from relational access db Tag: 33411
 - 8
 - FREE WEB SERVER SERVICE? HI! IN ORDER TO PUBLISH A WEBSITE THROUGH FRONTPAGE, YOU NEED TO HAVE A WEB SERVER SERVICE AM I CORRECT? ANYWAY, ARE THERE ANY ABSOULTLY FREE SERVICES OUT THERE I CAN USE? THANKS! Tag: asp from relational access db Tag: 33410
 - 9
 - Link bar icon When a user drags the web page address to their browsers links bar, it displays the title of the page and the Explorer icon. On some pages (as with http://www.bloomberg.com for example) the icon is specific. Anyone know how to make FrontPage 2002 do this ?? Thanks Tag: asp from relational access db Tag: 33401
 - 10
 - E-mailing form results...Still%*@$ I'm still having problems with e-mailing my form results. Listed below are some entries from Otlk2003& FP Server Extensions: Front Page Server Extensions: Web Servers's e-mail address: craigwarmy@bendcable.com Contact address: craigwarmy@bendcable.com SMTP server: HOME Mail encoding: use default encoding Character set: use default encoding Outlook 2003 Internet E-mail Settings(POP3) Incoming Mail Server:pop-server.bendcable.com Outgoing mail server(SMTP):smtp-server.bendcable.com Are these entries correct? TIA --Craig Tag: asp from relational access db Tag: 33400
 - 11
 - Hosing Server Hello, The company which hosts my website claims that my active server pages are hosing his server. I have had these pages for 4 years pretty much as they were written. I didn't write them but added criteria and changed the output format, but a while ago. I have had them on several servers and was never told of a problem This recenlt company has never reported a problem, but now claims they had to quarantine my site to protect the other site on the server. I have been having trouble that I know if since they upgraded from Win2000 to Win2003. There is no logic to the claim that my pages are the problem. It seems the problem must be with Win2003 or the configuration. Here is page that is run most frequently. It is run from a form on another ASP. I am hoping someone will look at it and see if there is a problem which can be identified to cause problems on the server. Thanks in advance. <% SortBy = Request.Form("SortBy") SortMess = "" If SortBy = "DateLoading" then SortOrder = "DateLoading, OriginState, OriginCity, DestinationState, DestinationCity " SortMess = "Sorted by Load Date/ Origin State/ Destination State" ElseIf SortBy = "OriginState" then SortOrder = "OriginState, OriginCity, DestinationState, DestinationCity, DateLoading" SortMess = "Sorted by Origin State/ Destination State/ Load Date" ElseIf SortBy = "DestinationState" then SortOrder = "DestinationState, DestinationCity, OriginState, OriginCity, DateLoading" SortMess = "Sorted by Destination State/ Origin State/ Load Date" End If Set rs = Server.CreateObject("ADODB.RecordSet") q = "SELECT LoadID, OriginCity, OriginState, DestinationCity, " &_ "DestinationState, DateLoading, TrailerLength, TrailerType, comments, Recurring FROM Loads WHERE (Recurring = False) AND (1=1)" dateavail = Request.Form("dateavail") if dateavail <> "" then if NOT IsDate(dateavail) then Session("mess") = "The date you entered for the Date Loading is not formatted properly. Please enter it again." Response.Redirect "searchloads.asp" else q = q & " AND (DateLoading = #" & dateavail & "#)" end if else q = q & " AND (DateLoading >= #" & date() & "#)" end if originstate = Request.Form("originstate") if originstate <> "" then q = q & " AND (OriginState LIKE '%" & originstate & "%')" end if destinationstate = Request.Form("destinationstate") if destinationstate <> "" then q = q & " AND (DestinationState LIKE '%" & destinationstate & "%')" end if trailertype = Request.Form("trailertype") q = q & " AND (TrailerType LIKE '%" & trailertype & "%')" q = q & " Order by " & SortOrder rs.Open q, "DSN=TruckLoadsDev;" %> <html> <head> <meta name="GENERATOR" content="Microsoft FrontPage 5.0"> <title>Search Loads - Matching Records</title> <meta name="Microsoft Border" content="tb"> </head> <body bgcolor="#FFFFFF" link="#000080" vlink="#800080" alink="#000080" background="../images/trucksbg3.jpg"> <table width="800" cellpadding="2" align="LEFT" valign="TOP"> <tr>  <td width="125" align="LEFT" valign="TOP"> </td>  <td align="LEFT" valign="TOP"><table border="0" width="100%"> <tr> <td width="100%" align="left">Search Loads - Matching Records</td> </tr> </table> <%if NOT rs.EOF then%>Records matching the parameters you specified are listed below. To see the details or contact the Company which owns the load, click on the Origin  for that load. <a href="../asp/searchloads.asp">Search Again</a> <div align="left"> <table border="0" cellpadding="0" cellspacing="0" width="100%"> <tr> <td width="100%"><% Response.Write SortMess %></td> </tr> </table> </div> <table border="0" width="800"> <tr> <td width="155" valign="top" align="left" bgcolor="#9999FF">Origin State,  City</td> <td width="165" valign="top" align="left" bgcolor="#9999FF"> Destination State, City</td> <td width="128" valign="top" align="left" bgcolor="#9999FF">Trailer Type</td> <td width="78" valign="top" align="left" bgcolor="#9999FF">Date Loading</td> <td width="242" valign="top" align="left" bgcolor="#9999FF">Comment</td> </tr> <%while NOT rs.EOF Datel = "" Recur = "" if rs("Recurring") = False then DateL = rs("DateLoading") else Recur = "Recurring" End If if rs("TrailerLength") = 0 then tLength = "" else tlength = rs("TrailerLength") End If %> <tr> <td width="155" valign="top" align="left" bgcolor="#FFFFFF"><a target="_blank" href="loaddetails.asp?loadid=<%=rs("LoadID")%>"><%Response.Write rs("OriginState") & ", " & rs("OriginCity")%></a> </td> <td width="165" valign="top" align="left" bgcolor="#FFFFFF"><%=rs("DestinationState") & ", " & rs("DestinationCity")%> </td> <td width="128" valign="top" align="left" bgcolor="#FFFFFF"><%=tlength & " " & rs("TrailerType")%> </td> <td width="78" valign="top" align="left" bgcolor="#FFFFFF"><%=DateL%> </td> <td width="242" valign="top" align="left" bgcolor="#FFFFFF"><%=rs("Comments")%>             </td> </tr> <tr> <% rs.MoveNext wend%> </tr> </table> <a href="../asp/searchloads.asp">Search Again</a> <%else%> No Loads matched your query.   <a href="../asp/searchloads.asp">Try again</a> <%end if%>  </td> </tr> <tr> <td width="150" align="LEFT" valign="TOP"></td> <td align="LEFT" valign="TOP"><a href="../TruckTrackingLog/Def_NoLinks.htm" target="_blank">Try our free Truck Tracking Program (written for Microsoft access)</a></td> </tr> </table>  <img src="http://www.stattrax.com/cgi/stattrax.cgi?account=3333&page=513" width="1" height="1"> </body> </html> Tag: asp from relational access db Tag: 33396
 - 12
 - Database Locking up Hello, I have a Access Db on a website. I have a procedure of FTP'ing a database (clientDB.mdb) to the site then running an active server page to transfer the data to the main database (Truckloads.mdb). After the transfer I close the ftp program (wsFTP Pro v8.01). Next I run the ASP. A couple weeks ago the company which hosts my site, upgraded from Win2000 to Win2003. Immediately there were problems. The active server pages stopped working intermittantly. I discovered that there was an .ldb file ( Truckloads.ldb) in the Database directory which was causing the problem. The company said that they tracked the problem to coincide with the time I ran the ftp program and my asp. Since I transferred clientDB.ldb, I don't get the connection. Nothing changed on my website, but the server software changed, so logically, it would be something in Win2003 or the configuration that is the problem. Does that seem feasible? The company also claimed that my Active server pages were hosing his server. I don't know which pages, but here is the page I run to do the transfer. Is ther something in that which could cause memory problems? I only run it a half dozen times per day. I'll post other code in another thread. Thanks for any help. <%@ Language=VBScript %> <html> <head> <title></title> </head> <body>  <% Response.Write "Uploading data... " Dim DSNConn, DSNClient Dim ServerConn, ServerRst, ClientConn, ClientRst Dim vSQL, ConnErr, fld, fldname DSNConn = "DSN=TruckloadsDev" DSNClient = "DSN=Clientdb" Set ServerConn = server.CreateObject("ADODB.Connection") ServerConn.Open DSNConn Set ClientConn = server.CreateObject("ADODB.Connection") ClientConn.Open DSNClient ServerConn.BeginTrans If UploadTrucks = True then if UploadLoads = true then Response.Write " All OK!" ServerConn.CommitTrans%> <form action=ViewData.asp method=post> <input type=submit value="View Revised Data"> </form> <%else Response.Write " Due to errors, no uploading has occurred." ServerConn.RollbackTrans end if else Response.Write " Due to errors, no uploading has occurred." ServerConn.RollbackTrans end if set ClientRst = nothing set ClientConn = nothing set ServerRst = nothing set ServerConn = nothing %>   <% function UploadLoads on error resume next Response.Write " Uploading Loads..." Set ServerRst = server.CreateObject("ADODB.Recordset") Set ClientRst = server.CreateObject("ADODB.Recordset") Set ClientRst = ClientConn.Execute("Select * from LOADS") If ClientConn.Errors.Count = 0 then 'there is a Loads table and it's now open 'Open Loads table on server database vSQL = "Select * from LOADS Where 1=0" ServerRst.Open vSQL, ServerConn, adOpenKeyset, adLockBatchOptimistic, adCmdText If ServerConn.Errors.Count = 0 then'success do until ClientRst.Eof 'loop through records on client db ServerRst.addnew for each fld in Clientrst.Fields 'loop through fields fldname = fld.name if fldname = "ID" or fldname = "posted" or fldname = "archive" or fldname = "delete" then 'do nothing Else serverrst(fldname) = clientrst(fldname) end if next serverrst("Uploaded")=Now() 'ServerRst.addnew arFields, arValues ClientRst.movenext loop ServerRst.UpdateBatch if err.number = 0 then Response.Write " Loads successfully updated!" UploadLoads = True else Response.Write " Error uploading 'Load' information: " & err.number & ", " & err.description UploadLoads = False end if Else 'error opening Loads in Server db Response.write " Error(s) in server database:" for each ConnErr in ServerConn.Errors Response.write ConnErr.Number & ", " & ConnErr.Description & "; " next UploadLoads = False end if else 'error opening Loads table in client db if ClientConn.Errors(1).Number = -2147217865 then 'table isn't there Response.Write " No 'Loads' records to upload. " UploadLoads = True else 'Some other error Response.write " Error(s) in client database:" for each ConnErr in ClientConn.Errors Response.write ConnErr.Number & ", " & ConnErr.Description & "; " next UploadLoads = False end if end if ServerRst.Close set ServerRst = nothing ClientRst.close set ClientRst = nothing end function function UploadTrucks on error resume next dim i i=0 Response.Write " Uploading Trucks..." Set ServerRst = server.CreateObject("ADODB.Recordset") Set ClientRst = server.CreateObject("ADODB.Recordset") Set ClientRst = ClientConn.Execute("Select * from TRUCKS") If ClientConn.Errors.Count = 0 then 'there is a Trucks table and it's now open 'Open Trucks table on server database; return no records to improve speed vSQL = "Select * from Trucks where 1=0" ServerRst.Open vSQL, ServerConn, adOpenKeyset, adLockBatchOptimistic, adCmdText If ServerConn.Errors.Count = 0 then'success do until ClientRst.Eof 'loop through records on client db ServerRst.addnew for each fld in Clientrst.Fields 'loop through fields fldname = fld.name if fldname = "ID" or fldname = "posted" or fldname = "archive" or fldname = "delete" then 'do nothing Else serverrst(fldname) = clientrst(fldname) end if next Serverrst("Uploaded")=Now() 'ServerRst.addnew arFields, arValues ClientRst.movenext loop ServerRst.UpdateBatch if err.number = 0 then UploadTrucks = True Response.Write " Trucks successfully updated!" else Response.write " Error uploading 'Truck' information: " & err.number & ", " & err.description UploadTrucks = False end if Else 'error opening Loads in Server db Response.write " Error(s) in server database:" for each ConnErr in ServerConn.Errors Response.write = UploadTrucks & ConnErr.Number & ", " & ConnErr.Description & "; " next UploadTrucks = False end if else 'error opening Loads table in client db if ClientConn.Errors(1).Number = -2147217865 then 'table isn't there Response.Write " No 'Trucks' records to upload. " UploadTrucks=True else 'Some other error Response.write " Error(s) in client database:" for each ConnErr in ClientConn.Errors Response.write ConnErr.Number & ", " & ConnErr.Description & "; " next UploadTrucks = False end if end if ServerRst.Close set ServerRst = nothing ClientRst.close set ClientRst = nothing end function%> </body> </html> Tag: asp from relational access db Tag: 33395
 - 13
 - Cannot view XML input using XSL style sheet. I'm trying to write an ASP page using XML. When I pull the page up in the browser I get the following: Cannot view XML input using XSL style sheet. How do I fix this? Tag: asp from relational access db Tag: 33393
 - 14
 - preview In preview mode and in preview in browser I can see the dynamic html and page transitions, but I can't see them on the actual site on the net. Any reason why? is this a hosting issue? (using Tripod free)use to work before. thanks Tag: asp from relational access db Tag: 33392
 - 15
 - Knotty problem ? Hello, Wonder whether you could help with this. I have .asp pages in FrontPage linked to an Access database. In the form reflecting the database contents, I have a field called Course Code, for example the value 100. I define a hyperlink on this field towards a Subscription Form that contains a "submit form", i.e. creates a new record in the database. The idea is that when the user clicks on Course Code of the original form, he is redirected to the Inscription Form which automatically displays - in the Course Code field - the course code, in this example : 100. This to avoid that the user will have to retype the Course Code in the Inscription Form. Can this be done without complex programming ? Thanks a lot for your help. Doris, Geneva, Switzerland Tag: asp from relational access db Tag: 33382
 - 16
 - tables Tables or Layout Tables: What is the difference and which one should I use. Thanks Lisa Tag: asp from relational access db Tag: 33381
 - 17
 - Why is the navigation link bar button blank in FP 2003 for the current page I am viewing? Are there a lot of problems with FrontPage 2003 navigation link bar? Often some buttons don't have images or the home page button is missing... Currently, I publish my website like this: Safest procedure that I know (am new though). 1. Save files that are to be included elsewhere 2. Save each .dwt file and propagate the changes. 3. Publish the entire web, overwriting all files, (not just changed ones) Problem: Why does the page I am viewing on a published site either local file system or web server have the current page navigation button blank, i.e. without the button image? I have recreated the nav bar but still have the same problem. Tag: asp from relational access db Tag: 33380
 - 18
 - Problems publishing Frontpage My system crashed and I lost all the source to my website. I then purchased a new PC and recreated the website from scratch. It's not exactly the same, but it's close enough. When I attempt to publish it, it tells me that it cannot rename the folder. Any ideas? Tag: asp from relational access db Tag: 33379
 - 19
 - attaching a dynamic web template to a dynamic web template How do I with dynamic web templates (dwt) have a footer and header on each page in my site AND use other more complex dwt's in my website that have this same footer and header. Don't I have to attach a dwt to a dwt? Tag: asp from relational access db Tag: 33372
 - 20
 - Setting Home Page Link Am creating a web page & want a link on the page to click on to set my page as a Home Page for the viewer. How is this done? Thanks in advance Tag: asp from relational access db Tag: 33370
 - 21
 - How to delete hidden webs? HI, I downloaded a template for front page and somehow it got corrupt in FP2000 program. I have tried deleting the web so I can import it again but but it keeps showing up corrupt in the front page program. How can I can get inot the hidden directorys so I can completely remove this web from my computer so I can strat from scratch again. I paid $90 for this template and would really hate to throw my money out the window. thanks. I'm using FP 2000 Windows 98 512 mb ram Tag: asp from relational access db Tag: 33359
 - 22
 - Page sizes viewed on different monitors Hi I have done 2 websites at home on a 15" monitor. They work and look fine. But once loaded to the net, anyone who views them with a 17" screen gets a blank inch either side of the page. Does anyone know how I can fix this problem? Thanks, I would appreciate some help. Susie Tag: asp from relational access db Tag: 33345
 - 23
 - right click script How do I add sound to a right click script insted of a message. Here what I have for a script it dont let you copy or save as. The message thanks for looking apears. I would like NOT to have a message just a sound something I can record my self. <script LANGUAGE="JavaScript"> function click(){ if (event.button==2){ alert('THANKS FOR LOOKING!'); } } document.onmousedown=click // --> </script> Tag: asp from relational access db Tag: 33344
 - 24
 - Web Site Speed What are some tricks for making your web site faster Tag: asp from relational access db Tag: 33343
 - 25
 - Windows Media not working in Frontpage My media files are not accesssable in the FP2002 program. I can't edit or add any components to the media player in FP.As a matter of fact I recall there was a download availabe to enable the player for use in the FP program. Does anyone know what i need to do? Tag: asp from relational access db Tag: 33342
- Next
 - 1
 - Media Player and FrontPage 2002 I had incorporated the Windows Media Player into some of my pages some time ago, but now I am unable to edit the files. I cannot add any new media files to my Frontpage 2002 files. Running XP Home, Office 2002 Pro. What could be the problem. RE-installing the program didn't help. HELP!!!! Tag: asp from relational access db Tag: 33340
 - 2
 - Problems e-mailing form results Iam running FP2000 on Windows Professional. I am trying to e-mail my form results to a specified e-mail address(my own). I am running the app from my local server (http://home/webpage). Is there something outside of FP that needs to be changed so that the e-mail starts to work? In IIS? Tag: asp from relational access db Tag: 33339
 - 3
 - Presentations with Frontpage Does anyone know how to turn a file of frontpage-created html files into a presentation? What I really need is an "auto run" function, so that when the client inserts the disk, the specified page of the presentation just pops open. Tag: asp from relational access db Tag: 33338
 - 4
 - Modify default HTML template Hi there, I dropped my web programming back in 2001 and as such haven't done much since then but I'm getting back into it know. As such, a lot has changed with xhtml, xml, asp, php etc... I'm going to start using Frontpage to organize my site layout and do hyperlink testing but here's my question. I don't like the default HTML that Frontpage creates when you make a new page. It makes: <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252"> <title>New Page 1</title> </head> but I want to switch out/add some additional tags to make my template: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" /> <link rel="stylesheet" type="text/css" href="FILE NAME GOES HERE" /> <title>Index Page</title> </head> Is there anywhere in Frontpage where I can modify the template? Another quick question as well, is the code that Frontpage generates either HTML 4.01 or XHTML 1.1 strict (as in it follows W3C guidelines)? Thanks. -Duncan Tag: asp from relational access db Tag: 33333
 - 5
 - cell corners How do I remove them once the corners are inplace I can't change the colour or remove them with out deleting all the info in the cell. for the shadows I can just re-click the icon but for the corners how does it work. thanks Tag: asp from relational access db Tag: 33330
 - 6
 - Cell formatting in a form can a cell in a form be formatted ie. date 3/13/2004 or phone number 781-837-8549 Tag: asp from relational access db Tag: 33329
 - 7
 - Hyperlink to excel documents and have them open in excel not Internet Explorer I have an intranet webpage that has hyperlinks to Excel spreadsheets and Word documents but when you click on them they open inside Internet Explorer not in Excel or Word like I want them to do. Does anyone know how to make this work, please???? Tag: asp from relational access db Tag: 33326
 - 8
 - For Sale area I manage a association web site and the members want to have a "For Sale" area. Is there any kind of function if FP XP that I can do this? I don't want to have people email me everything and have to post it manually. HELP! Chris www.mscpoa.com -- Tag: asp from relational access db Tag: 33325
 - 9
 - Sizing shared borders I ma using FP 2003 for the first time and I have a shared border on my page. I have inserted some dynamic GIFs into this border. Now I need to make the border narrower (ie vertically). How do I do this. Thanks Tag: asp from relational access db Tag: 33317
 - 10
 - Changing horizontal button font I am trying to modify my theme to change the font and color of the text of a horizontal button. I cannot seem to find a style to control the appearance of these buttons. Tag: asp from relational access db Tag: 33314
 - 11
 - FP2003 Behaviors what is this and how do I use it? what are design time tools and how do I use them, the feature is greyed out ? FP2003 Thanks Tag: asp from relational access db Tag: 33311
 - 12
 - Can't open in MS Access database created by Frontpage 2003 I just upgraded from Frontpage 2002 to Frontpage 2003 today. Now, when I want to open Access databases created by the Form Wizard, it shows me an error "MS Access can't open this file. This file is located outside your intranet or on an untrusted site. MS Access will not open the file due to potential security problem". How do I get out of this? I want to be able to look at the database. Tag: asp from relational access db Tag: 33310
 - 13
 - Database Problems. Please Help! We have been trying to display our Access Database information on our Intranet, and enable users to search by different fields. We do not want anyone to update through the Intranet. The updating is done directly by one person into the Access file. Something seemingly easy has been a nightmare. This is what we have been trying: 1. Using Front Page's Database Results Wizard, we have had to first import our database into our Intranet web, and then we can see records, and search etc. However since this database is updated elsewhere, we can't keep reimporting the file to keep the info dynamic, and it will not open the imported Access file in its web location for editing. 2. Using Access's data access page feature, we have been able to get our records to show up on the Intranet and be connected to the underlying file. In addition we have been able to seal records from user editing, but the problem is that only search capabilities are a weak filter by selection that does not do wildcard searches (such as one word in a description field). 3. In our Access database we have a perfect setup of parameter queries so that the user inputs all or part of a reference and gets a nice report. When we get this into our web thru a data access page, the parameter form does come up, but after filling it in, records never show in the report. It seems we have come up against specific stumbling blocks. For instance, does anyone know how to set up a hyperlink on a page created in Front Page that would just bring up and transfer control to the Access file? Right now, "Quick View" gibberish comes up. Does anyone know how can I reference an Access database outside of the Intranet in a file such as global.asa? It only appears to recognize http:// and not network letters? Any help would be appreciated since we have been pulling our hair out! Tag: asp from relational access db Tag: 33304
 - 14
 - How do I make my website look same on any resolution? I'm new at this... have created a nice looking website, but did it while my resolution was set at 1280X1024. I went live with it, and a co worker looked at it from home and found that the pictures overlapped, and my text boxes were everywhere... sure enough, in her resolution, it looked like crud. Is there a setting for this or something? I can't help but notice most every other website I view doesn't have this problem! thanks! ken Tag: asp from relational access db Tag: 33302
 - 15
 - Frame - sizing I have a Frame page top banner, vertical left, and body. Across the top banner, I've sized it to fit on my screen. Is there a way to make it autofit onto anyone's display - so that they don't have to use scrollbars. I just want it to take up whatever space it needs. It's about 1" deep, but it seems to be resolution dependent. I only want it to take up as much room as it needs. I hope this makes sense. Thanks for any help. Diana Tag: asp from relational access db Tag: 33301
 - 16
 - Linking to and changing the contents of a specific cell I have a table of 4 cells. I'm not sure if I did it correctly, but I gave each cell an id. For this paticular example, I'm using a cell id of "top2". This cell currently has a graphic (../2.jpg) within. This graphic has a hotspot link that links to another graphic file (../2b.jpg). With the way this is written, the link opens a new window. Can you tell me a way that I can have this graphic display in cell id "top2", keeping my other cells unchanged? This is what I currently have. <area href="../2b.jpg" shape="rect" coords="98, 4, 142, 29"></map> <img border="0" src="../2.jpg" id=top2 width="256" height="141" usemap="#FPMap0"></td> Thanks, Paul Tag: asp from relational access db Tag: 33295
 - 17
 - Front Page 2000 and asp My webmaster wants me to change our website to asp. I have front page 2000 and don't understand the .asp file he sent me. What is asp and how do I change my website to it? Tag: asp from relational access db Tag: 33288
 - 18
 - Secure Order Form Does anybody have any recommendations of order forms that can be purchased to link to my website. I have e-commerce capability now, but I don't need the merchant account I just need to capture the information, calculate shipping and tax if necessary. Any suggestions? Thank you for any help. Tag: asp from relational access db Tag: 33285
 - 19
 - adding hyperlinks, I REALLY NEED ASSISTANCE! I really need help!! I just started making additions to an already existing website. What I am trying to do is add hyperlinks to thumbnail images so that when you click on the thumbnail you will see a larger image. When I publish the hyperlink for the image it turns out fine for that hyperlink, but this larger image will also appear when I click on any other thumbnails. I feel like I am just copying images over the previous images and that there no matter where I click it will bring me to the same hyperlink. Can anyone help me? Tag: asp from relational access db Tag: 33283
 - 20
 - Submitting information to Access I have an Access database that I want to write to from a webpage. I've followed the instructions for linking the the database to the page, but it doesn't write to the database. When I submit the form, it shows a page with the confirmation, but when I open the database, there information isn't there. Any ideas? Tag: asp from relational access db Tag: 33282
 - 21
 - cannot add navigation bar I wanted to try to add a navigation bar to our web page but when I pull down insert the navigation button is grayed out. Why? Tag: asp from relational access db Tag: 33280
 - 22
 - Come c.... si fa? Scusate bella gente, ma ogni tanto navigando in internet e aggiungendo ai preferiti il sito che mi piace tipo "yahoo" appare una Y rossa al posto della e di explorer nella barra dell'indirizzo..... solo che dopo un po' scompare e ritorna la e come faccio a vedere i vari simboli relativi ai siti? tipo la "y" rossa? Ringrazio tutti anticipatamente K Tag: asp from relational access db Tag: 33278
 - 23
 - Locking Frames to keep a set of 4 images from getting pulled apart. Is there a way to lock frames at a certain pixel size so that regardless of the screen resolution the images within a set of frames will not be pulled apart? For example: This may be a little unorthodox, but I've got an image that I've split up into 4 separate images. I've placed the 4 images in separate frames in such a way that the images come together and appear as one image. I then have links within a certain frame that will change the image in either the same frame or a different frame. If the explorer window is fully maximized, then the set of 4 images do not come together. So I'm looking to find out if there is a way to possibly lock the frame sizes so that the images do not get pulled apart. Thanks Paul Tag: asp from relational access db Tag: 33275
 - 24
 - Can't add background image to cell or table (option greyed out) Frontpage 2002 is driving me insane. I don't understand why the option for adding a background image in a table or cell is greyed out. Can anyone give me some insight. Tag: asp from relational access db Tag: 33262
 - 25
 - forms not working I have been getting the following message when I submit the email form on my site.Cannot run the FrontPage Server Extensions on this page: http://www.summitmountainhomes.com/Feedback Form.htm My web hosting service has reinstalled the extentions three times and I still get the same message. They seem to think that the extensions are corrupt. Any ideas? Tag: asp from relational access db Tag: 33261

I have this problem,creating an asp from access in
frontpage

table1(personel)
ID CODE SURNAME
1 smi01 smith
2 abc02 abconal

table2 (review)
ID CODE REVEIWER
1 smi01 abco2

***Query***
table1 table2 table1_1
CODE -------CODE
SURNAME REVEIWER---CODE
SURNAME
SELECT reveiw.code, personel.surname, reveiw.reveiwer,
personel_1.surname
FROM personel INNER JOIN (reveiw INNER JOIN personel AS
personel_1 ON reveiw.reveiwer = personel_1.code) ON
personel.code = reveiw.code;

query result desired
CODE SURNAME REVEIWER SURNAME(of reviewer)
smi01 smith abc02 abconal

but I am getting
CODE SURNAME REVEIWER-CODE SURNAME(of reviewer)
smi01 abconal abc02 abconal

as the surname field appears twice!

Any help would be great

Top

Re: asp from relational access db by Kevin

Kevin
Fri Feb 20 08:42:48 CST 2004

You're pulling data from 2 different "Surname" fields: personel.surname and
personel_1.surname. If you want to name the columns differently, use aliases
Example:

SELECT reveiw.code AS Code, personel.surname AS Personel_Surname,
reveiw.reveiwer As Reviewer, personel_1.surname As Personel_1_Surname ...

--
HTH,
Kevin Spencer
.Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

"aw" <anonymous@discussions.microsoft.com> wrote in message
news:13a1001c3f763$de480270$a501280a@phx.gbl...
> I have this problem,creating an asp from access in
> frontpage
>
> table1(personel)
> ID CODE SURNAME
> 1 smi01 smith
> 2 abc02 abconal
>
> table2 (review)
> ID CODE REVEIWER
> 1 smi01 abco2
>
> ***Query***
> table1 table2 table1_1
> CODE -------CODE
> SURNAME REVEIWER---CODE
> SURNAME
> SELECT reveiw.code, personel.surname, reveiw.reveiwer,
> personel_1.surname
> FROM personel INNER JOIN (reveiw INNER JOIN personel AS
> personel_1 ON reveiw.reveiwer = personel_1.code) ON
> personel.code = reveiw.code;
>
> query result desired
> CODE SURNAME REVEIWER SURNAME(of reviewer)
> smi01 smith abc02 abconal
>
>
> but I am getting
> CODE SURNAME REVEIWER-CODE SURNAME(of reviewer)
> smi01 abconal abc02 abconal
>
> as the surname field appears twice!
>
> Any help would be great
>

Top