I have a subform that allows entry of student test results.  Once the
user inputs the test score and the test ID, I would like the subform to
query a look up table and populate a column on the row that the users
is on to show the level of the student, based on the test result.

I have a table I use to enter student data and would like my users to
see a student's scholarship amount based on the data they enter into
the following fields:
[FYear/Tsfr] - "First Year" or "Transfer"

Hi Newsgroup
Does anyone here care to share their thoughts/experiences with using
masking?  I am storing categories of books which libraries stock, so that I
might have codes:

Does anyone know how to make "Office Links" available when running the
above,
the command  button just goes blank on our machine....  ?
any help or advice much appreciated

Can someone tell me how I can open a form to a specific record from a
button on another form.
Here is what I want to have happen. I have one form called Computers
and another form called Monitors. One of the fields on the Computers

I have problem with the command "DLookup" in Access 2000.
The command takes very long time to run.
Have anybody any solution for this.
//LOA

Hope someone can help
I have records of fuel inventory, and I've used yes/no switches for
the different types of fuel.
ie:        amount        gas    clear    dyed

What should I put in a query that would, if I have a start time and an
end time, tell me how much time was spent on a project.

I have the following code:
Private Sub cmbNYAdmit_NotInList(NewData As String, Response As
Integer)
On Error GoTo Err_cmbNYAdmit_NotInList

I think I may have lost the plot.  Just a few years ago I'm sure I wrote
something similar to the following code:
   dim rst as recordset
   set rst = currentdb.openrecordset("mytable")

I was able to use this code .
Sub test()
Dim db As Database
Dim rs As DAO.Recordset

Hi there, i have a problem defining my primary key...
I have a list of material (tools) that i manage. I want to be able to
track them (follow information that people enter) in the database. I
set my primary key to ID_Material but my question is?

SELECT tblTxAcct.TxAcctName, tblTxType.TxTypeName,
Nz(qryTxAcctListCt.TxCount, 0) AS TxCt
FROM (tblTxAcct INNER JOIN tblTxType ON
tblTxAcct.TxType_ID=tblTxType.TxType_ID) LEFT JOIN qryTxAcctListCt ON

I've changed the font size on the form but it only works in form view.
When the data is displayed in Datasheet view it doesn't display the
selected font size.

May anyone can teach me how to calculate with date, my calculation is :
 Date field (2005/01) +  numberic field (3) = 2005/04(YYYY/MM)