Below is the code I am currently using to open a Report from a Form. I want
to know how I can use additional criteria. I want it to not only look at
CO_Number, but I want it to Match CO_LN_NO as well. Both of those fields
reside in the form, and both fields are in the same source ...

I have a small, pop-up form with 2 controls.  The first is not visible and
contains the text value "password".  The second is an unbound control where
the user enters the password, if they are correct, it opens up an input form,
if they are incorrect it displays an error message. ...

DO I NEED TO HAVE XP TO DOWNLOAD TEMPLATES?

I have a report that shows (in part) the average length of time it took
participants to graduate from a program in both days and months.  In the
query I have set both of the Average fields (days and months) to "Format:
Fixed" and "Decimal Places: 1".  The problem is, however, ...

From the main form, I want to check if there is a new record in a subform.  
I get the following error message: "Object doesn't support this property or
method".  I'm using the following code:
Private Sub Add_Record_Click()

Is there any way to force one specific report to default to Landscape rather
than Portrait?  
Thanks,
Tim

I am using MS Access 2002.   Something has changed in the settings and I do
not know how to change it back.
Before, when I added a new Command Button to my form, as soon as I clicked
the position of the command button, a form popped up to help set up the

Using a basic continous form, how do I set up the form to not create a new
record until the end of the tab order is reached? Currently it's generating a
new record as soon as the user types into the first text box(tab stop). I'm
assuming a event action is required on the last ...

I am using Access 97.  On my database I have a print switchboard with unbound
controls for putting in the start dates and end dates to filter my data by
date range. These are "tied" to queries which are used to filter the reports
I want to print. The problem is that when I open ...

I have several forms that look similar with a search box on the left and a
tab control to the right. I'm trying to keep my form layout consistent so
users know where to find stuff.
The search boxes have different columns depending on what is being searched

I have a FORM from which i am opening another form that has SUBFORM in it.
I want to use values from the 1st form to filter data in the SUBFORM.
I can easily filter data in the Second form, but i can't seem to make it
work, to filter data in the subform.

I want to cretae a form which will only allow one record to be added. I have
noticed an an option under Tools|Options|Keyboard called Cursor stops at
first/last field.
Presumably this option only applies to the local copy of Access and not the

In a form i have a button which opens a new form. I want automatically
complete two fields in new form through a macro. Macro is executed when new
form is on state "On Load" but nothing happens! I don't receive any error
message too! In the new form if macro executed with a ...

First, my english is not so good, so I am gonna explain you the problem the
best I can.
I have a Table with 3 Fields:
Field1 = Medical Test

Does anyone knows how can I "Show Desktop" from a shell cmd or any API
function as if I clicked on the "Show Desktop" Icon?
Thanks in Advance.
jouj