i have created a form with a checkbox that is checked if the current
record is found in another table. This works perfectly with a
selection query. Now I want to append the record to the second table
if the user checks the checkbox and delete it if he unchecks it.

I have an order form with a field on the form for Revised Date.  Does anyone
know if there is a way that if data is entered into this "Revised Date"
field or if the data is changed in this field, is there a way to send an
email notification to someone?

Hi to all,
A couples of months ago I was looking for a good way to handle a many-
to-many relationships.
I finally found this sample db: http://www.accessmvp.com/KDSnell/SampleDBs.htm.

I've got a form bound to query - an updatable one. Now when the user
clicks 'SAVE' I need to force saving the data to a table it's bound to
so that I can open a new recordset with updated values - before I
close the form.

Autocenter center the form in middle of my screen between left and right
only
I want to center the form in the middle of my screen top and bottom also.
I will tell you an example :

We have a modal dialog in an Access application, that upon confirmation goes
out and does about 25 minutes of queries and then puts the result on the
clipboard.    This long processing period locks the user out from the rest
of the application.   We want to find a way to have ...

Can someone assist with helping me with code to select each text box one a
form and get the name of them.
Adapting other sample data I have I believe it is something like....
For Each tb In CurrentDb.?????

I have a textbox that contains a date.  When that control has the focus, I'd
like to be ably to key in 'y' to move the date ahead by a year, and key in
'r' to move the date back by a year.  How would I do this?  

I have a student check in screen where a main form is refreshed with the
timer every few seconds; when a user swipes their barcode card a popup screen
tells them they have successfully signed in. This screen is up for 3 seconds.
If someone tries to swipe in during this popup (We are ...

I am developing in MS Access 2003 and I'm trying to have a form
automatically calculate average values for me. I know I should calculate
these values on the fly when the data is queried. I ultimately would like a
button which the user would click to calcuate the values.

This works fine if there is a date in the textbox, but if the textbox is
empty or null, I get an error.  This is part of an SQL statement.  What can
I do if it's Null so that it still works.
Thanks

I have a list which shows the location of all my units.  I would like to
create a timer event that when a unit is at a location for a specific amount
of time, the time would flash the background of that unit on the list.
My listbox is based on a query and shows the most recent ...

I need to force user not to enter "%" sign into a text box. OnExit
event of text box, which code sould i use, so that I will make the
CANCEL=True?
I can do that by placing ComboBox and defining a criteria on the query

 any form contains microsoft calendar contorl ,when i try to edit or run it ,
the access crash atonce ,i tried many things
this the debug info
AppName: msaccess.exe      AppVer: 11.0.5614.0     AppStamp:3f3c8e3c

I'm trying to delete a record programatically, this is the code;
Dim db As DAO.Database
'Dim QD As QueryDef
'Dim where As Variant