I have a joint table that stores both StudentID and ClassID from the Student
and Class tables.    In the form (Combo box) I want to see not only the
studentID but also next to the studentID I want to see their FirstName and
LastName.  In the Form I created a Combo box.  It's ...

This works:
Me.[Child0].Form.Filter = "[presc_patient] = [Forms]![frm prescriptions
main].[findwhat] "
... but the problem is, I need the filter to search for records where

I am developing a small database using Access 2000 for non MS Access users.
My problem is when the user open the database  via a icon on the desktop I
don't want the user have any access at all of Access menu bar (File, Edit,
View, Insert, etc.)  All I want them to do is to open ...

I need help. I have made a Table and I have put in everything I need (I
think), I have included in the Field Name: Image and under Date Type: OLE
Object.
Now for my problem; I have setup my Form to show a picture (*.jpg) when I

I get the following "MS Office Access" pop up msg when I open a subform using
Access 2003 in a 2000 database that works with Access 2000.  
" You don't have the license to use this ActiveX control.
You tried to open a form  containing an OLEor an ActiveX control or you

Thanks for any help.
I have a form that views at a query, and there are some negative numbers
that are shown as -x,xxx in the form. Can I display as (x,xxx)?
Thanks

We have a situation where several databases are not performing as expected
after upgrade from 97 to 2003 but both are related to exclusivity. In once
case users open a simple form and enter data but if the database is opened by
any other users it is reported as in use. Somehow ...

I have a sub form on a member from which shows the member history. It
is set to multiple forms in order to show many entries per member.
It always provides a new record which I would prefer to lose.
Is this possible?

I created a form using the wizard and combining info from 3 different tables.
Unfortunately, I forgot to include a necessary field (hence, it's not
included in the field list), which I now would like to add to the form.
However, it's not included in the field list and I don't ...

I have created an autolookup query based on two tables (AcctCodes and Batches).
In the query when I enter a value the Account Code field, the Description
field is automatically updated.
Question: How do I create a from based on this? Form has two fields: Code

I am trying to filter out all of the data with a # in the field on a form or
in a query.  Is there a way to tell Access that I am looking for the
character not a date field?

I AM TRYING TO PRINT A FORM THAT HAS A SUBFORM.  I ONLY WANT THE SELECTED
RECORD OF THE SUBFORM TO PRINT IN THE SELECTED RECORD OF THE FORM.  HOWEVER,
EVEN WHEN I CHOOSE PRINT SELECTED RECORD, I STILL GET ALL THE RECORDS IN THE
SUBFORM PRINTED ON THE SELECTED RECORD FORM.

I know I can set the height of a control to grow, but what about the length?  
An example of what I want to do:  I am creating an address form from a
database where the street number, street, city, zip code, etc. are in
different fields but I want them to appear consequetively on ...

I have controls that I want hidden until a specific value is selected in a
value list.
There are two values in the value list and depending on which is selected, I
want different controls displayed. What's the best way to accomplish this?

How do I open a 2nd form after user selects a record on the 1st
form(datasheet view)  The 2nd form contains more details  Thanks for your help