Query taking information from form problem


HOME ยป Access

I have set up a form to allow for new students to be added to the database. I have connected the form to a query that is called upon when the user saves the form. The query is meant to take the information from the text boxes on the form and add them to the students table. For a reason unknown to me the query is adding the new student into the table the amount of times that there are records in the table. So the first time the query is ran it adds 19 copies of the new student into the table as there are currently 19 students. Any help would be greatly appreciated. Here is a copy of my database:
Attachment 53736

Related to : Query taking information from form problem
Taking Information from forms to change form value
Access
I am creating a website for someone and can get information from one form to check it so it can then change the data in another form.
This what I have for JavaScript:
<script type="text/javascript" language="JavaScript">
function price()
{
if(document.cust.top.value == None &&
document.cust.swirl.value == None)
{
document.price.hosted_button_id.value =
"UDNNKUHTPGEEW";
}
else
{
document.price.hosted_button_id.valu
Problem with query taking too long
Access
I have an authentication system for my programs which logs every authentication attempt.
Now over the months, the logs table have gotten 4,064,450 records.
The problem is when im executing that query to get the latest 13 records it takes about 10 seconds to do it.
"SELECT * FROM logs_table ORDER BY `time` DESC LIMIT 0, 13"
`time` = the time of the attempt.
Is there a way to optimize the query ?
Thank you.
Taking Info from a Main Form Control into a Query
Access
Hi
I have a Main form with a sub form in it.
I have a combo box(cbSub) in my subform.
This combo box's values depends on what value is present in a combo box(cbMain) on the main form.
cbSub uses a query where it asks for a value. Im using [Forms]![frmMain_Name]![cbMain] in the query under the value which cbMain uses.
The query works.
But cbSub doesn't seem to read cbMain.
A message box pops up asking for a parameter value for Forms!frmMain_Name!cbMain.
Any Ideas?
Thanks
Sean

Taking information form a label when clicked
Access
Right. I have a button that will create a label on another form, this button will display the name of something etc. I have also set the .OnClick procedure of any newly created label to a macro which opens up a new form. However I want to display information on this form that is revelant to the label clicked.
So far, the macro runs a function before opening the form.
My first idea was to use the filter on the OpenForm action in the macro to link the caption on the label to the information on the new form.
I then realised I had no way, in my knowledge, of how to retrieve the caption of the clicked label without giving it it's own procedure.
Taking information from a form and then create a new record in a table
Access
I have two fields on a form, (lets call them Field_1 and Field_2) originating from a table called Table_1, if i wanted the information stored upon those fields to be stored in a seperate table (Table_2) from where the fields originated from, how would i go about doing that?
In summary, how would i do copy two fields of information to a new table after a push of a button?

Query taking information from form problem
Access
I have set up a form to allow for new students to be added to the database. I have connected the form to a query that is called upon when the user saves the form. The query is meant to take the information from the text boxes on the form and add them to the students table. For a reason unknown to me the query is adding the new student into the table the amount of times that there are records in the table. So the first time the query is ran it adds 19 copies of the new student into the table as there are currently 19 students. Any help would be greatly appreciated. Here is a copy of my database:
Attachment 53736


HD Wallpapers
3D
3D Abstract
City
Celebrities
Indian Celebrities
Cars
Travel
Girls
Animals Birds
Movies
Sports
Black White
Nature
Planes
Anime
Food Drink
Dreamy Fantasy
Architecture
Games
Space
Holidays
Flowers
Love
Artistic
Baby
Beach
Bikes Motorcycles
Macro
Computers
Vector
Funny
Army
Textures
Brands
Misc
Music
Other
Privacy Policy - Copyrights Notice - Feedback - Report Violation - RSS 2017 © bighow.org All Rights Reserved .