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
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
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 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.
Development
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
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.
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?
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
Access

- Technology - Languages
+ Webmasters
+ Development
+ Development Tools
+ Internet
+ Mobile Programming
+ Linux
+ Unix
+ Apple
+ Ubuntu
+ Mobile & Tablets
+ Databases
+ Android
+ Network & Servers
+ Operating Systems
+ Coding
+ Design Software
+ Web Development
+ Game Development
+ Access
+ Excel
+ Web Design
+ Web Hosting
+ Web Site Reviews
+ Domain Name
+ Information Security
+ Software
+ Computers
+ Electronics
+ Hardware
+ Windows
+ PHP
+ ASP/ASP.Net
+ C/C++/C#
+ VB/VB.Net
+ JAVA
+ Javascript
+ Programming
Privacy Policy - Copyrights Notice - Feedback - Report Violation 2018 © BigHow