473,382 Members | 1,387 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,382 software developers and data experts.

Help - 3 action buttons on each record

Hi, I have the following need: I list a table from an access database but
cannot interact with each record.
At the html page I display all records, one field (field1) from and 3
buttons for each record so to:
Button 1) Accept: Sets 1 on field 2 on that record
Button 2) Reject: Sets 0 on field 2 on that record
Button 3) Delete: Deletes that record

That'd be:
-------------Record 1---------------
Message: Hello 1!!!
ACCEPT - REJECT - DELETE
-------------Record 2---------------
Message: Hello 2!!!
ACCEPT - REJECT - DELETE
-------------Record 3---------------
Message: Hello 3!!!
ACCEPT - REJECT - DELETE
-------------Record 4---------------
Message: Hello 4!!!
ACCEPT - REJECT - DELETE

For example I press delete button and it'll have to delete that record:
-------------Record 1---------------
Message: Hello 1!!!
ACCEPT - REJECT - DELETE
-------------Record 3---------------
Message: Hello 3!!!
ACCEPT - REJECT - DELETE
-------------Record 4---------------
Message: Hello 4!!!
ACCEPT - REJECT - DELETE
Actually, I'm just displaying these records but I don't know how to do
different actions for each button for each field.

This is the code:

<form name="form" method="post" action="add_to_guestbook.asp">
<table width="610" border="0" align="center" cellpadding="0"
cellspacing="0">
<%
while not RS.eof
%>
<tr>
<td>
<%Response.Write RS("MessageText")%>
</td>
</tr>
<tr>
<td>
<%Response.Write RS("MessageFrom")%> - <%Response.Write
RS("MessageDate")%>
</td>

Hope you can help me,

Marcelo.
<tr>
<input type="button" name="btnAccept" value="Accept">
<input type="button" name="btnReject" value="Reject">
<input type="button" name="btnDelete" value="Delete"></td>
</tr>
<%RS.movenext%>
<%wend
set conn=Nothing
set RS=Nothing
%>
</table></td>
</tr>
</form>
May 12 '06 #1
0 1321

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: kma | last post by:
I am designing an Access 2000 database on a computer running Windows 98. I have one form with several tabs; all of which have sub forms, some with a subform on a subform. For example, on my...
2
by: Paul Malcomson | last post by:
Hi. I'm having terrible trouble with a form that displays several parent/child relationships at one time. It is a sales force hierarchy - Sales force, district, territory, sales rep are the...
2
by: Sam | last post by:
I'm working on a small application and I am stuck on the logic behind one of the queries I want to write. I've always considered myself to be a good problem solver and it depresses me that I can't...
8
by: Steph | last post by:
Hi. I'm very new to MS Access and have been presented with an Access database of contacts by my employer. I am trying to redesign the main form of the database so that a button entitled...
14
by: ApexData | last post by:
In my database, I uniformly handle records on a Record by Record basis, in a single form that contains New/Edit/Del buttons. Because I'm dealing with records one at a time, I can easily manage my...
1
lwwhite
by: lwwhite | last post by:
Another question. On one of my forms, I have two radio buttons: Topic and Window. Beside each of them is a drop-down to select the corresponding topic or window. When Topic is selected the window...
2
by: rookiejavadude | last post by:
I'm have most of my java script done but can not figure out how to add a few buttons. I need to add a delete and add buttong to my existing java program. Not sure were to add it on how. Can anyone...
1
by: kvazar | last post by:
What I am trying to create is basically a page with a bunch of multiple choice questions. Basically just like a test page. I am providing the code lower. All the questions that need to show as a part...
2
by: yeshello54 | last post by:
so here is my problem...in a contact manager i am trying to complete i have ran into an error..we have lots of code because we have some from class which we can use...anyways i keep getting an error...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.