|Related to : Query taking information from form problem
|Taking Information from forms to change form value|
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.
if(document.cust.top.value == None
document.cust.swirl.value == None)
|Problem with query taking too long|
I have an authentication system for my programs which logs every
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
"SELECT * FROM logs_table ORDER BY `time` DESC LIMIT 0,
`time` = the time of the attempt.
Is there a way to
optimize the query ?
|Taking Info from a Main Form Control into a Query
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
The query works.
But cbSub doesn't seem to read
A message box pops up asking for a parameter value for
|Taking information form a label when clicked
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
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
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
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: