Can I make a command button only work for certain people?
If I add a variable to a table (check box -  Boolean) which has a list of
users and only the users with this check box checked will be able to click a
command button, to everyone else it's shaded out...  Can this be done?

I have a form that I use for managing follow-up info for job site incidents.  
The form basically pulls data from 2 primary tables, Table_1 which holds the
initial incident data (I know that name is not good, but I didn't create the
database unfortunately) and tblUIRFuData2 which ...

I am trying to attempt some code. I want to have a condition where, if it
isnt met, access will pop up an error message explaining why it isnt allowed.
I have these controls involved:
[Start Date], [End Date], [Time on Duty], [Time off Duty].

I have a situation where I have a form that contains a query of a table of
items with pricing, units, etc.  There are some like records in this table
where the only difference is the quantity in units and the associated
pricing.  That quantity is listed in a unit field.  There is ...

My goal is a report that says something like this:
“User JSmith edited record 333 in tblContracts on 3/2/05 at 11:28
record 567 in tblBuyers  on 3/2/05 at 11:29
record 567 in tblLots on 3/2/05 at 11:30

I am wanting to do the following to ensure that all relevant data is
collected:
1. Force users to input data into certain text boxes and combos
2. Where fields are left blank (due to some info not being known at

I have a main form named "Jobs" which contains the subform
"JobRoomDetails" - "Jobs" has a one-to-many relationship with
"JobRoomDetails". Both set to single form.
"JobRoomDetails" contains a combo called "Rooms" that assigns a

I'm merely trying to hide some controls with the "CP" Tag if the selection
"Critical Period" is chosen in the list box.
Code isn't working.  Can anyone spot the problem?
Private Sub lstProd_Type_AfterUpdate()

I am new to coding with acess and was wondering what the Me is all about. I
see examples showing Me.Visible or Me![FieldName], what is this variable?

I'm trying to create a query that pulls information from a table that's just
a person's name followed by a number of yes/no fields. I'd like for the query
(or an associated report) to display the person's name and any fields which
contain a "yes". ANy bright ideas?

I have a form with 4 fields that need filled on a new record. Typically 50,
or so, new records will be added at a time. 3 of the 4 fields will have the
same value in each record. I have a dailog form with Option Group that gets
me to adding records. My idea was to type the values ...

The form control displays date and time. But the time stays static as at when
the user first enters the form. How can it be continuously updated -  to show
the time 'ticking'?

Using Access 2003, Windows Server 2003
Form Access we want to mail-merge then fax Word documents directly to
Windows Fax Server 2003 without the user seeing the Print Dialog box (i.e.
without them having to enter the phone number). Does anyone have any sample

I have this code below and it was working. The line Text48.SetFocus was
doing what it should. But now when it exicutes it comes up with a Run-time
error 2110 it says that it can't move the focus to the control Text48. I
have checked and it's not a label, visible property is set to ...

Hi I have a Receive Invoice data entry form, on this form is a sub form that
has a query based control source, the query contains details of all records
of receipted orders.
The problem I have is I want the subform to show only the related records to