Database hyperlink
Hi,
I am wondering if anyone can help.
I have set up a database from and results page using access.
I can get the results back from the database. In the database i have set it
up so the link url is not shown it just display "click here"
When it comes up in the results page of FrontPage the url is shown instead
of click here,
Is there anyway to have it displayed as click here in stead of the url
All help would be greatly appreciated.
Paul
--
paul@www.omachx.com Tag: Images don't appear in Frontpage Tag: 71221
Please help with If Then Else code
I cannot get these 'if then else response.write' codes to work can
someone please help
The database, I have two tables (relationship)
contactTBL (one) and membershipTBL (many)
contactTBL - primary key - contactID
membershipTBL - foreign key - contactID
All I want to do is set up a statement that returns a response.write
"no memberhsip on file" if contactID is not in the membershipTBL - ie
if the person has no membership, then their 'contactID' would not
appear in the membershipTBL, and I would like to tell them when they
login that 'You dont have any membership'
Here is some code that may help, the site is protected by the
contactID set as CID:
<%Your_Name = request.cookies("remain")%>
<%Date_In = request.cookies("still")%>
<%CID = request.cookies("CID")%>
<%If request.cookies("remain") = "" then response.redirect
("login.html")%>
<%Dim MyLogin
Set MyLogin = Server.CreateObject("ADODB.Connection")
ConnStr = "DRIVER={Microsoft Access Driver (*.mdb)}; "
ConnStr = ConnStr & "DBQ=" & Server.MapPath("..\fpdb\aata.mdb")
MyLogin.Open(ConnStr)
%>
</html>
<body>
<%dim oRS
Set oRS= MyLogin.execute("Select * From membership_TBL WHERE
contactID=" & CID & "")%>
<%If oRS.EOF = " " AND oRS.BOF = " " then response.write "You have no
membership"%>
--
The error is ADODB.Field error '80020009'
Either BOF or EOF is True, or the current record has been deleted.
Requested operation requires a current record
Note there is another connection above this in the code to another
table in the database, that code is:
<%Dim RS
Set RS = MyLogin.execute("SELECT * FROM contactTBL WHERE contactID=" &
CID & "")
%>
Welcome, <%=Your_Name%>
Thanks in Advance
Rob Tag: Images don't appear in Frontpage Tag: 71216
Passing special characters through form
I have a simple form with a text field that my users copy and paste into.
Sometimes the text contains special Spanish characters. And sometimes these
characters are passed along with the form post and sometimes they are not.
When they are not passed along, those characters are just omitted from the
text string. What controls the passing along of special characters? Tag: Images don't appear in Frontpage Tag: 71213
inserting hyperlink fp2000
I now have a problem when hyperlinking with FP200 in Vista Home it gives me a
error and closes FP2000. It says:
problem signature:
Problem Event Name: APPCRASH
Application Name: FRONTPG.EXE
Application Version: 11.0.6552.0
Application Timestamp: 424b714f
Fault Module Name: ntdll.dll
Fault Module Version: 6.0.6000.16386
Fault Module Timestamp: 4549bdc9
Exception Code: c0000005
Exception Offset: 000671ee
OS Version: 6.0.6000.2.0.0.768.3
Locale ID: 1033
Additional information about the problem:
LCID: 1033
Brand: Office11Crash
skulcid: 1033
Read our privacy statement:
http://go.microsoft.com/fwlink/?linkid=50163&clcid=0x0409
about got any suggestions?????
thanks
mug Tag: Images don't appear in Frontpage Tag: 71208
Can I develop a site for a Mac user using MS Frontpage 2003?
The client wants me to build him a site. He'll then want to update it as
needed (content only). How could he do that from his Macintosh, if I develop
the site using MS Frontpage 2003? If he were a Windows user, I'd send him
the Frontpage files when I completed the site and let him use Frontpage to
publish his changes to the webhost. I'm assuming that is not an option since
he has a Mac computer.
Any suggestions would be appreciated.
Thanks!
--
Kelly Tag: Images don't appear in Frontpage Tag: 71204
css issues
Are there any known reasons why my css would affect the appearance of
my pages in design mode but no when it's published? Tag: Images don't appear in Frontpage Tag: 71191
bookmark page - image button
I want visitors to my site to be able to click a small image button
(custom) to create a bookmark or favorite. What code should i use for
this? Tag: Images don't appear in Frontpage Tag: 71190
can't find largest database record
I am using the following code to find the largest record number in a
database. I have an include file that handles getting the database open.
The "ordernumber" column of the database is sorted in ascending order. This
only gets to 1.
<%
DIM mySQL, iRecordCount, iRC
iRC = 1
mySQL = "SELECT * FROM Results"
objRS.Open mySQL, objConn
DO WHILE NOT objRS.EOF
if cStr(iRC) = objRS("OrderNumber") then
iRC = iRC + 1
Response.Write ">> IRC= " & iRC & "<<"
objRS.MoveNext
else
Exit Do
end if
Loop
iRecordCount = cStr(iRC)
objRS.Close
Set objRS = Nothing
objConn.Close
Set objConn = Nothing
%>
--
Dave Lagergren
Manager - Data Applications
Wireless Management, Inc
Specializing in cellular wireless applications Tag: Images don't appear in Frontpage Tag: 71189
Finding next "ordernumber" in database
I have a database where I store orders. One order may have multiple records.
Because of this I cannot use the "Key" to assign order numbers. I have a
column "OrderNumber" that needs to increment with each new order. I was
thinking of storing the last assigned OrderNumber in the first record but was
wondering if there was an easier, cleaner way to do this? Possibly looping
through the records to find the highest OrderNumber?
--
Dave Lagergren
Manager - Data Applications
Wireless Management, Inc
Specializing in cellular wireless applications Tag: Images don't appear in Frontpage Tag: 71183
Inserting Hyperlinks
i want to add a hyperlink to a word but i dont want the hyperlink link effect
for example having a different colour and underline. i want the word to stay
the normal colour and has rollvoer effect but should not change its original
colour Tag: Images don't appear in Frontpage Tag: 71180
How may I add an external page?
Hi Folks!
I am a real newbie user of the FP2002. I have regularly used the commands
â??include fileâ?? and â??include virtualâ?? successfully in the site of my family's
surname.
Now I need to include in one of my pages an webpage of another site (with
author's permission, of course).
I donâ??t know if this is possible, but I would really appreciate it if
someone could help me on what to do!
Thanks!
--------------------------------------------
http://www.scartezini.com/family Tag: Images don't appear in Frontpage Tag: 71175
Cannot close service.cnf
FP2003
I have not updated this web site in 5-6 months. I updated a photograph
today and when I tried to publish I got the error:
Server errorCannot close file: "service.cnf"
I checked the MS archives and found article 301466 which says it is a server
space issue at the service provider.
I logged on to the ISP and there is more than 500 MB available.
It must be some other issue but I am not able to locate what it might be.
Any guidance would be appreciated.
TIA, GWB Tag: Images don't appear in Frontpage Tag: 71171
select all multiple-select box
i would like to select all cases in a multiple select box by checking a check
box.
does anyone have any ideas?
thanks Tag: Images don't appear in Frontpage Tag: 71167
Import again
Using FP 2003
I published a site about a year ago and had a disk crash since. The backup
was only partially readable.
I need to download the site to my disk drive again and cannot find my cheat
sheet instructions. I remember doing this in the past and ending up with
missing links, images and menu errors. The structure was destroyed in the
meantime.
Someone was kind enough to provide instructions for how this should be done
correctly but I cannot find them. It involved making a directory and
publishing to the new directory from the internet site and the page to page
menus were intact.
If someone would give me the instructions I would try to make sure I keep
them in a safe place this time.
Thanks, GWB Tag: Images don't appear in Frontpage Tag: 71165
aligning a table
Hi,
Apologies but I am a newbie.
I have a table. In one of the cells I have inserted another table (I
can hear the groans already!). The problem is that this second table
needs to be aligned to the top of the cell in which it sits.
May I ask, how exactly can this be achieved? I should imagine that
align="top" needs to be inserted somewhere but where and how exactly.
Remember, I'm a newbie!
Thanks,
Tony Tag: Images don't appear in Frontpage Tag: 71161
Image Swap Issues
i'm programming a site that will have a behavior function on an image
(image swap). The tricky part is that the swapped image is a
different size than the original. When I use the preview feature in
FP2003 it looks great, however on the published site it keeps the
images the same dimension.
Here's the swap code sample:
<img border="0" src="images/IconNavigation/IconMasters/
IconNavigation_01.gif" id="img11" onmouseout="FP_swapImgRestore()"
onmouseover="FP_swapImg(1,1,/*id*/'img11',/*url*/'images/
IconNavigation/IconRollover/IconRoll_01.gif')">
You can see the "width" and "height" tags have been removed. When I
removed these it started working in the preview, however it's still
not working in the live version
I've tested in FireFox, IE7, and Safari.
Any Ideas???? Tag: Images don't appear in Frontpage Tag: 71159
timed events
Is ther a way to have a 2nd page autoload after a specified number of seconds
after hyperlinking to a 1st page? Tag: Images don't appear in Frontpage Tag: 71148
google fonts to0 large, overlapping
I just set up my mom's laptop with the google homepage. The font is
EXTREMELY large and overlaps. I've never had this happen on any other
computer ever! Even the different sections on the page overlap. What
is this and how do I fix it? It's Windows XP, the igoogle homepage. Tag: Images don't appear in Frontpage Tag: 71144
google fonts to0 large, overlapping
I just set up my mom's laptop with the google homepage. The font is
EXTREMELY large and overlaps. I've never had this happen on any other
computer ever! Even the different sections on the page overlap. What
is this and how do I fix it? It's Windows XP, the igoogle homepage. Tag: Images don't appear in Frontpage Tag: 71143
Is There A FrontPage For Vista?
I just bought a new computer that uses Vista. Is there a FrontPage that will
work with Vista? Or can I use my FrontPage 2002 disc? Tag: Images don't appear in Frontpage Tag: 71137
Proxy settings
I have a site that is hosted by a company who seem to have some connection
issues. Sometimes I am able to publish the site with no problems, but
sometimes it comes up with the following message and I can't even get in to
type my user name and password. Is there anything I can do at my end? Or is
this something the host needs to sort out for me? I do use my pc at work so
whether that has anything to do with or not, I don't know. Tag: Images don't appear in Frontpage Tag: 71130
need to create a new style.htm
I've been fighting it out with IE7 and my DHTML pop-out menu (left
shared border). This works fine in FireFox and IE6 ... but in IE7 it's
down to like a 5px width. When looking at the source for any page, you
can see a specific td width of 1% - apparently coming from style, but
I'm not 1000% sure of that. Anyway, I can't see the offending TD as it
is part of a <!---msnavigation snippet.
I guess my main question is how can I create a NEW style.htm page that
won't chop my DHTML menu?
We have 2 websites and it works FINE on the 2nd site
([url]www.theartistsdepot.com[/url]) but does not at all work on the
1st site ([url]www.tankersleywest.com[/url]).
I'm not sure if the culprit is the style.htm but have ruled out almost
everything else. There is no setting in the DHTML menu creator that
gives you the option to set a width of 1% - I can set an overall width,
which is around 200px.
Thanks for any insight you can provide.
J. Tankersley
--
blndvmpyr
------------------------------------------------------------------------
Posted via http://www.codecomments.com
------------------------------------------------------------------------ Tag: Images don't appear in Frontpage Tag: 71129
display file directories
how to display a directory list from a button (or other control), so that
users can download files? Tag: Images don't appear in Frontpage Tag: 71128
Expression web via Front page
I'm thinking of upgrading my copy of FP 2003 to Expression Web (2007). What
are the advantages of the newer version if any? Tag: Images don't appear in Frontpage Tag: 71117
frames inside iframe
Hello.
I've posted this question at four different forums (three at microsoft
office sharepoint discussions) and no one has replied.
I'm using Sharepoint 2003 and want to display a page with frames in a page
using a Page Viewer Webpart (I looked at the source and it's just <iframe>).
When I use the Page Viewer to display a page with no frames, it displays
fine. I get errors when I put in a url for a page with frames.
I was thinkin maybe I can't display frames inside iframe so...using
frontpage 2002...I made a new page, put in a url for a page with frames to be
displayed with the iframe and had errors again. Page with no frames
displayed fine.
Anyone have any ideas?
I will try it again and copy the error...and post again...
Thank you for your time. Tag: Images don't appear in Frontpage Tag: 71115
upgraded to Office 2007 standard. Front Page 2000 doesn't work
We just upgraded the wife's computer to office 2007. Front Page gives an
error now when trying to update the site she works on. There isn't an error
message per sey, but when the error report is sent to Microsoft, the detail
information says that it's mso9.dll (Office 2000 is mso9). I uninstalled and
reinstalled Front Page, but I still get the same error. I know it's in her
computer because I was able to update her site from my computer. Does anyone
know of a fix or work-around, to get FP 2000 to work with Office 2007
standard.
Thanks,
Joe
elswick_j@bellsouth.net Tag: Images don't appear in Frontpage Tag: 71114
Text and Pictures Not Correct
Why is my pictures jumping around and my font not showing up the same
as I have setup in Frontpage?
I have nimbus script setup for my font in frontpage and it looks fine
in my web browser when I upload.
When I look at the site at another computer the font has changed to I
think Times New Roman and it looks like complete junk
Can anyone explain why this is happening and / or how I can correct
it??????
All helps is greatly appreciated Tag: Images don't appear in Frontpage Tag: 71113
FP 2000 Password Permissions
I am trying to design my web so only club members have access. My hosting
service is GoDaddy and I have shared Windows hosting. I've followed the
instructions to created a subweb and I have appropriate security access. My
problem comes when I go to add the users. When I click on Tools -- Security
-- and go to add users, there is one entry in the "Obtain list from"
box...something called "P3SWxxxx". Where is this list and how do I add users
to it? Godaddy is no help; their technical support says it is somewhere in
FrontPage and they don't support that. Do I add users to the mysterious
P3SWxxx list or do I create a new list....and how does one do that? Many
thanks for any light you can shed on how to get individual users set up!
--
Helen Tag: Images don't appear in Frontpage Tag: 71112
Automate Changes to Form Properties
A few weeks ago I changed my User Feedback form. It is an .Asp file and
during the process, I saved the old form as User_feedback(Old).Asp and the
new form is User Feedback.Asp. When I did these changes, I verified that
the User Feedback button on my page banners all worked correctly.
Today I notice (I had forgotten about them) that I have a User Feeback form
button on each on many of my pages. When I pressed one of those I got the
web page is not available message.
When right click the form button, select "Form Propteries", click on
Options, I see that the Action setting is User_Feedback (Old).Asp. I can
change this to User Feedback.Asp. Save the page, publish and the button
works correctly.
I have 50 or 60 pages that I need to update. I don't know anything about
FrontPage macros. In Word I would use something like:
For Each Page in My Website
For Each FormButton In Page.FormButtons
If FormButton.Name = "User FeedBack" Then
FormButton.Options.Action = "User Feedback.Asp
End IF
Next
Next
Is there some Frontpage method of doing the same thing? Thanks.
--
Greg Maxey/Word MVP
See:
http://gregmaxey.mvps.org/word_tips.htm
For some helpful tips using Word. Tag: Images don't appear in Frontpage Tag: 71110
Database view it from Web Browser
Anyone interested to link a database through a web browser. I do not
care too much about the design, I just want it to work. Maximum 4
pages. Needed ASAP and please quote me on the price. prefer to use
Frontpage because that is what I have.
Thank you Tag: Images don't appear in Frontpage Tag: 71109
page refresh after query
I'm displaying records queried on a date field, automatically displaying the
current date's data on page load. I have a text box displaying the query
date, with "prev" and "next" buttons (and then a "go" button) to select
another date. My problem is that when the new query results appear, the
default date in my query form is set back to the current date (I assume
because of a page refresh), and I want it to keep the last query date. In
other words, the viewer can't continuously query consecutive dates with just
one "prev" or "next" click - he has to keep starting over from the current
date. The only solution I can think of is to give him a session cookie with
his last query date and check for it on page load. Is there some way to
refresh the database results table and leave my query form alone? Tag: Images don't appear in Frontpage Tag: 71103
Problem with CSS overflow
I expected the following to show a clipped image with scrollbars - the image
was indeed clipped but the scrollbars are not shown. What am I doing wrong ?
<img
src="my_image.jpg"
alt="some text"
style="position:absolute; left 100px; top:100px; clip:rect(0 200 200 0);
overflow:scroll"
> Tag: Images don't appear in Frontpage Tag: 71099
Any one want to build a couple website for me?
Hi to all
website #1
I am looking for someone that wants to experiment a little I want
someone to create a website with a secure job board and a resume
board. that can be copied to other sites.
I am not in a big hurry so you can work on this when you have the
spare time.
Now here is the catch I cannot afford to pay more then $300 If I could
I would be more then happy to the only thing I can say is if I make a
profit (at least 2 years out )on this site you will recieve a nice
bonus. for a turn key site.
I only have a domain which I perchased through GoDaaddy.com I have no
hosting yet .
website#2
This one will be a basic web site with a home page, contact page, job
page and a resume page, must be able to have at least 20 member secure
login options.
please let me know the lowest price for this as well.
call anthony at 304-584-4811
email anthony at ptlservices.com
anthony@ptlservices.com Tag: Images don't appear in Frontpage Tag: 71093
Hitcounter Howto...
Hi All,
Years ago i managed to 'edit' the build-in hitcounter from
FP. As i recall i had to create the digits as .gif files and store/publish
them somewhere in my website.
By now you can feel the question coming, "how did i do that".
I really got no idea anymore on how i did this, i want to use the
hitcounter from FP2003 but not those 'ugly' digit images that it
comes with.
If anyone knows where and how to start editing the hitcounter so
that i can use my own images then pls help me out.
Many thanks in advance for any or all idea's, suggestions.
Arthur Tag: Images don't appear in Frontpage Tag: 71091
Front Page Forms
Is it possible to create a form with a drop-down menu listing staff members
names and their email addresses as values, for example,
<select size="1" name="staff">
<option value="johnsmith@company.com">John Smith</option>
</select>
and depending on what staff member a visitor has chosen from the drop-down
menu, the form would be sent to that person? If so, please direct me to an
example of how to accomplish that.
I'm using MS FrontPage 2003 and publishing to a Windows 2003 server with IIS
6.
Thanks Tag: Images don't appear in Frontpage Tag: 71088
Frame - display a from
How do I get a form to appear and function within a frame?
I'm trying to use "Inline Frame" , and this may not be the proper approach.
I have the "remote" web address that contains the form:
http://www.website/ProductForm
The idea is that visitors to my web can navagate to my products page which
contains the frame. The visitor sees my banner and drop down menus across
the top of the page and the form, below, which is located within the frame.
The visitor can use the form to search for products, and view search
results - all of which is contained in the frame.
How can I do this?
Thanks, Mark Flynn Tag: Images don't appear in Frontpage Tag: 71087
Field result is empty on confirmation page after submit is clicked
When I click submit for my web page form, the confirmation page is
shown. One of the fields which has data is blank on the confirmation
page.
This is probably because I replaced the text field in the form and put
in a new one yet the old field name still shows up in places in the
html code.
How can I make sure where the verification page is getting its
information and change the name of the textbox field that it is
showing in the verification page? Of course, when the email is sent
with the data from the form, it is showing the blank also.
Thank you. Tag: Images don't appear in Frontpage Tag: 71082
Own message in status bar
I see a lot Webpage where I can read a message in the status bar of the web
designer himself. Now my question is, how do I do it on my own webpage. Tag: Images don't appear in Frontpage Tag: 71079
Fortune in Dental Temporary Agency
What is dental temporary agency? A dental temporary agency is a business
that provides dental staffing services on temporary basis. The dental
temporary agency provides employment or on a contractual basis for
dental hygieniest, dental assistants, dentist, dental receptionist,
dental office managers, and other dental professionals. The dental
temporary agency either sends these dental professionals on a temporary
assignments from hourly to long term assignments, usually 12 weeks
assignments. It all depends on the contract. Also, some dental
temporary agency provides temporary to permanent placement or just
direct placement.
[url]http://anthonysguides.com/dental_temporary_agency.htm[/url]
--
gianmariella
------------------------------------------------------------------------
Posted via http://www.codecomments.com
------------------------------------------------------------------------ Tag: Images don't appear in Frontpage Tag: 71078
301 redirect
I have changed a page name and need to do a 301 redirect. I have read about
the .htaccess file and have the following directions "If your site's root
domain already contains a .htaccess file, you can simply scroll to the end of
whatever code is already there and append your 301 redirect code at the
bottom of the file, starting on a new line." I have no clue what this means.
have searched for the .htaccess file etc. can not find it. Maybe you could
explain how to do a 301 redirect in language that I can understand. Please.
Thanks so much Tag: Images don't appear in Frontpage Tag: 71075