MS Access 2002...
I have a database with a "facility type" equal to a drop down list of 5
variables (residential, commercial, municipal, etc). I am trying to create a
command button on this form that will open the correct inspection form based

Does anyone know how to change the name of the administrator on the main
email account?  Thanks.

I have used the below Code in another Query to help highlight percentages in
either Red or Green.  I need to use the same Code, but instead of <=0.75, I
need it to say <= Todays Date.  What can I add to the code to base it off of
the date the report is pulled.  

I would like to limit a data field in a table to only allow the current date
or past dates as we are tracking the date when something was completed...so I
want to limit the date so it does not allow future dates.
Thanks,

I currently use a excel spreadsheet to store data and have set it up on a
web folder to allow access to other users to view and change data.  This
method is not the best way since only one user can change the data at a
time.  What are the alternatives where users can access the data ...

Is there a way to accomplish this calculation in Access?  I need to reference
the state and the date to determine the percentage to apply to the
calculation.  For example, if the state is GA and the date is between
20030501 and 20040430 apply 4%, if the state is GA and the date ...

I have form with two fields.  One is MR1stSent and the other is MRIn/Out.  On
my query, I have both fields above listed.  I wanted a third column that
indicates the greater of the two dates.  For example if MR1stSent is 1-1-08
and MRIn/Out is 2-1-08, I want the third column on ...

I'm trying to pass the values of a multi-select listbox on a form to a query
as criteria.  The criteria in the query is:
    In ([Forms]![frmEntry]![lstWorkCenters])
I have the property set to simple multiselect, but my query returns no

I ask questions in the Groups after long hours of trial and error, reading
researching and searching. It's great when I get an an email with a link that
there is a response to a question. Sad part is, the links never work! They
just load the main page! The links are clearly ...

I was using form shortcuts in Access 2003 to manage permissions.  Each user
was sent a shortcut to their individual forms which also supply confidential
reporting buttons.
I need to convert my database to Access 2007 but it looks like the 'create

Hello everyone.  Using Access 2003.  Quick question.
I have an application that makes the user sign in with a user name and
password.  The sign in for the user name is not case sensitive.  Is
there a way to make the user name case sensitive for the sign in.

I'm using MS Access 2007 as the front end for a SQL database that
manages payroll data for my company.  I'm looking for a way to get
access to auto-email commission reports on a regular schedule to
employees. I have already created the report and it works great.  I

I have a form set for no edits. I would like to spell check the form when
someone adds a new record, the problem is that spell check is not accessible
when  the form is set for no edits. Can anybody help me with the code so I
can put it into an event procedure to allow edits , do ...

I have a table with the following fields, ID, DATE and Call Type.
I am trying to get the latest call for each ID. I tried using the grouping
function but i couldnt bring the call type through as well.
I read something about a correlated query and have some syntax that looks

I have many combo boxes in forms and in tables which have suddenly stopped
showing any fields. They all show a completely blank drop down list. If I try
adding another one either from scratch or using the Wizard the fields all
appear to be there but in the front end of all forms ...