I have a form which maintains my main table. On this form is a button that
opens a new form where related records in another table are entered (I know
it could be a subform but for various reasons that could not be done).
My problem is that when creating a new record on the main ...

I've created a database that will contain information about
properties.  One of the fields requires the entry of a road name.  I
was wondering if there was a way to code the field so that it would
A)  recognize previous entries for roads so that as the person typed

I've got a form that upon selecting a a record from a combo box, the data for
that record is copied to a temp table that is used for a different form (to
update the data).  This 2nd form is an edit form for users to update data on
the selected record.  When this form opens, a ...

I have 2 forms; one for editing data and another for viewing the same data.
Both forms contain the same subform. I'd like to dynamically set the
ALLOWEDITS etc. properties on the subform based on each main form. How would
I do this?

Sorry for the bad Subject. Hopefully I can better explain my issue here. I
have ONE command button to launch a query. But depending on the time of month
and which month we are in will determine which query is ran. For example, the
date is today, 5/11/07, the query will retrieve ...

The code below was supplied by Susan Sale harkins for simple audit tracking.  
I have two issues with it.  Can anyone help me?  
1.  It only works with text box changes.  I would like it to also work with
combo box changes.

I am trying to setup a filter on my form that filters when a command button
is clicked.  I have a combo box that lists the various column names which are
products a company might have.  When the button is pressed, I want it to look
at what the value is in the combo box, and then ...

I have 2 irritating issues, and I'm hoping someone can help. I haven't
found a solution in Help or searching posts.
1. Field displays #Num or #Div/0 on new record.  Calcs correctly after
data is entered.

  I have a report(labels) that have 5 textboxes with single value from
either 0 to 9. so text box 1 could be 5, and text box 2 could be 8, and so
on...So when a text box is with a certain value, i want it to load an image.
so if text box 5 has a value of five, I want it to load ...

I have a table, tDistrictSub, in Access 2003 that contains various pieces of
information.  The relevant fields in this table for this problem are:
DistrictIncidentNum - the pk (always a 9-digit number, then a dash, followed
by another 9 digit number)

I am using Access 2003.
I am trying to add an Event Procedure in the AfterUpdate Property on my main
Form
Basically, I have a field called "Complete" and it is a Yes/No check box on

I have a subform bound to an unbound textbox and I'm trying to figure out
how to have a msgbox appear if no records show from the entry in the textbox.
I've looked elsewhere online and cant find anything I think can help.
Thank You

I would like to have a form that the user can change the information that
displays in combo boxes in the database.
What I would like is a form with two list boxes the first form has a list of
all the comboboxes in the database, I can do this using a table with them all

I have created a database with a single data table [tblProjects] with a
[ProjectsID] Autonumber Key field, a [ProjectTitle] text field, and a
[RankOrder] Number (integer) field. There is a form called frmRankOrder
(recordsouce tblProject) with 2 unbound contols - ListBxRankOrder ...

I was wondering if there is a way to format the information sent in a email
from an Access Form.
Example:
Here is the code I am using which I obtained from this Forum: