I have a MS Access Database. I have a page where i do a search for a item by date, I select a date and then all the information from the database that i requested appears.
From all the information that appears I want to be able to tick the ones that I want to delete or a select all button and click delete and all the ones that where ticked will be deleted from the database.
I am loading a table from a database which all works great, I have checkboxes beside each database entry which is great. I want Delete, Modify and Add buttons underneath the table which I have also and that is great.
Problem is I want these buttons to be able to know which check box(s) I have selected and delete all info from tblProspect that matches that ProspectId when the delete button is pressed.
I want all info from tblProspect that matches ProspectId to be copied to tblClients when the make a member button is pressed and delete the info from tblProspect. Then I want the button that says Modify Prospect to load a page that shows the prospect information, where it can be modified and then have an update button which will change the information in tblProspect.
ACK I can't wrap my head around this tonight for some reason and it is driving me nuts, I keep trying different code and deleting it. Code:
I have the following database sturcture:
tblUnits
unitID, UnitTitle
tblObjectives
objID(PIK), unitID (FK), objTitle
I display a form with drop down select list based on the results of a query on tblUnits
when user selects an option from select list I display the correct Objectives (in the form of chekcboxes) for that option.i want to store user choices in another table :
tblUserObjectives
userID(PIK), objID, selected (not sure if this is reserved word in access?).
I would also like to display the choices to the user when the form has been submited. Can someone tell me with the last table structure, query and how to approach this problem.
How to use asp to populate checkboxes from a column in an Access table? I want them to be updated when the table is updated.
View Replies View RelatedI have a form that users use to register with the site. On this form there are checkboxes all with the same name but different values. I am creating another page that will allow users to login and edit their information.
Since all the data from the checkboxes are stored on the database under the same field name and separated by commas; how do I dynamically create a set of the checked checkboxes that the user originally entered along with the other checkboxes the user did not click?
I am tring to create a front end for this Access Database someone has given me and i have trawled through these and other forums for the answer to my question but have not found anything!!
I have used 4 checkboxes in a form with 4 different names, when i try and create a record in the access database which uses the Yes/No Field Type it displays the error, " Provider error '80020005'
type mismatch" when trying to right the value into the field!
I have a form that has checkboxes. I would like when the user clicks the
process button the next page will display the value of the boxes that were
checked.
Do any of you guys know what the value of a check box is.
I am offering two ways to download, posting to a diff form and using info from there but do not know which check box has been ticked??
To get the checked value of checkboxes I use this code:
Code:
For Each subitem In oFileUp.FormEx("imgCheckBox")
...
Next
How can I get the value of those unchecked checkboxes?
I am trying to set up a page, with some input fields, which
are mandatory. Then there is a checkbox, when it is
checked, the input fields do not need to be filled
(not mandatory anymore). At the moment, even though
the checkbox is checked it asks to fill the mandatory
fields.
I need to add a master checkbox, clicking on which, will select all the child checkboxes. Unclicking it, will unselect all the child boxes.
Exactly the same way as hotmail does. I know, I need to write a javascript for that. But the problem is, the child checkboxes are being
populated from the stylesheet code (embedded in the .asp page). It is also not under the <form> </form> tag. Following is the code:
I've never used checkboxes in ASP, well nows the time i do it.Im creating a login script, and want the user to be able to click on "remember me"it keep them logged in.
how would i get that in ASP. how would i make it detect wether or not the checkbox has been selected or not?
I'm trying to create a form that has checkboxes on it that when a user checks the particular boxes, and submits the form, it performs the query based on the selections.
I'm using MS Access and FrontPage. I'm having problems passing the information from the form to the query and then to the database.
How can I use checkboxes to send out an email based on which checkbox was clicked?
For example, I have an html table that is constructed dynamically which contains information about events stored in a database.
The table has checkboxes out to the left side (similar to hotmail) and when I check however many boxes, and click submit, I want to send an email to each address that is associated with each record that I checked its box.Something like "for each checkbox clicked, select the ID and email address associated with it, and dispatch an email"
I have everything set up except the asp loop and select statement that will help me achieve this.
i have some 15 checkboxex on a form... i want to 1st check the no. of checkboxes that are checked?? and then loop it that many times adn insert the quantities the user enters in the text boxes.
do i need to group the checkboxes....hwo can i do that??? how to know which checkbox is checked because out of the 15 checkbox say 1,5,7, 9th are checked then i 1st need to get the id from the database adn then based on htat id retrieved i need to insert values on another table.
give me a working example on how to use checkboxes ?
View Replies View RelatedA list of names is printed out from a Table as a list of checkboxes:
<tr>
<%while not rstLogin.EOF%>
<%
dim name
name =rstLogin.Fields(0)%>
<td><input type="checkbox" name="<%=name%>" > <%Response.write (name)%> </td>
</center>
</tr>
<%
rstLogin.MoveNext
wend
What I then want to do is add "Checked" names to another table. How do I do this?
I've been using Dreamweaver to develop some simple database connectivity. So far everything works, but could be more user-friendly and flexible.
I have an Access database with 4 document types. I have search forms which allow users to enter a keyword and search for one specific document type. The problem is I need four different search forms this way. What I would like is to include 4 checkboxes and one keyword textfield. Code:
I have a page with checkboxes which are created from a database as below:
<% while not rs.eof %>
<%=rs("contract_name")%><input type="checkbox" name="<%=rs("contract_name")%>"><br>
<%
rs.MoveNext
wend%>
I need to be able to tell which ones are checked on the next page. How do i do this when they all have automatically generated names?
I have a series of dynamcially named and id'd checkboxes. each one has the same name but its id value is different. The ID value tells me which checkbox relates to a particular record in a recordset. I need to obtain the id of the checkbox and its value - so far I can only get the value as follows :
<%
For x=1 To request.form("BillNumCheckBox").Count
aSelected = request.form("BillNumCheckBox").Item(x)
response.write x & " = " & aSelected & "<BR>"
Next
%>
I have two related tables in my database. One stores events and the other stores a list of key topics.
I have an interface set up where users can add / edit events.
In the add event page, I am querying the "key topics" table and returning them as options (array of checkboxes). The user makes their pick, and submits. All the data saves in the 'event" table, including the primary id of the "topics".
That part works great. The problem I am having is when the EDIT event page resolves, I am trying to "check" the options that were previously saved.
First thing I do (at the top of the page) is to query the events table to pull all of the data out. I use the 'events" table to do this.
For the checkboxes, I am once again looping through them in a query that uses the "key topics" table. So the boxes are displayed, but I can't seem to get the logic right to have the appropriate ones checked. here is my current code:
I Have this form in page1:
<form method="post" action="page2.asp">
<input type="checkbox" name="numb" value="10">
<input type="checkbox" name="numb" value="20">
<input type="checkbox" name="numb" value="30">
<input type="checkbox" name="numb" value="40">
</form>
Now what I want is to add the checked values in page2.
For example :
if checkbox1 and checkbox3 gets checked I want to add the values in the
checkboxes which in this case is 10 + 30 and get the total sum (40).
Hope this makes sense?
So how do I retrive the checked values and then add the checked values
with eachother to get the total?
The problem I have is that I need to save the content of a form in a database, and I donw know how to save the content of a checkbox, can you give me an example of the code?
View Replies View Relatedat the moment i am creating a shopping cart of sorts. Simply the user selects the check boxes of the items he wants and clicks submit. The items are dynamically created and they could select anything from 1 to 100 items..
so processing the form is clear not possible by hard coding. How could i read all the values from the POST into an array instead of processing each item at a time.
I'm writing an Online registration system for my friends new business.
I'm trying to incorporate checkboxes so when a person checks on 3 or 4 checkboxes and hits the Submit button I can
pass the information of what they checked_on to a new page.
When I get to the new page I would like to update a database, based on what they checked_on on the previous page.
I'm not sure how to do this.
I'm not sure how to pass the information.
I have a page that displays a list of people to email and a checkbox by each name. I want to be able to send to the next page the value of the checkbox and have it either email them if checked or not email if not checked. I know this sounds simple but I have been racking my brain over it for a while now. I have tried naming the checkboxes as so:
<INPUT TYPE="CHECKBOX" CHECKED NAME='chksend<%=objRSOC("PagingGroup")%>' style="font-weight: 700">
And then I am at a loss for what to do on the second page as to how to get the values of the individual checkboxes. If the checkbox is checked the second page would then need to hit the DB for their email address and process the email.
What I have are two pages. One is a form with some input boxes and check boxes on it. It is posting to a different script page that inserts into a database and sends the fields through email.
My problem is sending the information which is checked through to the next page. Each of my checkboxes is given the value of what should be inserted in the table and into the email. I just need a way of determining which checkbox is checked so I can send my information.
I have the following in one of my asp pages:
....
Response.Write("<form action=createpst.asp method=post>" )
Response.Write("<input type=checkbox name=pstfldr value=" & myArray(i) & ">")
Response.Write("<a href = '" & strLink & "'>" & myArray(i) & "</a>" & "<br>")
Next
Response.Write("<br>" & "<input type=submit value=submit>" & "</form>")
%>
In my createpst.asp page I am trying to load in an array using the split function:
<%
Dim arrVals
arrVals = split(Request.Form ("pstfldr"), ",")
Dim i
For i=0 to UBound(arrVals)
Response.Write arrVals(i) & "<br>"
Next
%>
However, the problem is that some of my values that are read in from myArray(i) in the first asp page can be more than one word. So, when I get to my second asp page and traverse through the loop, some of the values stored that contain more than one word only output the first word.
I�ve a list of checkboxes:
Grade 1, Grade 2, Grade 3, Grade 4, Grade 5, Grade 6
I retrieve the values from the database: if it has a value then display a selected checkbox, if not display just checkbox � depends on the condition.
The problem I�m having now is if I uncheck the selected checkbox(es), hit submit button�it still let me go through.
What I try to do is if I don�t select any checkbox(es) the alert message popup and should not let me submit it. How can we do that? Code:
Would like to know how to check all checkbox in a website by using ASP? also how to execute an ASP script when you click a checkbox or by using onclick?
View Replies View RelatedI want somethingh like hotmail, where I don't know the exact amount of records displayed, but when the users checks the boxes and presses submit I can detect which boxes were checked and be able to perform the operation.
View Replies View RelatedI want to collect user input. I have a collection of 30 checkboxes that I would like the user to pickout from. The information then will be recorded to a database somehow. Finally the user will be allowed to change the selection if required.Which is the best way to do this. Do I need to create 30 different fields in the database ?
View Replies View RelatedI am having one form in ASP. I am retriving the records of students from Database and displaying it in a tabular form in a student database there is a field called "paid"
datatype:boolean(yes/no) in access. This field is displayed on the form with the help of format.
I want there should be only one checkbox above all checkboxes . when that checkbox is selected all the checkboxes should get selected. (This functionality is just like any Inbox functionality of our email a/c)
Also The values should be get updated in the database ..for the records whose checkbox is selected as True and not selected also as false.