Can someone tell me how to prevent access to a field on a form, by password.
Thanks,
Paulo Ferreira

How can I get the users sign on, Name and the Group Code from "User and
group Accounts" Member Of (which group he is)?
Thanks
abe

Is it possible to make whatever is inputted the default value of a field
until a different value is inputted?
Thanks in advance!

I have a form with two subforms on it.
The subforms show calcualted values from data entered into the form.
The way that I currently update the values is by using a simple macro that
goes to the next record and than back one to the record that you are working

Is this a spyware problem? It happens online in email when there is an
attachment and other times Word stops responding as well. I have Norton and
Adaware but I would like to know if there is a better spyware checker. I have
XP with Office 2000.

The Error message says I must save the field before I
execute the GotoControl or Setfocus method. But the
control is an unbound command bar.
??

I have a multi-user database (Access XP) that links to SQL Server 2000 tables
via ODBC.
Whenever new customer details are entered and the record is saved (whether
by using doCmd.RunCommand acCmdSaveRecord/If me.Dirty = True Then me.Dirty =

I want to see if a calculated value in a text field on a form is a duplicate
to existing entries in a table. I have an idea how to do it and I can search
for code examples but I do not even know what VB or SQL terms to search for.
Can you please point me in the right direction?

Hi
Wonder if someone could help. My database has a form that one of the fields
in the form is a drop down menu, and you select what data you want. This drop
down menu is populated by a table. From the form, I have a command button

I am trying to design a database for a daily dispatch log.  I have figured
out how to log the ModifiedTime.  Now I have four check boxes for:
Enrt             On Scene            Transporting       Availible
Enrt Time     On Scene Time  etc...

I have an Access application with a table with an OLEDB field, in which
photographs are linked. The photos are shown in a form. This worked well for
many years and now suddenly it doesn't show the photo automatically any
more. You have to double click on it.

I am running Office 2002 on Windows XP. I am trying to create a pivot table
based on a simple query, however when I drag & drop fields on either the
'Drop Column Fields Here' or 'Drop Row Fields Here' regions, I get the
following error message in the Detail area:

I open a form and get an error stating "You can't go to the specified record."
Followed by "You may be at the end of a recordset."
I have a macro that requires the form to goto a new record but this also
shows up as halted.

I have a form that has a subform.  There is a RARE possibility that more than
one record will be associated with the subform.  I would like the backcolor
of the subform to change to another color if there is more than one record
associated with it (just to bring it to the user's ...

I'm just wondering what the diffrence is between using the code on the first
row than on the second row.
1. set DB = CurrentDB
2. set DB = Opendatabase(CurrentDB)