I know you guys like details so here they are.  Running Access 2003 but the
database is based on 2002.
I have a nifty new little form to update people's addresses. I want to
select the city and have

Have a query that is arregated into crosstab query, it is working
correctly.
select Yes as selected from tblname
or

I manage a few databases that have macros that generate email
reminders to groups of individuals. These macros work correctly on my
computers as well as one of my coworkers. However, the people who are
actually supposed to send these reminders are having problems. When

I'm thinking ISO 4217 as shown on
http://www.xe.com/iso4217.php
Bond trading system.
Users are definitely OK with all of a given security's trades

I have a trigger created for Customer table.  My front-end is access.  What
is the best approach to handle a trigger result when adding a new customer
record?
Below is the trigger script:

I am using a wedge barcode scanner to enter data in an access
database, but for certain combinations of characters I want to parse
the input in code and react accordingly.  The keypress event on the
form only gives me access to the first character in the string, is

Hi Everyone
I am using Access 2007 and have found that when I open a report and change
the criteria in my record source the information is not being saved when I
close the query builder.  Any suggestions, thanks.

I am trying to run a report, but I get the Microsoft Visual Basic Run-
Time Error '2471': Unknown
I googled the error and found that the Run-Time Error 2471 points to
an "Item in query".

I need to have a form filter from two differnt fields.
First the user needs to be able to pick from a list of categories.
Then the user needs to be able to choose a size from the results of
the category.

HELP!!!! I have a form with a combo box to select "Staff ID" and a
Calendar which puts the selected date into my "Date" field. These two
fields are the criteria for my parameter query. I then have a form
which reads from this query. This works fine!!! :)

I have had this problem MANY times and I just don't think I have the
best solution.
I am running a parameter query to retrieve records where work was
completed between 2 dates. The "completed date" field contains both

Access 2002.
I import tables from another database where I only copy the definition
and not the data.
I select the Import Relationships option on the import dialog. After I

I am working on a form where one of the checkboxes asks if there is a
document associated with the record?  If you user clicks to check it
(i.e., "Yes"), I would like these events to occur:
1.  A browser displays giving the user the chance to drill down to her

I want a calculated control to transfer its value to a bound field in a
table. I.e. I have a calculated control named txtFinalBid that adds several
fields in a table. I want that number to be transfered to a bound control in
the table named FinalBid. I've tried using all of the ...

I'm using a sproc to query a SQL Server table with about 300,000 rows,
but when I query the table using a select query, it returns only
exactly 50,000 rows. The front end is an Access 2000 application. I
suspect that's the culprit even though max records is set to zero?