Query taking information from form problem



Category : 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

View Replies

Related to : Query taking information from form problem


Taking information form a label when clicked
Category : 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

View Replies


Taking Information from forms to change form value
Category : Development
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()
{

View Replies


Taking information from a form and then create a new record in a table
Category : 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

View Replies


Taking Info from a Main Form Control into a Query
Category : 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 t

View Replies


Problem with query taking too long
Category : Development
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

View Replies


Combo Box taking List from Query Problem
Category : Access
I have a query where one of the fileds might return
Food_Sub_Type:
Apple
Apple
Apple
Pear
Pear
Banana
Grape
Grape
If I refer to this field in a ComboBox, it is showing me all the fields (including the duplicates) but I just want the ComboBox to

View Replies


Problem in taking user input in CrossTab Query
Category : Access
I have a cross tab query that takes input from the user. The code is as under:
PARAMETERS [START_MONTH] DateTime, [END_MONTH] DateTime;
TRANSFORM Round(Sum(([A_GAS_m3]+[NA_GAS_m3])/1000000),3) AS GAS_MMSCM
SELECT maindata.on_off, maindata.state, maindata.OPERATOR, maindata.field_

View Replies


Form a query to return information on two different tables
Category : Programming Languages

I have one table shop_inventory and another shops. I want to count the number of DISTINCT zbid from shop_inventory AND the number of rows in shops where cid=1 AND zbid!=0. I tried it like so:


SELECT COUNT

View Replies


Pass information from a form to a query as criteria
Category : Development
I have created a query that will pull information from our database for the operators. This query will pull in on average 50,000 records. The operators need to refine the search results. I have used the following in the criteria section of the query for the operators to refine the search [Enter t

View Replies


retrieving information from query and displaying in a form
Category : Access
hi.I have a problem and do not know how to go about.
Actually i have 3 tables.
Personal table,employment information and edu table.
i have a search form which has 3 fields
last name id SSn
what i want to do is that when user enters the 3 fields i want to fire a query

View Replies


2012 / 2017 Copyrights BigHow , All Rights Reserved .