How do I set a constant value for a field name in a query?
E.g., I have a query containing "Suffix: FamiliesSuffix" taken
from table "Families". I have a situation wherein I need the
value of Suffix to be "False", no matter what is in FamiliesSuffix

I have an event procedure that when you click a check box it puts a date in
another box like so
Private Sub CallClosed_Click()
If Me!CallStatus = "RF1" Then Me!CallStatus = "RF2"

I have a database with two tables.  I am using a form with two unbound
text boxes and combo boxes to capture user input.  The problem is I
want to be able to update two tables from the same form.
The form has three fields first, surname and gender.

I would like to create a subform which would populate
depending on the choice in a combo box at the top of my
form.
The cbo is named cbosite, all the fields to fill are from

I can find buttons in the wizard to do almost everything
i need but I would like to have a button allowing the
entire form to be cleared and back to how i is when a new
record is created.

I am trying to set a Form Variable depending on the value or Openargs.  This
is what I have...
Dim frm As Form
Dim strForm As Variant

Hi I have multiple users on laptops out and about I have
created a file with which I collect data and readings.
I would like to be able to output this information and
send it as a csv file for use in a main file to be

I have two Subforms on a form. The left subform to enter multiple entries and
the subform on the right to view. I want the subform on the right the show
the new entry on from the subform on the left once it updates.

Hi to all,
I would like to know how to programmatically hide the table window in
Access, I know about startup option but when using the shift key, the table
window still show even when I uncheck the advance option

Hi How do I always get my access database to open waiting
for a new record to be typed? I need this instead of
showing an existing record because the primary reason for
opening the db for 99% of people will be to add

Here is another issue I am having with the same procedure:
<Snip>
frm.Requery
rst.FindFirst "[confID] = " & [SalesConf]

could someone please tell me how to set microsoft outlook up so i can e-mails
from there at present i can only recieve them. Everytime i send a mail a
progress box comes up telling me 0 of 1 messages sent successfully. at the
bottom it also explain there is a problem with my ...

Normally I automate to word from Access and insert data in the word document
at specified bookmarks.
Now I need to open a document and create a table and add some rows to it. I
need to use late binding.

When you create a labels report, Access adds the TRIM function by default.
The problem is in Access 2000 v9.0.7616 SP-3 the TRIM function causes
"#Error" to show up in the view window instead of data. If I remove the TRIM
function and just leave the field names preceded by an ...

I would like to be able to store a color value in an Access 2K2 table for
use in Excel charts. For instance, Access will have a color stored in a
table of brands for use in charts displaying sales of that brand. The
ultimate goal is to automate the generation of excel worksheets ...