As of yesterday, a few databases stopped showing data in list boxes
and combo boxes. The row source to these fields have not changed and
they show the correct data in the query. The column widths are correct
and the fore and back colors of the fields are not the same. This just

I downloaded Allen’s great mdb sample for the kind of the form filter I was
looking for from http://allenbrowne.com/AppFindAsUType.html, it works awesome
but I need this exact kind of search to filter a datasheet subform, any help
on this?

I'm trying to include multple names in the'To' field of some DoCmd.SendObject
code.  The code is pulling from a query labeled 'qryEmployee'.   I'm not sure
how to separate the names so they both appear on the 'To' line of an email.  
Any thoughts?

I have a query that lists all products i have sold what i would like
to do is do a count of each product for the number sold each month
I know how to extract the month for the date by using Month:
Month([OrderDate])

I've played with Access before and have recently written a little set
of tables for my daughter's school chess club. I now like to expand
this to do some rating of the players. For this I need some
calculations performed on each game each player played. I think this

yo

Hi,everyone.i have a big problem here.i accidentally exported my table to my
split file and now when i try to open the table,it shows "the microsoft
office access database cannot find the input table or query 'filename'.Make
sure it exists and that it's name is spelled correctly ...

I am working for a education organisation. I want to create a database to
store applications, and services allocated to these applicants in separated
tables, and all other related information.
I store the application in one table, and when allocate services to that

I am a self-taught novice so please bear with me:
I am a teacher and have created a scantron form using Adobe Live
Cycle.  The form uses radio-button groups for students to enter their
answers into.  I export the data as an .xml file and then try to

I have this Access application with a few forms with buttons that update
tables, call other forms and creates reports. The application is saved on the
LAN in a secure location with limited access to it. Last time this
application was used was end of Dec 2007. In Jan 2008 we ...

I would like to take data from 3 different columns of data and recombine to a
different format in another column.
The original data is a series of numerical and text codes.
first column, second column, third column

How do I associate a custom menu with a specific .MDB file?
I recently distributed a copy of a database I created to several users.
Within the database I had created a custom menu, and attached it to the
default toolbar.

I am getting the following error: "you tried to execute a query that
does not include the specified expression 'Y' as part of an aggregate
function. Any ideas?
select TOP 5 sum(x)

I have a form where people input invoice data.  Within that form is a subform
where details of the invoice are entered, such as product and amount.  The
main form is linked to the Invoice table.  The subform is linked to the
Invoice Detail table.  The two tables are joined by the ...

I want to set up a select to get the sum of a value but I only want to sum up
the first 5 rows.
Example:
select sum(x)