I am building a student/class database and want to limit number of students
per class.  Classes have unique id, and I would like to stop adding students
to a class when it reaches the classroom capacity. Is this possible in 2007?
three tables - classes available/students/classes.

I have created a temporary database and table that is then linked to my front
end database.  I found the queries to be slow until I indexed the two fields
that I was searching on in the linked table.  I would like to do this in the
code that creates the table and fields but am ...

To run reports in our application we have a form with fields in which users
enter criteria, like startdate, enddate, state, etc.  Our queries on which
the reports are based have criteria like 'Between
[Forms]![Report]![fldStartDate] And [Forms]![Report]![fldEndDAte]'.  Works

I have a query that produces results like those below:
JobID | Length | Qty
1             8         2
1             7         2

I want to highlight the next item in a listbox (not multiselect). This works
fine with this line. The textfield contains the last ListIndex.
 Me.lst1 = Me.lst1.ItemData(Me.txtListIndex + 1)
In somes rare cases the selection jumps to the entry before the last one and

Yesterday I added a new login feature to my database. I'm using an example I
found online from Phil Mackison. The name of the example is
Audit_Blank_Mod.mdb.
Until I added the new tables, forms, and modules, I didn't receive the error

I get an error when I do anything on a form, the error = "A problem occurred
while (database name) was communicating with the OLE server or ActiveX
control” I don’t have any ActiveX or OLE server!, this comes up if I write
any code or a macro, and then I can’t do anything I have ...

I am trying to write to a table from a form.  I have 2 txtboxes and 1 listbox
with values I would like to write to a table.  I couldn't use an append
query, as my numeric expression in my listbox was too complex.  I find it
ridiculous that I have to use ADO or DAO to write the ...

I've got a form I use to keep track of documents used in a research project.  
The form contains notes on the document (author, year, last reviewed, etc.)
and has a field with a hyperlink to the file and a field with a hyperlink to
the location on the web where the file was ...

I've got a Make Table query that will run when a user clicks a form button.  
The table being created has 4 fields:  3 fields from existing tables and one
"blank" field that I created in the query by giving the name the field:  
    Amount: ""

I have a piece of code that opens a form to give the user a message that the
update is happening which can take some time (10-12 minutes)
DoCmd.OpenForm ("frm_UpdatingMessaging")
Call ControlRoutine

I am trying to create functions that would open a connection and another that
creates a recordset when called from a module. Below is the code I have so
far but when I compile the project I get an 'invalid outside procedure'
error. Any help would be appreciated. I am still ...

Hello, Kallal!
I can't explain how your code is usefull for me.
I'm done with my application with access 2003 ,but saved in access2000
format, then i try to disable the shiftkey with your shiftkey2000, but it

I would like to run a correlation coefficent in ms access against some
tables. Can I do that in a query or do I need to create a VBA procedure. I
have a sql server query that works but not sure how to incorporate it into
access.

I have a button on a form which I want to run a piece of VBA code. It is in
a module called mdl_Control and the routine is called Control
How do I do this
Thanks MarkS