I have a couple of issues:
1) I'm trying to get a checkbox to become checked if certain values are
entered. For instance, if my "date" text box has any value, I'd like the
checkbox to become checked. I'm assuming I will have to extract the value

Is there a way to choose which form to pick as the input on a query.  
When I am running a query that requires a date range, I build a form with
the dates and reference the form in the criteria.  If there were 2 forms that
may provide input to a query, I thought it would look like ...

       I am reasonably new to Ms access, I hope someone can point me in the
right direction. I have a crosstab query set up with a row heading of
"status" and a column heading of  "teams". The status is always either
"Assigned" or "Null" or "Monitored" there are only ever 4 ...

Okay, I'm still a newbie, so bare with me.
I have a form with 2 combo boxes and 2 buttons. I want to be able to choose
a value in one of the combo boxes, press one of the buttons, and run a
report. Each report is based on a query that has a parameter. I've got two

This is probably a very obvious question, but being new to Access I am
looking for some help...
I am tracking registrants for a conference, some of whom will be exempt from
paying the attendance fee.  I would like to create a form that lists the

Please forgive me if this is an obvious question...
My database houses a list of files and their locations on our company's
network.  My master query includes the file name, the file's current
location, and its old location, among other things.

I'm new to Access and not familiar with Events, Procedures or Visual Basic.
I have a form with a Date Field called "Expiration Date". In the same form I
have a Checkbox called "Terminated".
I'd like the current date to automatically populate the Expiration Date when

I'm using Access 97 & in a form I have a Memo field restricted to 1200
characters, although you can type away until the limit set by the coding is
reached it will not allow me to Tab. Such as
1) Issue letter 21/02/06

Hi
Please could you help me
I want to enter text only (NO NUMBERs ALLOWED) What should I type.
Chris

I have created a switchboard for my database and would like one of the
command button options to be "Display Database Window." There is an example
of this in the sample database. The DW will be hidden, but I would like an
option to click on that button and enter an ...

I am a new access user migrating from Approach. I discovered this code in a
previous posting by Van T. Dinh...
I have a form based on a table=newhire, I have another table = required,
both have a field named "rec_"  there are 6 fields of data that I want to

Hello everyone, I did not know where to post this, so I apologize if it is in
the wrong form.
I am trying to schedule a task in Access 97/Win XP to be able to send a
email in Lotus Notes. I have the code for the Lotus Notes, but I am having a

I have to maintain an application that I did not write and is set up in a
weird way.
There are two back-ends, one is protected by a password and contains a
mini-application to update referenece tables. There are no relationships

Hi I have just installed Office 2003 on to a new computer and the links to
send  Access reports to Word or Excel are not available, where do I go to
but this right?
Thanks Bob

I have found a number of instances in the database I have inherited where
variables have been declared  "Dim rs, rh, Dt As Recordset".  Does this mean
that rs, rh and Dt are all declared as recordsets or has the previous
programmer misunderstood and rs, rh are actually variants ...