I have a problem with some code.  It keeps spitting back type
mismatch.   I have a similar thing to this in another database and it
works fine when fired by an option group-click.   Here's the code:
Private Sub Text27_AfterUpdate()

i have a database is split into two mdb files, one is in workstation, and the
other one is in the data mdb (server file.) Can Microsoft Access detect who
was edit the data for the database? i want to detect who, when and what the
user have been edit or add in the database. can ...

Access 2003.
Is there a way to set the background colors of objects by code behind a
form?
For example, have all the lables ( lbl* ) set to one color or transparent,

.
.
.
.

Is there something I must do to avoid this.
1) I install runtime03 + mde or mdb to PC running vista.
When I replaced the mde or mdb (with similar name), it does not get replaced
as when the supposely new files are opened it continued to show the old copy.

I am running Access 2000 on Windows XP. Is it possible to open a form
and have the default entry as the same as in the on the previous form.
I know once in the form I can press Ctrl' to achieve this.
In effect what I am asking is is it possible to program the same

I have a database which records client addresses. I have a field
called Town which is selected via a Combo Box from a Table called
Towns. What I would like to do is to automatically add new Towns to
the Table and the Combo Box.

sorry for the question but I need the direction
Dear all I want to get your advice about the way (the basic) (fundamental )
of any programming language …
What should I do to be (smart ,master, professional ) programmer not in

i have a pivot chart as a subform, and it is possible to change only the
data(not the format) by entering some other data in the mainform.
office 2003
the settings are(by using the properties window):

In my case, I have a form with a subform. The subform was populated by a
query. User should be able to view and enter new records but should not be
able to edit existing records. Each record has several fields; the important
one is [Rate] and [Type]. If data is entered in [Rate] ...

After inserting Allen Browne's Audit Trail code, I attempted to change some
data in my Hardware subform.
I received the following error message: Run-time error '3825': SELECT cannot
be used in an INSERT

I have 3 comboboxes on the form and all of them have a query for their
row source.
It seems MS Access running teh query in the background to get the list
which is very slow to load the form.

I have modified the Allen Browne search form to filter the results of a
parameter query. The query gets its paramters from some of the fields on the
search form. It works but only if I type in the Locality parameter. For
Example:

Hi, i'd like to get the login name for any given user (we use a shortname for
our network, consisting of their first initial and last name) and use that to
filter out all the records except the ones that have that user's name on
them.  I'm not worried about all of the security ...

I tried to have this coded properly.  It seems to returning all of the
correct answer but one never knows!  Could someone please look at my
parentheses to see if they are correct.
Thank you