If the field DocId as any data I want the user to be able to print a report.
If the field DocId the user will not have the option to print.
I have built the above code.
The problem is that it acts as if DocId was never empty. Not even in a new

I have a form with several check boxes.  I have created an unbound form
with checkboxes.  I want to be able to open the bound form based on the
check boxes selected on the unbound form.  As there are several check
boxes, if the user selects a checkbox, the bound form should open ...

Hi - hope someone can help me.
I have a form with 4 combo boxes.  Each combo box stores a piece of info
into the table.  But I need to be able to restrict what the users are
selecting.  For example if the field Service is selected, then I need the

I have a continuous form which has a search function. What I would like is a
message to appear when you search and no records are found telling the user
that their search returned nothing instead of a blank form.
Any help would be greatly appreciated

I have noticed a weird behavior of Access that I can't understand.  I have a
form where I make reference in code to a field such as:
Me.Transaction_Src = "Manual Entry"
Since Transaction_Src is a field in the underlying record source, the form

I have a continuous form with a button that has a little wingdings circle in
it next to each record in the detail section. When one of the fields (a text
box) returns a certain value I want the fore color of the button to change to
red in order to alert the user to click on it.

I wanted to make MDE file, but the option is greyed out.
What could be the reason? Is there another way by which I can create and MDE
file?
Thank you,

Hi...Newbie here!  This might be long, but I want to be clear...
I'm working on a database for my agency in which clients are assigned to
specific staff through use of a staff id number.  For administrative purposes,
we have one *generic* client that is not assigned to a specific ...

I have the above expression.
If Me.DocID Is Not Null Then
It gives me an error: Object required.
Does anyone know what does it mean?

I want a form to be visible and editable only thru' another form.
Is it possible? How can I do it?
Otherwise what are the options?
Thank you,

I have a database created in access 2003 (using the default Access 2000
format).
This has an autoexec macro including a query which uses a DIR function to
test if a number of files exist. It works fine.

Quick question here. In the query design window I am creating a make table
query where if the value of field "A" is equal to the value of field "B" then
do not include record in query result.
Happy to provide additional info!

This has happened to me once before, and I don't know how I resolved it.
I have a pop-up form that was working fine and then all of a sudden it won't
show-up when it is opened programmatically.  Also if I try to open it from
the database screen, it becomes highlighted with a gray ...

I appologize if I asked before, but need to clarify.
I have a form with subform.  The main form has text box with DLookup as
control source.  It looks up the therapist assigned to a specific floor.
The subform is linked to main form via Med Record Number.  The subform may

I'm thinking this should be a simple issue...  How do I get it so a User is
only allowed to enter a whole number in a text box?   I have the field
formatted as Fixed with 0 decimals, which does round it to the nearest whole
number, but I would like to have an error or MsgBox ...