Is it possible to do the following in MS Access and if it is please outline
the conceptual idea of what needs to be done?
I would like the user to open a form [SearchForm] and enter a ID number
(primary key), or a last name, or a first name in a textbox named

I know there isn't room here for a complete answer, but I'm hoping someone
can direct me to a website, or even resources like books or training CD's
that can help me with a problem. We have an old mainframe that still works in
the realm of printing Green Bar reports. An upgrade a ...

My form exports a query. The query needs to select some or all "MICAP"s and
some or all "Project"s. My form has an option box [optMICAPS] and another
option box [optProjects].
When the option radio button is cleared, a combo box is made visible for

Help, I am trying to export a query of email address from Access to Excel.
The field contains the bare email, for example johnsmith@abc.com. When I
export to Excel, the return is johnsmith@abc.com#http://johnsmith@abc.com#
What can I do just to return johnsmith@abc.com.

I have created a report based off of a table. In my report I have listed
months, for example in this report I have listed Sept and Oct data. Next
month I will have Oct and Nov. and so on. I am trying to subtract a Sept
value from and Oct value. However, both values I have are in ...

I'm not sure why but my duplicate date records are not showing up in the
query.  In other words if I have two or more records with the same date (like
11/09/07 and 11/09/07) only the results of one record with this date is
shown.  I need all records to show even those with ...

Good evening everyone,
I have one TRANSACTION table that contains:
1."date/time" field (YYMMDD hh:mm:ss)
2."quantity field"

I have a database 'query' that has about 200K rows of data.  My user
population, and any given time, is interested in working with (charting,
excel'ing, powerpointing, etc) just a small subset of the data (for example,
all rows of data for a given month, to work on month end ...

I have two tables that are not related and would like to combine them into
one table (Table 3 below).
Table1:
Text Field1: Group

I have a field with yes/no, i would like to send an email if the field
= yes, i have done a macro to send the document to a member of staff,
but all the time, i want it sent when the field - yes only.
Any ideas?

I am building a database for scientific data.  All samples that we test have
a catalog number.  How can I prevent my users from editing this number or
warn them that they have when they are looking at data from a query?  I have
already set up user level secruty so that only full ...

I am trying to create a query that looks at a single table with a field call
region.  The region field begins with the letters SD, format is "SD REGION -
CITY".  I would like to remove the SD and CITY from the field leaving no
spaces but only the REGION.  I tried to use QUERY ...

I am trying to perform an update query to read fieldB and determine if it is
"Null" or blank, if this is the case then copy fieldA to fieldB's position.  
Or the other way around, if fieldB has the letter "a" then copy fieldA to
fieldB's position.

I have two queries QRY_CURR with the Curr_yr_bal, account, account type and
QRY_PRIOR with Prior_yr_bal, account, account type.
I want to create a report or a query with difference between Curr_yr_bal and
Prior_Yr_balance, But not all the account in QRY_CURR_YR is in QRY_PRIOR_YR

I have an append query which enters data into a table to do with the session.
(ie a Log File)
However, this query is ran in the autoexec query I've built.
Is there a way to turn off the confirm the message about appending data and