posting data in an access database using forms
I have a big problem!!!
I have a form with 7 textboxes and four boxes must be
posted in the same field in a tabel in an Access database,
and the rest of 3 textboxes are common to all the records
that are posted.
How can I post this using fp?
is it posible?
if not please tell me how to do this some other way.
Thanks Tag: Frontpage 2002 Tag: 22440
MORTGAGE CALCULATORS
I'm looking for a m ortgage calculator I can add to FP,
any suggestions. Hopefully, it's also free.
Thanks,
Tony Tag: Frontpage 2002 Tag: 22437
Uploading an Online Quiz to my Web site.
Hey there!!
I purchased a download that allows me to create an online
quiz with multiple choice answers. The origin of the
program is from a company in Italy. Unfortunately, they
are on holiday leave until August 26th, which leaves me
in the dog house as far as technical support is
concerned.
The program only offers me the option of publishing
the "quiz" via "FTP". However, I do not use FTP protocol
when maintaining my site. I go into Microsoft Office
FrontPage 2003 (FrontPage 2002 upgrade test version)and
publish directly from there.
Is there any genius out there that can tell me (describe
a detailed procedure) how to upload the "quiz" I created
in "SmartLite WebQuiz XP"
http://www.smartlite.it/en2/products/webquiz/videotutorial
s.asp
into my site via Microsoft Office FrontPage 2003 without
using FTP protocol?
I really would appreciate your help, and if you help and
live in the Milwaukee area, I will buy you and your
family dinner at the restaurant of your choice.
Thanks a million!!!
Denny Tag: Frontpage 2002 Tag: 22404
DHTML Effect
I only find <choose an event> and page load options, no click, double click,
mouse over options. What should I do to get those options?
Thanks for your advice.
Andre T. Tag: Frontpage 2002 Tag: 22399
Pictures in Shared Border
I would like to have something like a slide show in a shared border - you
know, where the pictures change after a second or two. I can't seem to make
this happen. Suggestions?
Thanks in advance. Tag: Frontpage 2002 Tag: 22396
Implementing web page margins
I have FP 2002 and have not found a way to ensure that
the web page margins are the same for whomever is
attempting to print a page from my website. I am aware
of how to set up my PC's print preview setting and use it
to align the web page prior to a print job but this is
not the core fix. I have been receiving reports by people
that the right side of the page is not printing and
therefore, would like to remedy this.
My site is www.alabamahispanicassociation.org if needed
to view my problem when printing a page.
Thanks in advanced. Sam G Tag: Frontpage 2002 Tag: 22395
Using Marquees
The script in the marquees I created is backwards when I
view it in the browser! I didn't change any of the
properties other than the font colors. When I view the
page in a browser, the script is backwards and sometimes
scrambled together. Visit my site @ www.imlbsim.com and
see for yourself! This is very fustrating!! HELP! Tag: Frontpage 2002 Tag: 22392
Validation not working with some users
I have an online form and need to require uses to enter a
zip code, but some are not ending up on my database and
some are 4 digits etc.
It works fine for me, IM wondering if this is a problem
with different browser versions.
Here is the code im using:
;<!--webbot bot="Validation" s-display-name="zip_code" s-
data-type="Integer" s-number-separators="x" b-value-
required="TRUE" i-minimum-length="5" i-maximum-
length="10" --><input name="zip_code" size="5"
maxlength="10">
This is what is created when you select the validate
option within frontpage. Yet I still get empty and or 4
digit submissions....what do I do? Tag: Frontpage 2002 Tag: 22371
Linking FP to another program
When you click on a link in FP I would like it to add the
data under that link to another program. Is there a way
to do this?
Thanks
Chris Tag: Frontpage 2002 Tag: 22366
webbot include in FrontPage 2000 not working
Instead of including the files, which I verified are there
if get the syntax for the include file displayed. I've
asked my IM support to verify all Frontpage components are
properly installed and they say they are. Here is an
example of what I see on the search page I'm using IE 5.5
SP2 installed. The text between [ ] should be the links
for Content Post Search etc... which comes from the hdr
and footer files created when I used the Discussion Group
template Wizard to create this DG web inside a current
website already in place.
[_borders/_borders/RepairDiscussionGrp_head.htm]
SEARCH FOR ARTICLE
Find articles posted to this discussion containing
matching words or patterns.
[FrontPage Search Component]
[_borders/_borders/RepairDiscussionGrp_foot.htm]
SEARCH FOR ARTICLE
Find articles posted to this discussion containing
matching words or patterns.
Search for:
[_borders/_borders/RepairDiscussionGrp_head.htm]
SEARCH FOR ARTICLE
Find articles posted to this discussion containing
matching words or patterns.
[FrontPage Search Component]
[_borders/_borders/RepairDiscussionGrp_foot.htm] Tag: Frontpage 2002 Tag: 22365
FP2002 URL of error page
fp_rs.Update
FP_DumpError strErrorUrl, "Cannot update the database"
This appears to be the FP code that does the updage
(actually insert) for my FP form. The insert works fine
but if I enter the same data again, FP should detect a
duplicate primary key and display the "URL of error page"
but it does not. I am XP Pro, IIS 5.1 and Access 2002.
Even if I change the table name in the Access DB, I still
get the confirmation page.
What am I missing? Tag: Frontpage 2002 Tag: 22364
graphics locations don't update when published
when a site is published, the location of some graphics
does not update from the image folder on my computer to
the image folder on the server. The result is that the
graphic does not appear on the web. Any help would be
appreciated. Tag: Frontpage 2002 Tag: 22357
Help making this page pretty =)
Hi all,
I'm working on a small html project and i would appreciate some
suggestions on how to format this page to make it look nicer. I am new
to html design but what i have is some heading info and two tables. I
would appreciate any UI suggestions, thanks a bunch, oh and yes the
data is faked so nobody will get upset =)
My only constrains are that all the columns in the table line up on
the decimal point (thus the same decimal precision right margin
flushed) and the html report must fit on one page.
Thanks so much!
~Steven
<html>
<body>
<style type="text/css">
TABLE
{
FONT-SIZE: 12pt;
}
</style>
<title>bla bla bla</title>
<h2><center>Something Concentration</center></h2>
<h2><center>Flatulence Petroleum Unlimited (FPU)</center></h2>
<h3><center>Whew, now that's gas!</center></h3>
<p><p>
<table cellpadding="2" border="1" width="45%" align="center">
<tr><td></td><td></td></tr>
<tr><td>Date:</td><td>3/17/2003 9:34:31 AM</td></tr>
<tr><td>Operator:</td><td>AS</td></tr>
<tr><td>Method:</td><td>5186BPNA.M</td></tr>
<tr><td>Sequence Name:</td><td>C:\BERGER\1\SEQUENCE\AROMATIC.S
</td></tr>
</table><p><p>
<table cellpadding="2" border="2" align="center" width="55%">
<tr align=center><td></td><td>Retention
Time</td><td>Area</td><td>Weight Percent</td><td>Volume
Percent</td></tr>
<p><p>
<tr align=right><td
align="center">Saturates</td><td>1.647</td><td>230102.53125</td><td>76.881%</td><td>76.881%</td></tr>
<tr align=right><td align="center">Single Ring
Aromatics</td><td>2.352</td><td>59571.10547</td><td>19.904%</td><td>19.904%</td></tr>
<tr align=right><td
align="center">PNA</td><td>4.402</td><td>9625.15918</td><td>3.216%</td><td>3.216%</td></tr>
</table>
</body>
</html> Tag: Frontpage 2002 Tag: 22343
forms
good morning all...
I am making a form for my company's website and I have a question. The
form has a drop down menu with 107 choices (1 for each of our
locations). Here is the trick, we would like to have the email sent out
to someone different for each location. For Example - if a person wants
to work at store number 40, the email would go to that store, or if they
want to work at store 20 it goes there. After talking to a programmer
here, he said it would be possible to do this using DHTML, is this true?
And could you give me an example?
Thanks
Eric Rush
erush@qchek.com Tag: Frontpage 2002 Tag: 22341
FP 2000, Access 2000 & XP Pro
Have installed,
XP Pro
IIS 5.1
Access 2000
FP 2000
Have created a server based web, imported a newly created
database (and its connection) and tried creating a result
page using FP's wizard.
Initial results yielded column headings but no data.
Investigated MS Knowledgebase and found a few related
articles - i.e. 265323, 219159, 312638 - these solutions
did not help.
I used Windows Update and Office Update to update FP,
Access and XP. After completing the updats, reviewing the
result ASP page in the browser locked up the browser and
FP without any results displayed.
Repaired FP, same results.
Unistalled and reinstalled IIS, FP and Access. Again,
ended up with display of column headings but no data.
When checking the connection status of the database under
the DATABASE tab of the Web Settings, the database
connection checks out OK. When I select MODIFY-OK, I get
a question mark for the status. When I select VERIFY, the
green check mark re-appears.
Still, either I get column heads and no data, or the
program freezes.
For the last few years, I've been able to create the DB
connection and results page flawlessly with FP2000 under
Windows 98SE and PWS.
What am I missing in XP?
Thank you? Tag: Frontpage 2002 Tag: 22340
Playing MIDI sounds on ALL pages
I have been working on a webpage for the school I go to. I loaded in a MIDI
to play when the Index page opens, but as soon as someone clicks on one of
the bottons to go elseware on the site, the MIDI (of course) stops. When you
click the back botton, it starts over. Can I set ip up so that all the links
comming off the indax page open in a new window? (so that the Index page is
still open) and if it is still open will the music continue to play?
Any other ideas would be helpful.
Thanks Tag: Frontpage 2002 Tag: 22335
image sliding?
hey there
im creating my website, and i would like to make a slide
set of pics but i have no idea how to do this.
lets say i got seven pics, one beside each other
i would like to make a slide efect when the mouse is over
so the images would be sliding (no swaping to the next
one)
how can i do that?
i've seen it before....but i dont how if they used FP,
Macromedia or any other...
Please, let me know if you know the answer
tks
Arnoldo Tag: Frontpage 2002 Tag: 22333
Help! How do I get keyword phrase on each page?
Please help! I have my site up, but now I realize that I
need to change my title or keywords for each page. I have
an online clothing store, so each page is separated with
brands. I would like to rename each page/redo the page
title for each brand. Does anyone know how to do this? Any
help would be appriciated. Tag: Frontpage 2002 Tag: 22332
Frontpage extensions not installed
I wanted to know what I have to do to get FrontPage to be
able to see the Extensions after installing my verisign
certificate? After install I get the error that
extensions not installed
Thanks Joseph Tag: Frontpage 2002 Tag: 22331
asx generator?
Is there an automatic .asx generator available? I just rebuilt our media
server and all the wma's are there but I lost the asx's. I hate to think I
have to rewrite all of them by hand!
Maybe there is an ASP option someone is aware of that could list and
populate on demand??
Maybe?? Tag: Frontpage 2002 Tag: 22329
search box problem
I have successfully set up a search page that allows
visitors to search a database. The problem is if a user
inputs a search term such as "hat", results will appear.
But if a user enters "hats" adding the "s", no records
will be found. Is there a way that wildcards such
as "*hat*" could be used to allow for slight variations
so that something like "hats" would pull up similar
result as does "hat"? Tag: Frontpage 2002 Tag: 22328
banner on site
I have created a fantasy football web page and purchased a domain name
on the web. This has a link directing the url address to my bt account
thus allowing more than 1 web page of space.
http://www.nwccff.co.uk/
Is there anyway of removing the banner at top of page
Free domain check:
www. .com .co.uk .cn .net .info .org .org.uk .com.cn .net.cn .org.cn .biz
.us .me.uk .tv .cc .gs .ms .tc .vg .sh .ac .nu
showing the following.
Rgds Tag: Frontpage 2002 Tag: 22322
Menu buttons not loading
When I download my website, the menu buttons don't
download. I have done all the work in Frontpage. The site
is: http://oregonforfun.com/
Would you go to this site and look at the menu buttons for
Portland, Classifieds, etc and make suggestions?
Thanks for your help. Tag: Frontpage 2002 Tag: 22316
HELP!!!!
Hey there,
I am in DIRE need of some help. Do you know if there
might be a way to recover an accidentally deleted
page????? There is a log of it, I was just wondering if
it might have deleted it somewhere on my computer??
Unforunately, the page deleted was my INDEX! and I kinda
need it...ANY help you be great great great.
Thanks
Ben Tag: Frontpage 2002 Tag: 22315
FrontPage display issues
I created a website which works great on machines that the
display settings are set to 1024x768. If it is less the
full page does not show. Is there any way to set the
display for this site to show 1024 x 768 or do I need to
create the site using 800 x 600?
Help !!!!
Thank you Tag: Frontpage 2002 Tag: 22303
Error reading file FP2002
When I click on the HTML tab for my home page(index.html)I
get the following error: Error reading file.
Cannot open "wpe1.tmp": no such file or folder.
HTML view works on all the other pages. Web has been
published for 6+ months without any problems. I copied
source code from index.html from web server. created new
page, pasted to HTML view. Page worked OK. Can view HTML
without error.
Renamed old index.html and renamed newly created page to
index.html. I get the same error so it isn't in the page
HTML.
I have several other websites. I can open index.html in
them (HTML tab)without any problems so FP must be OK.
Has anyone had this problem? Any ideas on how to fix?
Thanks in advance for anyones help.
greatwebs Tag: Frontpage 2002 Tag: 22301
FrontPage 2002 Fails to Start
I am running Win 98 SE and FrontPage 2002. I just started
getting the message that Frontpage 2002 will not start, do
you want to send an error report. Then the offer to start
in safe mode, but that fails, then the offer to detect and
fix problems, that completes but Frontpage 2002 still will
not start. I even inserted the CD and reinstalled
Frontpage and it still will not start.
Has anyone seen this or have any suggestions?
Thanks.
Boz Tag: Frontpage 2002 Tag: 22300
The file " " is not found in the current web
I am not able to point to a folder as a hyperlink. If I point to a file
within that folder, the link works. Can anybody help me point to the folder
itself so the user can then pick which file to choose?
Thanks!!
--
Jeff Ciaccio
Dallas, GA
(W) 678-494-7863 x-274
(Fax) (W) 678-494-7865
http://mywpages.comcast.net/ciaccio8515 Tag: Frontpage 2002 Tag: 22299
publish using fp 2002
I have a web page called rcasco.com and when I try
to update and re-publish a page I get an error.
frontpage asks me to enter my web page address and
then says it does not exist.
Thanks for any help.
Robert Casavant
Rcaszzz@Cs.com
845 331 8716 Tag: Frontpage 2002 Tag: 22297
text box Java Link
I would like to make an entry text box on the shared left
border of my site that allows my customers to enter in a
specific code I give them. When they enter in the 6 digit
code, they immediately go to the specific page that I
made for them. Only by submitting the code can they see
the information on the page I made for them.
How do I make this text box and this button that will
link to the page that I made for a specific code?
I tried the Java Code below, but I could not get it to
work:
<form>
<input type="text" name="page" >
<input type="submit" onclick="window.location =
this.form.page.value +
'.htm'; " >
</form>
I inserted the html above, and I enter in the code to go
to the page I want, but I always stay at the same page,
and the address bar say,
"file:///C:/Documents%20and%20Settings/Owner/My%
20Documents/My%20Webs/buttom_link.htm?page=1234567"
I need to make some modifications to the code, but I
don't know what to do, and the stuff I have tried doesn't
work. Please help.
I want the code to take me to a location that is under a
subweb folder.
start: http://www.sulleri.com/button_link.htm
enter in code ==> 1234567
finish: http://www.sulleri.com/retailers/1234567.htm
Thanks
Joe Tag: Frontpage 2002 Tag: 22291
buffer on one side only of picture
Is there a way to say "leave a buffer of x amount on the
right side of a picture" rather than "Leave a horizontal
buffer of x amount on both sides of a picture"?
I end up wasting so much space if, for instance, I want a
picture in the left corner but a buffer on the right of
the picture. Can't figure out how to avoid space on the
left side too in that case. Thanks! Tag: Frontpage 2002 Tag: 22283
FP 2000 DRW can I change the labels?
Hello
I'm hoping someone can help.
I want to create a web directory.
I am used to working with FrontPage 2000 and Access 2000.
Before I start this new project I would just like to clarify a few points;
1) When you visit a search engine or directory the results
are always listed something like this;
Result Pages: [ 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 ] >>
FP 2000 does not display the results in this fashion.
I have listed the FP code below for the page that shows "navigational control".
As you will see it is slightly different from the norm, because someone about a
year ago helped me change it from the frontpage client group.
But it still doesn't look very professional - want I would like is each record
to be calculated - something like:
Record 1 of 350
Result Pages: [ 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 ] >>
Instead of dividing the records into how many pages have been returned.
Am I making sense?
The file that holds the code is: fpdbrgn1.inc
Also
2) What is the maximum Access 2000 can take on concurrent hits?
2) My host says I can upgrade to Microsoft SQL - Will I have to change
my Tables or anything around, and will I have to have any specialised
knowledge?
Thank you in advance - Stephen
fpdbrgn1.inc
<%
' determine whether or not to provide navigation controls
if fp_iPageSize > 0 then
fp_fShowNavbar = True
else
fp_fShowNavbar = False
end if
fp_sPagePath = Request.ServerVariables("PATH_INFO")
fp_sEnvKey = fp_sPagePath & "#fpdbr_" & fp_iRegion
fp_sFormName = "fpdbr_" & CStr(fp_iRegion)
fp_sFormKey = fp_sFormName & "_PagingMove"
fp_sInputs = fp_sDefault
fp_sFirstLabel = "[first 5]"
fp_sPrevLabel = "[previous 5]"
fp_sNextLabel = "[next 5]"
fp_sLastLabel = "[last 5]"
fp_sDashLabel = "[ 0 ]"
if not IsEmpty(Request(fp_sFormKey)) then
fp_sMoveType = Request(fp_sFormKey)
else
fp_sMoveType = ""
end if
fp_iCurrent=1
fp_fError=False
fp_bBlankField=False
Set fp_dictInputs = Server.CreateObject("Scripting.Dictionary")
fp_sQry = FP_ReplaceQuoteChars(fp_sQry)
' replace any input parameters in query string
Do While (Not fp_fError) And (InStr(fp_iCurrent, fp_sQry, "::") <> 0)
' found a opening quote, find the close quote
fp_iStart = InStr(fp_iCurrent, fp_sQry, "::")
fp_iEnd = InStr(fp_iStart + 2, fp_sQry, "::")
If fp_iEnd = 0 Then
fp_fError = True
Response.Write "<B>Database Results Error: mismatched parameter
delimiters</B>"
Else
fp_sField = Mid(fp_sQry, fp_iStart + 2, fp_iEnd - fp_iStart - 2)
fp_sValue = Request.Form(fp_sField)
if len(fp_sValue) = 0 then fp_sValue = Request.QueryString(fp_sField)
' if the named form field doesn't exist, make a note of it
If (len(fp_sValue) = 0) Then
fp_iStartField = InStr(fp_sDefault, fp_sField & "=")
if fp_iStartField > 0 then
fp_iStartField = fp_iStartField + len(fp_sField) + 1
fp_iEndField = InStr(fp_iStartField,fp_sDefault,"&")
if fp_iEndField > 0 then
fp_sValue = Mid(fp_sDefault,fp_iStartField,fp_iEndField - fp_iStartField)
else
fp_sValue = Mid(fp_sDefault,fp_iStartField)
end if
end if
End If
' remember names and values used in query
if not fp_dictInputs.Exists(fp_sField) then
fp_dictInputs.Add fp_sField, fp_sValue
end if
' this next finds the named form field value, and substitutes in
' doubled single-quotes for all single quotes in the literal value
' so that SQL doesn't get confused by seeing unpaired single-quotes
If (Mid(fp_sQry, fp_iStart - 1, 1) = """") Then
fp_sValue = Replace(fp_sValue, """", """""")
ElseIf (Mid(fp_sQry, fp_iStart - 1, 1) = "'") Then
fp_sValue = Replace(fp_sValue, "'", "''")
End If
If (len(fp_sValue) = 0) Then fp_bBlankField = True
fp_sQry = Left(fp_sQry, fp_iStart - 1) & fp_sValue & Right(fp_sQry,
Len(fp_sQry) - fp_iEnd - 1)
' Fixup the new current position to be after the substituted value
fp_iCurrent = fp_iStart + Len(fp_sValue)
End If
Loop
' establish connection
If Not fp_fError Then
if Application(fp_sDataConn & "_ConnectionString") = "" then
Err.Description = "The database connection named '" & fp_sDataConn & "' is
undefined.<br><br>"
Err.Description = Err.Description & "This problem can occur if:<br>"
Err.Description = Err.Description & "* the connection has been removed from
the web<br>"
Err.Description = Err.Description & "* the file 'global.asa' is missing or
contains errors<br>"
Err.Description = Err.Description & "* the root folder does not have Scripting
permissions enabled<br>"
Err.Description = Err.Description & "* the web is not marked as an Application
Root<br>"
fp_fError = True
end if
if Not fp_fError then
set fp_conn = Server.CreateObject("ADODB.Connection")
fp_conn.ConnectionTimeout = Application(fp_sDataConn & "_ConnectionTimeout")
fp_conn.CommandTimeout = Application(fp_sDataConn & "_CommandTimeout")
fp_sConn = Application(fp_sDataConn & "_ConnectionString")
fp_sUid = Application(fp_sDataConn & "_RuntimeUserName")
fp_sPwd = Application(fp_sDataConn & "_RuntimePassword")
Err.Clear
FP_OpenConnection fp_conn, fp_sConn, fp_sUid, fp_sPwd, Not(fp_fCustomQuery)
if Err.Description <> "" then fp_fError = True
end if
if Not fp_fError then
set fp_cmd = Server.CreateObject("ADODB.Command")
fp_cmd.CommandText = fp_sQry
fp_cmd.CommandType = fp_iCommandType
set fp_cmd.ActiveConnection = fp_conn
set fp_rs = Server.CreateObject("ADODB.Recordset")
set fp_rs.Source = fp_cmd
If fp_iCommandType = 4 Then
fp_cmd.Parameters.Refresh
Do Until Len(fp_sInputs) = 0
fp_iLoc = InStr(fp_sInputs,"=")
if fp_iLoc = 0 then exit do
fp_sKey = Left(fp_sInputs,fp_iLoc - 1)
fp_sInputs = Mid(fp_sInputs,fp_iLoc + 1)
fp_iLoc = InStr(fp_sInputs,"&")
if fp_iLoc = 0 then
fp_sInpVal = fp_sInputs
fp_sInputs = ""
else
fp_sInpVal = Left(fp_sInputs,fp_iLoc - 1)
fp_sInputs = Mid(fp_sInputs,fp_iLoc + 1)
end if
fp_sVal = Request.Form(fp_sKey)
if len(fp_sVal) = 0 then fp_sVal = Request.QueryString(fp_sKey)
if len(fp_sVal) = 0 then fp_sVal = fp_sInpVal
fp_pType = fp_cmd.Parameters(fp_sKey).Type
select case fp_pType
case 129, 200, 201, 130, 202, 203 ' adChar, adVarChar, adLongVarChar,
adWChar, adVarWChar, adLongVarWChar
fp_cmd.Parameters(fp_sKey).Size = Len(fp_sVal) + 1
case else
' do nothing
end select
' remember names and values used in query
if not fp_dictInputs.Exists(fp_sKey) then
fp_dictInputs.Add fp_sKey, fp_sVal
end if
fp_cmd.Parameters(fp_sKey) = fp_sVal
Loop
End If
If fp_iMaxRecords <> 0 Then fp_rs.MaxRecords = fp_iMaxRecords
FP_SetCursorProperties(fp_rs)
FP_OpenRecordset(fp_rs)
end if
If Err.Description <> "" Then
if fp_fTableFormat then
Response.Write "<tr><td colspan=" & fp_iDisplayCols & " color=#000000
bgcolor=#ffff00>"
end if
Response.Write "<tt>"
Response.Write "<b>Database Results Error</b><br>"
if Not fp_fError then
Response.Write "<i>Description:</i> " & Err.Description & "<br>"
Response.Write "<i>Number:</i> " & Err.Number & " (0x" & Hex(Err.Number) &
")<br>"
Response.Write "<i>Source:</i> " & Err.Source & "<br>"
else
Response.Write Err.Description
end if
if fp_bBlankField Then
Response.Write "<br>One or more form fields were empty."
Response.Write " You should provide default values for all form fields that
are used in the query."
End If
Response.Write "</tt>"
if fp_fTableFormat then
Response.Write "</td></tr>"
end if
fp_fError = True
Else
' Check for the no-record case
if fp_rs.State <> 1 then
fp_fError = True
Response.Write fp_sNoRecords
ElseIf fp_rs.EOF And fp_rs.BOF Then
fp_fError = True
Response.Write fp_sNoRecords
end if
end if
end if
' determine whether or not provider supports Absolute Positioning
if not fp_fError then
if IsObject(fp_rs) and not(fp_rs.Supports(&H00004000)) then
fp_iPageSize = 0
fp_fShowNavbar = False
end if
end if
' move to correct position in result set
if not fp_fError then
if fp_iPageSize > 0 then
fp_iAbsPage = 1
fp_sVal = Session(fp_sEnvKey)
if fp_sVal <> "" then
fp_iAbsPage = CInt(fp_sVal)
end if
fp_rs.PageSize = fp_iPageSize
if fp_iAbsPage > fp_rs.PageCount then fp_iAbsPage = fp_rs.PageCount
fp_rs.AbsolutePage = fp_iAbsPage
if fp_rs.PageCount = 1 then fp_fShowNavbar = False
select case fp_sMoveType
case ""
' do nothing
case fp_sFirstLabel
fp_rs.AbsolutePage = 1
case fp_sPrevLabel
if fp_rs.AbsolutePage > 1 then fp_rs.AbsolutePage = fp_rs.AbsolutePage - 1
case fp_sNextLabel
if fp_rs.AbsolutePage < fp_rs.PageCount then fp_rs.AbsolutePage =
fp_rs.AbsolutePage + 1
case fp_sLastLabel
fp_rs.AbsolutePage = fp_rs.PageCount
case else
' do nothing
end select
fp_iAbsPage = fp_rs.AbsolutePage
Session(fp_sEnvKey) = fp_iAbsPage
end if
end if
if fp_fError then fp_fShowNavbar = False
fp_iCount = 0
Do
if fp_fError then exit do
if fp_rs.EOF then exit do
if fp_iPageSize > 0 And fp_iCount >= fp_rs.PageSize then exit do
if fp_iMaxRecords > 0 And fp_iCount >= fp_iMaxRecords then
' MaxRecords didn't work; exit loop
fp_fShowNavbar = False
exit do
end if
%> Tag: Frontpage 2002 Tag: 22274
Format for AUTORUN.INF
FrontPage 2002 - Windows XP Professional
I wish to make a disk-based web to distribute on CD.
How do I make an AUTORUN CD which holds my disk-based web
and starts automatically under Internet Explorer when the
CD is inserted?
I've created a file called AUTORUN.INF which contains
OPEN=INTRODUCTION.HTM (plus the Icon name; the Icon seems
to work).
(1) When I insert the CD it blinks a little and quits.
(2) When I double-click the CD icon in My Computer
Windows XP complains that INTRODUCTION.HTM is not a
legitimate application.
(3) When I explore the CD and double-click
INTRODUCTION.HTM myself the disk-based web starts up and
runs great. How do I get this to happen when I simply
insert the CD?
Thanks much for any help.
Ed W Tag: Frontpage 2002 Tag: 22271
disable image toolbar in IE 6
OK, I am now using the java script to prevent right click
to help prevent people for copying pictures from my site.
Now however I noticed on IE 6 their is a image toolbar
that gives the choice to print, save, email. Can this
feature be disabled from within my website ?
Thanks Again
Jeff Tag: Frontpage 2002 Tag: 22249
Earn $500 to $700 per Week Downloading FREE Software
We know it sounds TOO good to BE true, but it?s REAL! Our International Technology firm will pay you hard cash each time FREE software is downloaded. Best of all you will only have to download ONE piece of software ONE time for FREE and you can be on your way to earning BIG!
FIND OUT MORE BY VISITING
http://JeromeMcCrea.PlugUsIn4Cash.com Tag: Frontpage 2002 Tag: 22245
2 probs - DHTML & shared borders
My stats - FP 2000, Earthlink hosting w/ FP server
extensions installed www.stevegibb.com, viewing on IE 5.5
My two problems:
1- I have DHTML FX programmed onto pictures of the
homepage. I did one several months ago & that one works.
Others I added today in the same manner & they do not
work. How can I fix?
2 - I have shared borders (bottom) selected and written
for all pages. They show up in Normal and Preview of FP,
but do not show on the published pages. I have tried
recalculating hyperlinks and republishing as suggested by
others, but they still are not there. I have also asked
Earthlink to re-install my Server Extensions in case of an
error there.
Please help! I am tearing my hair out. Tag: Frontpage 2002 Tag: 22243
Framesets with Shared Borders ?
Can Framesets coexist with Shared Borders on the same page?
I want to display two horizontal frames in the 'body of a page ...
... with top an left shared borders containing menus, graphic links etc
If so, can anyone point me at an example.
Brian Tag: Frontpage 2002 Tag: 22238
Stalls during Insert Hyperlink
Hi,
FYI: FrontPage 2002 on a new Windows pc running XP.
Recently I've started getting a FrontPage Not Responding
message when I try to copy a url into the Insert
Hyperlink box. It happens about 50% of the time. I get an
hour-glass that won't go away. I need to either restart
my computer or occasionally shut off my computer to be
able to access FP again.
It happens on three different computers using different
copies of FrontPage 2002 software. My ISP reinstalled the
FP Extensions but the problem remains.
I've used FP since 1998 and have never had this problem
before.
Thanks for the help,
MJM Tag: Frontpage 2002 Tag: 22232
Frontpage Security
I am attempting to restrict access to a page on my
website, but the function "security" under "tools" is
grayed out. Any suggestions? Tag: Frontpage 2002 Tag: 22231
Linking FP to another program
When you click on a link in FP I would like it to add the
data under that link to another program. Is there a way
to do this?
Thanks
Chris Tag: Frontpage 2002 Tag: 22228
Text size varies
Text is consistently cut and pasted from MS Word 2002 to a
Frontpage 2002 page. When viewed in IE default text size it
does not change point size but if you change the text size
in IE to smaller or larger the text size varies from
paragraph to paragraph. What am I doing wrong in Frontpage
2002 that is causing this problem. Tag: Frontpage 2002 Tag: 22224
Inserting files
When I insert a Word.doc or Word.htm file on a new page in
FrontPage, the formatting changes, even though supposedly
it shouldn't--the spacing changes. Does anyone know how
to insert files and have them retain the look they have in
WORD? This is for FrontPage 2000. Tag: Frontpage 2002 Tag: 22215
Database access problems...more info from last post
I reported earlier not being able to access Frontpage's
database functions. Evidently, there is a problem with
the ODBC library. I received this message:
Server error: The Open Database Connectivity (ODBC)
library is not available on the Web server.
Another message: No acceptable external database drivers
were located. You will be unable to continue.
I'm using FrontPage 2002 with Windows XP Home. I've
checked my installation components and don't think I'm
missing anything. Any ideas on how to fix this?
Thank you. Tag: Frontpage 2002 Tag: 22214
How do I put Access 2000 reports onto a web site
I have a database with complex reports (graphs, boxes and lines, subforms,
etc) which users want to run, convert into something usable on the web and
put on a web site.
They don't want the database on the web yet (later on this year - that's
another project I will need help with then) but they want to select
parameters, generate reports, then put the reports on the web site. Or even
better, have the web site look at the database, choose the paramteres, and
create the reports on the fly.
The critical part is that they HAVE to look the same as they do now.
How can this be done!
(Sorry about posts to multiple NGs, not sure who would have the info I
need!)
Thanks,
Mich Tag: Frontpage 2002 Tag: 22213
FrontPage won't let me access database functions.
I am trying to link my website to an access database
file, but seem to have some problem. When I got to
access the database selection from the menu bar (from
Insert), it is not highlighted. I've checked my
installed components and everything seems okay. However,
FrontPage won't let me use the Database Integration
Wizard and I can't access any Database functions from
within Frontpage. Tag: Frontpage 2002 Tag: 22211
Ok..
Thank you Mike
your right, it will be kindda expensive to implement
something that complicated, beside my knowledge on
webdesign is not that great.
So i guees i will use the table you told me about with the
hotspots (i've read about them, never use them before, i
mean on my own page)
i do appreciate your help !
SOME1 Tag: Frontpage 2002 Tag: 22194
What generalmoters said after reading these groups
JUST ABIT OF LIGHT ENTERTAINMENT (HOPE NO ONE MINDS)
GM's response to Bill Gates comments ..Just for a laugh......
For all of us who feel only the deepest love and affection for the way
computers have enhanced our lives, read on. At a recent computer expo
COMDEX), Bill Gates reportedly compared the computer industry with the auto
industry and stated;
"If GM had kept up with the technology like the computer industry has, we
would all be driving $25.00 cars that got 1,000 miles to the gallon."
In response to Bill's comments, General Motors issued a press release
stating:
If GM had developed technology like Microsoft, we would all be driving cars
with the following characteristics:
1.. For no reason whatsoever, your car would crash twice a day.
2.. Every time they repainted the lines in the road, you would have to buy
a new car.
3.. Occasionally your car would die on the freeway for no reason. You
would have to pull over to the side of the road, close all of the windows,
shut off the car, restart it, and reopen the windows before you could
continue. For some reason you would simply accept this.
4.. Occasionally, executing a manoeuvre such as a left turn would cause
your car to shut down and refuse to restart, in which case you would have to
reinstall the engine.
5.. Macintosh would make a car that was powered by the sun, was reliable,
five times as fast and twice as easy to drive but would run on only five
percent of the roads.
6.. The oil, water temperature, and alternator warning lights would all be
replaced by a single "This Car Has Performed An Illegal Operation" warning
light.
7.. The airbag system would ask "Are you sure?" before deploying.
8.. Occasionally, for no reason whatsoever, your car would lock you out
and refuse to let you in until you simultaneously lifted the door handle,
turned the key and grabbed hold of the radio antenna.
9.. Every time a new car was introduced car buyers would have to learn how
to
drive all over again, because none of the controls would operate in the
same manner as the old car.
10.. You'd have to press the "Start" button to turn the engine off. And if
you couldn't turn it off, you would have to, close all of the windows,
reopen the windows. Then turn it off. Tag: Frontpage 2002 Tag: 22193
login page
Is there a simple way of building a login page where users
have to enter a simple password (delivered to them by
email) before proceeding to the next page? Is there
parhaps a way of making a form field require a specific
word entry before alowing the return button to take the
user to the hyperlink?
Thanks
David Tag: Frontpage 2002 Tag: 22191
I have a problem with Frontpage 2002 - When I view my Web
Page in the Browser mode the fonts are alot larger than in
the design mode. What causes this?
Check your browser settings under View>Text Size and set to Medium..
xmas
www.xmas-i-am.com
===================
"Bill" <Bill@jjminv.com> wrote in message
news:0d9801c36658$7fa3c3e0$a401280a@phx.gbl...
> I have a problem with Frontpage 2002 - When I view my Web
> Page in the Browser mode the fonts are alot larger than in
> the design mode. What causes this?