if field 1 = "100" the put "2" in field 2

I am dealing with a strange error, that it seems not to be very hard to
correct, but I am really curious about the reason why it raises.
I have a bound form with a save button. When the user clicks that button,
the record gets saved by the following statement:

I have a table with a logic field and a form that uses checkboxes (7 of them)
to enter the data for a single record. Now I need to export the data in Y/N
(text) format for uploading to another database. I prefer not to change the
user interface because they are accustomed to the ...

I am looking to create the following event.  When a form loads I would like
it to email me a file at home every 2 hours.  I know how to handle the email
part, I just do not know how to handle the code to monitor the time and or
create a timer that counts and executes the send ...

In Access 2000, I'd like to create my own navigation buttons, but I've never
done that before.  Does anyone know of a website where I might get code
someone has already set up?  Then I can modify it.  Thanks.

I'd like to get the path of the current database from inside VBA.
Is this possible?
E.g. If my database is \\server1\Access\MyApp.mdb
I'd like to get "\\server\Access\" somehow

Hi.
I would like to have a progression bar in my form until an action is being
executed.
Something like a rectangle that shows de progression from 0% to 100% as an

I have a form "frmAirspaceBlockSched" that is bound to a View and I open it
to the date selected on a Calender Control with the following VBA code:
   stLinkCriteria = "DateSched = '" _
   & Format(ocxcalender.Object.Value, "yyyy-mm-dd") & "'"

I need to bound only the ID field, however, I want to show the asscoiated
name to each id in the form as well.

I have a form that contains a subform that acts as a navigation/search bar
for student info. On this same form I have a tab control; on one of the
pages of the tab control I have a form with student data.  I would like to
click on a student record in the navigation/search in the ...

I'd like to loop through the controls on a form and change the backcolor of
a control if it's data is locked.
Should I use the on_current event to call a function?
I'm attempting to modify the control naming function on the Access Web site.

I would like to truncate a text string, not just by character length, but
also taking into consideration not truncating in the middle of the last word
in the string. Therefore, here is a sample situation:
1. I want to truncate at 25 characters from the left.

I have created a text field for users to enter a password. How do I arrange
for what the user enters not to show and instead show just * symbols for each
character entered?
Thanks, JohnB

OK since my last request wasnt clear enough for some people let me try this
again.
I have a form where i select a value from a drop down list. This then
populates part of the form.

When adding a new record it appears that a form's recordset is not updated
until AFTER the AfterInsert procedure completes.  Does anyone know of a way
to know when the recordset has actually been updated?  Even more importantly,
when the changes have actually been saved to the ...