I have a form that is bound by a query.  The query joins two tables.  One
table is not updatable and the other is.  One of the on the form is a
shipping indicator (Yes/No Field).   The problem is that shipping indicator
is not updatable on the form.  How can I accomplish allowing ...

Why do we need to close a recordset used by code into a procedure, since a
variable declared into a procedure has a life time of the procedure,
therefore it doesn't exist anymore in the memory.. does it?
Thanks for any good clarifications!

I have an input box which requests a password to open an administrator menu
page. Currently when asked to input the password, the actual password
appears. I would like to be able to see ****** instead of the actual password
being typed.

I have a subform based on a filtered query within my main form. I would like
to remove the display of the navigation buttons at the bottom of the subform.
I have determined that if I wanted to do this for the main form I would
change the property navigation button to No but this ...

I have a main form with a subform.  Each has its own table.  They are not
linked.  My aim is to stop at each subform record and run MakeChanges(),
which processes all the records in the main form table.
My immediate problem is that when intTick = 2 and MakeChanges() starts its

Is it possible for me to place the content of the clipboard into a field on a
form using code behind that form. What I'm trying to accomplish is an
automatic paste into a field when the form gains focus.

I have a continuous form that displays records that will be in various
status.  I would like to somehow highlight records that are in various
status.  eg Hightlight red those recs that are in status 1, Blue for those
in status 2 etc.

Access 2003/WinXP
How do I detect whether a subform is Dirty from the main form?
I've tried the following:
Forms("subformname").Dirty --> Error: Access cannot find the form

I am attempting to create a case on a report, dependant on a check box.
Basically, it will output a prefix to a part number only if the
appropriate checkbox is checked.  The first part works, but it fails if
the check box is not checked.  Any ideas?

For example, I changed the Tag.property.value of the tag 'december' to
'15567984'
The colour of the Tabpage will be changed correctly, but the color of the
Tabbutton

I had a table with a list of check.  That table has a yes/no field attach to
a check box in a form.  The check box is to specify if the transaction(check)
was cashed by the bank.
I want to add a field in a different form for serching purposes to show a

I need a way to keep people from opening the backend database files except
when they use the frontend.
I have a split system that works fine, the database are connected via mapped
drive from each pc(no server software here).

I have two subforms on one form. One being the Parent of the other. When I
tab through the Parent subform I would like the focus to move to the child
subform after I tab from the current record on the Parent subform. What is
happening is the focus will tab down through all the ...

On an Access database, I would like to recursively remove all data for each
table.  Some of the tables are linked with relationships.  
If it possible to write a procedure to remove all data for each table while
ignoring their established relationship?  If so, would I go about it?

I have a popup form I'd like to potentially call from more than one place.
So I'm trying to pass it the path to the calling subform and have it set a
control value on the calling form when it is closed.  So what I have is
this: