I have a form, which I'll call Form1.  It's bound to a table (Table1).
Form1 has three fields Field1, Field2 and Field3 which correspond to
fields in Table1.  Field3 is the sum of Field1 + Field2.  I have an
AfterUpdate event which runs a macro if Field1 or Field2 are updated.

Hope the subject is sufficient.  Here is what is going on.
I need to create a form that will display data within a date range...
no
biggie.  However, I'd like to keep it as close to the example I have

A number of people design systems with an Access front-end linked to a
SQL Server backend.  Can anyone please recommend any good books which
set out how to do this?
I am interested to learn the techniques of building a .mdb (not .adp)

I have 2 tables. Table1 has Zip Codes from many cities, also table1 has
a field(yes/no) that says "houston". Table2 has zip codes from houston
city. I want to be able tu run table2 against table1 to compare
zipcodes and if table1 has a zipcode that match table2, i want to

I am trying to change a subform in access 2003 based on what is
selected in a combobox
But to change the subform I would have to do something like
Me.subformOPS change sourse object to Me!Combo18.column(1).value

About 4 years ago, my boss's son, for some reason, purchased a copy of
Access. Also for some reason, I ended up helping him get an application
going. Well, after finding out what Access was all about, I fell in
love. Access is now my favorite program...BY FAR!

I have a table that tracks the entry of certain datapoints.
tbl_data_entry:
data_type_id (ties eventually to a department, formatting, etc.)
employee_id

Greetings! I am using Access '97 to track company orders. It's a pretty
basic setup featuring a main table (tbl_SalesSlip) and a related table
(tbl_ModelsSold). I would like to send an email that contains
information from both tables, but am unsure how to go about it.  The

I have a new database in which I have a form where in one field I type
a letter A, B, C or D and the field next to it autofills (auto lookups)
with a description associated with the specific letter.  If I edit the
description for one record, it edits the same for all records in ...

I have an access dbs with 2 key tables. One is a State table that has
State id and State name fields. This feeds a combo box in a form to
provide a reference point for the State Id field in the Main table.
This allows multiple State instances, as I am mapping a number of

Hello, every one:
If I want to move tables from Access 2003 to Back-end SQL Server,
should I use Dababase splitter or upsizing wizard? or just import
tables?

I have an MS Access form attached to a table. I have a text box which
has its control source set to a field in the table...
However, at run time if certain things change, I want to the change the
text box value to the new number, but I'm unable to do so. I get run

My table has the following fields
ItemNo Name ImageName DateRecd
123 Foo 00123.jog 1/1/06
123 Foo 00FOO.jpg 10/11/06

In Access VBA, the immediate window only displays a couple hundred
lines of my debug output. How do I display more lines there, for
example 500 lines, or even 5000 lines? Is there a way to set the line
size in access VBA?

Ok, i have a Access Database (which is used with my ESRI Arcmap) and i
have written a query for a report to pull out our streetlights and
group them by billing wattage.  The problem is that it is counting the
number of lights and summing them like i have asked, but in some cases