I have a table of letters with fields LetterBody and LetterSent, among
others. I sort letters based on value of letterSent, i.e. 0 is not sent. I
open a report with Lettersent=0 and print those letters.
What is the best way to mark all letters as sent?

Does this mean a zero got in there somehow?

I am trying pass values from a dialog box back to the main form. I am not
very experience in Access programming but I believe this can be done. My main
form has a combo box and depending on the selection in that combo box the
user is required to answer one of two questions where ...

Hello,
I have a form to enter follow up information, when the user enter the ID#,
it look up the old information, and also have fields enter new information.
The ID# is unique, no duplicate. The information enter into this form is save

I need one of the fields in my form to update automatically with a
calculation of 2 other fields in the form if either of the other 2 fields are
updated. Example:
3 fields are:

Does anyone have any suggestions on locking the user into an application
so that they only go where you want them to (more or less, they do have
some choices!)  Is there a way to map it out on paper?  Whats the
easiest way to do this without getting lost or confused as I'm doing

I want to create a Form automatically with VBA. I have
succeeded to create a new Form and create controls. But
if I want to fill in the Recordset property (Set
NewForm.Recordset = rstRecordSet), I get the error

I have created custom navigation buttons. Is there any way to get them to
position like the built-in navigation buttons where they 'hug' the bottom of
the screen and do not move when the form is scrolled up and down?

I have a search tool used to look up a last name, it then opens a view
screen (View_Customer) based off of the search criteria from the previous
form.  On the view screen, I have a button to add notes, that then display on
the view screen due to a requery of the view screen when ...

If your Acess Database becomes corrupt for whatever reason.  Is there a
way to still access the info in the tables.  Also I thought of backing
up my access tables as CSV files is this wise?  Is it a good idea?  My
database will be split as well.

Is there a way to compact and repair your database from a form and have
Access reopen it's self?
Thanks
DS

Hi, there is probably a pretty simple answer to this but here it goes:
I Have 2 toggle buttons which alternate with one another, they both bring up
different forms while hiding the other form what I want todo is to click the
next/previous record button and for the the record to ...

I have a form that I wish to disable the wheelmouse on. I have followed the
directions given here: http://www.lebans.com/mousewheelonoff.htm.
However...
This particular form will be left open most of the day. From this form users

I am trying to open a Report and at the same time change a lable control
"lblControlHidingForm" on the report using the With Statement.  Below is the
code I am using but the labels' caption is not displaying the text
"frmMainSwitchboard".

I have a subform that I use to delete records that are not needed (usually
duplicates).   Deleting the record is no problem, but once the record is
gone, the reference is still in the non-refreshed listbox.  How do use VB to
refresh the listbox?