I have several users who like the entire row for a record to have a different
background color from adjacent records.  I have done it with conditional
formatting by setting a field value to 1 when any field in that record has
the focus.  This works pretty good in a single user ...

I am using MS Access 2003 (project - .adp file) with SQL Server 2000 backend.
I have a form that has several individual checkboxes.  (These checkboxes are
NOT part of an Option Group).
When you create a new record and go to a certain drop down list field in the

I am using a pop-up calendar form that is called from my main form.  
GotFocus and MouseDown events on the main form are calling the popup
calendar.  Once a day has been selected the last thing that happens is the
originating control (the date field on my main form) is being set ...

Hello, I'm using Access 2003 on a novice level.
I have a question about option groups.
I'd like to know if it's possible to create a set of radio buttons,
check boxes, and/or drop-down lists, with an OTHER option that lets

I have a combo box on one of my forms to select a users name from a table
called Users. On the form, for visual information only, I want to see some
other information about the user contained in the same table - Users. I have
used the following in an unbound text control on the ...

Okay I have a form, based on one table.  My form has two combo boxes on it,
one searches for an employee by building, the other by department.  The
results are displayed in a subform beneath the combo boxes.  This seems to
work fine.  However until you enter a selection into each ...

How do you bypass all of the "You are about to" messages that pop up when you
run an append or delete query so it just runs without you having to hit the
yes button in the message?

My SubForm has a Default View of DataSheet.
I am entering a Directory Name, and a Department Name.
The Department Name has a criteria as follows:
SELECT zDepartments.DeptID, zDepartments.DeptName,

Making a report in Access 2007 and I am grouping the data by week. Access
starts the week on a Sunday. Can i change it to Monday for this Report?
Thanks!

Is there any way to password protect my code in the event someone uses the
shift bypass key?  Any thoughts other than your Access security?

I'm not having luck with my code to auto fill a SpRepId field after selecting
the SpRepNam from a combo box in the form.  Both are bound columns.  The
column number refers to the second column in the combo box.  I'm unsure about
why I'm getting an a compile error - invalid ...

I have a form/subform set up that uses the main form to choose a group key
for a set of records that then display in the sub-form.
I am using a SQL update statement in the Mainform.fields afterchange routine
to propogate the new data to all records in the table with the group key.

From time-to-time I find it useful to use
DLookup to obtain a value from one of
a table's fields. Is there there the reverse
of that? I.e., save a value into a table

I have a continuous form that i use to filter particular records on a unique
ID (FNID). On this continuous form i have a button that opens another form
allowing the user to edit the specific record. The second form opens and is
filtered on the selected record using the following ...

I have a table called tblDetails and in this table there are 2 field
called strGateID (autonumber) and srtPN which is a default value of
PN. I have combined two field in a query called qrySearch and the new
field is called srtSearchNo.