I have been able to build a query that is filtered by a selection in a
Listbox, but now i want to use a multi select list box so that two or more
items can be included in the query. I constructed the query pointing to the
Listbox but all I get is an empty dataset. How can this be ...

This is really strange, but I can't figure out what is causing this.
I have an Access 2007 application stored on a network shared drive. I
just created a new report, saved the report, and closed Access.
Then, I went to my wife's laptop, and opened the application from

I don't know if this is the correct approach, but this is the idea
I've got:
A form will have a few controls to enter some data and two buttons.
One button is "Enter as New Record" - this one opens a subform for the

The popup calendar I downloaded from Allen Browne's site worked in one
Database perfectly, but after I importing it into 2 other databases since
then it has not worked.  Ithas to be user error, but I can't figure it out.  
I receive the following message after replacing the ...

I have two tables: Table 1 stores the primary key, Protocol#, along with
details about the protocol. Table 2 stores additional information that will
apply to SOME of hte protocols. It has no primary key, but is linked to table
1 through Protocol#.

Hey All,
I have a query which allows users to score projects by a number of factors
which help determine that project's priority for funding. The various scores
are totaled and the project given an overall score. I would like a query to

I have a monthly productivity report that I print for a list of staff members
and the report content is fine. However, some employees have multiple pages
and I have to indicate page numberings at the footer (i.e., Page 1 of 7,
etc...).  The problem is that Access will indicate ...

I have a small app that distributes notification emails to different users
based on 2 criteria selected by the user.  I select the receipients based on
the input values they indicate. The distribution lists are static strings
from another file that I use... This approach has been ...

I created a Label using a Table in MS Office 2007 Access. The Field required
to be sorted is by Last Name.  I can print all the Records (not alpha),
however I want them in alpha order.
I must be doing something wrong.  Thank you.

I am having trouble getting live data in my Access Database. The data is
retrieved from Thompson One. In Excel, this is a simple formula such as
=ilx...As the market chages, the quote is updated in Excel. I would like to
have a text box in an Access form that is similar and ...

I'm attempting to write a SQL statement in VBA to select specific records
from a table but I'm not having much luck.  What I need to do is select all
records from Table 2 where Field 1 is equal to Field 1 in Table 1.  I've
defined a variable ("cl_ID") that I can set equal to ...

I have a form that contains record number information and alittle bit of data
based on this record number.  Each "record number" is linked to a couples
information.  This couples information is things like name, address, city,
etc.  When I'm on the first form, we'll call ...

I have several reports that mgmt needs to have totally on our fiscal year;
not the calendar year.  Currently, the report is totally on a week, on a
month, and then on a year.  Everything is working just great but the totally
on the year.  Our fiscal year goes from 11-1 to 10-31.  ...

Been racking my brain for this one but cant think!!
I have a form with 'Account Ref' as one field (and a company name field)
which is a lookup from a master table which has account ref, customer name,
address.etc etc etc.

In my table I have a field for quantity. I have the fieldsize set to double
and the decimal places set to 2. However it always rounds to a whole number.
For example when I put in 1.25 it rounds to 1....how can I make it display
the decimal points?