buttons text fields

[djaccess]

1: How do i change the style of text field and submit buttons

2: i have a field in a databse table which points to either a

picture

field = /images/hello.gif

sound

field = /sound/text.mp3

hyperlink

field = /test/energy.html

how do get the results page to have buttons which will reference the to play the sound or open the hyper link

or to have the picture displayed in a box.

[D3mon]

1) Do it with CSS, like:

input {
color: black;
background: red;
}

2) Check the last 3 letters of the field content (gif/mp3/tml) then display the appropriate link accordingly.

[djaccess]

not sure what you mean, i have designed a results page with the button, how to i reference the result to the button with out haveing to manuly change the html

[D3mon]

is it online, can I see?

[Nick]

<blockquote id="quote"><font size="1" face="geneva, verdana, arial" id="quote">quote:<hr height="1" noshade id="quote">Originally posted by djaccess

not sure what you mean, i have designed a results page with the button, how to i reference the result to the button with out haveing to manuly change the html
<hr height="1" noshade id="quote"></blockquote id="quote"></font id="quote">

Can't you just do;

Code: Select all

<form action="<%= RecordSet("FieldWithPoints") %>">

[djaccess]

ok right a make a picture in Fireworks that i am going to add as a link to open a sound or image. The link for this file is held in my access database as etc. sound/sound.pl

i want to have 5 or 6 diffrent sounds linked with some other information from the table

so for instance
Pages

Name song name

steve outerspace <Button to play song>

<Button to play song> = result from table sound/sound/pl

i dont want a textr field with the result

[D3mon]

Assuming you've got a recordset (RS) with all the field values then:

Code: Select all

If not RS.EOF Then
	Do until RS.EOF
		response.write _
                RS("name") & ", " & _
                RS("title") & ", " & _
                "play
"
		RS.MoveNext
	Loop	
Else	
	response.write "no records found"
End If

this should produce the following type of listing:

The Prodigy, Charlie, <u>play</u>
The Beatles, Yesterday, <u>play</u>

...

[djaccess]

what if i want the play to be a picture and i have more than one set of results say 7 sets

[djaccess]

Right ok so you put the result in the href of the button, but the problem im getting is that it opens the result

e.g

/sounds/sound.mp3

as a web page and errors, how do i make this open in winamp or win media player and play rather than bringing up the download screen.

[D3mon]

If you have an MP3 player installed it should be able to play it with IE. Otherwise suggest that they 'right-click save as' and play it using their favourite MP3 utility.

If you want to show a different word for each type:

.gif = "show"
.mp3 = "play"
.html = "view"

then you'll need some code tht works out what the last part of the string is (after the last dot):

pos = instrrev(RS("location"),".") 'find the last dot in the string
'make a new sring of just the stuff after the dot
extension = left( RS("location"),(len(RS("location")) - pos) )

then inside the loop have a sselect statement to put in the correct word:

Code: Select all

Do until RS.EOF
    select extension
        case "gif"
            linktext = "show"
        case "mp3"
            linktext = "show"
        case "html","htm"
            linktext = "show"
        case else
    end select
    response.write _
    RS("name") & ", " & _
    RS("title") & ", " & _
    "" & linktext & "
"
    RS.MoveNext
Loop

[D3mon]

<blockquote id="quote"><font size="1" face="geneva, verdana, arial" id="quote">quote:<hr height="1" noshade id="quote">Originally posted by djaccess

what if i want the play to be a picture and i have more than one set of results say 7 sets
<hr height="1" noshade id="quote"></blockquote id="quote"></font id="quote">

Just have 7 loops in a row, one for each RS.