Is there anyway I could set up an UpdateQuery based only on the current
record as specified by a the user on a form?
I've tried this myself, but my UpdateQuery changes all the records
based on the criteria..

I have a problem.
I am writing an application that has the all of the forms, queries, and
reports in one database and the tables in another.  They are linked together.
The good news, when the database with the tables is on the local drive,

I'd like to use access to convert a sql server table (using an ODBC
connection) to a MYsql table (again using an odbc connection) and I
have all the field mappings worked out except for the  time stamp.
is there a function within MS Access to do the conversion, if not - is

I have a table with many fields, some of which are years as field names.
One of the field names is "Base Year".  I want the some of the field names
to change based on the value in "Base Year".  For example:  If "Base Year"
is 2005, I want Field1 to be named "2005", Field2 to be ...

I have two tables.  In one table, there are lines with various dates which
contain information that I will eventually summarize based on Fiscal Months.  
In another table, I have the the start and end dates for the fiscal months.  
Table 1

I have a question and Im not sure if there even is an answer for it.  I have
a database of programs.  In a separate table I have a list of approvers for a
design.  One row per approver.  Now a design can have any number of approvers
and I want to combine there names all in one ...

I've got a table of clients and I want to search for employees born during a
certain month. For example, my birthday field is [Date of Birth]. When I run
the query, I want to be prompted with this prompt: "Please enter the
numerical value of the month." I would put in a month, 08 ...

I like the templates that are designed thay relly helped me I am trying to go
in the resturant buisness with someone my part of the business will be making
breakfast
what kind of tempates can I use to make a menu

I have a contacts database in which I have birthdays listed for some (not
all) of the contacts and in which years of birth are know for some (not all)
of the contacts. I have 2 date fields I'm working with: DOB (full date of
birth), format mmmm dd yyyy, and MonthDayOnly, format ...

I have the two following queries:
SELECT Items.ItemCode, Count(Items.ItemCode) AS [Count of Multiples],
Items.Cost
FROM Items

How do I create an append query that adds a group of records from one or more
tables to the end of one or more tables?

I have a crosstab query that sends back a variable number of columns based on
the particular criteria feed to the underlying query...that of course is the
nature of a crosstab.  However, if I look for a particular column that is
possible through the recordset index (rs(x).Name=". ...

I have an Access query that looks like this...Criteria: Like "*71-0246*" that
reports non-like numbers as well.  Why might this be?  BTW, I've tried to
eliminate asterisks with no change.  Also, duplicate table entries appear to
be returned.

I have a membership database where it lists the member ID and the start and
end dates of their membership.  I need to run a query to count the number of
members in a certain date range by month. (for the last 6 months or year)  
The date range will be entered into a form.  How do ...

I am using Like "*[!-!0-9A-Z &,.@/'():+]*" in my select query to exclude all
characters listed but the query also excludes accented characters? Is there
a way that accented characters are not included in this filter?
Thank again.