I have a list of the following: Name, Date, Number
I want my record to look like this:
Names: Name1, Name2, Name3, ...
Date: Date1, Date2, Date3, ...

I'm having problems copying subreports when copying a report.  Is
there an easy way to do this?  My childlink is not a AutoNumber but it
is a number (which should make is simpler).  I just want to set the
childlink to a 0.  The keys are the primary keys.

On the report [Total Sales by Supplier] I have a column in the
ProductID HEADER for the Total Cost per item along with number of
units ordered, received, sold, total sell price. In this section the
totals are correct for all columns, however, when I do a SUM (NB: this

I have a function in the OnNoData event for all my reports. Since converting
to Access 2007, some reports w/ no data will come back fine with the
following code. However, it seems a few that are more complex will crash
Access2007 (you get the Send error report dialog), I think it ...

I've coded Access 2003 to produce automatically a standard letter in
Word 2003 using mailmerge. It was far more difficult than it should
have been and maybe I missed a trick.
Whenever I connect the mailmerge to the data source

All,
I've been in the process of creating a database for work to keep track
of customer calls, contacts and orders.  Obviously, as time has gone
on, the number of users has expanded.  During this time I have been

I've had the following problem a few times over the years and from
memory it's always been with Access 2000.  It happened again
yesterday.  I made a small change to a subform that contains a few
fields including 2 date fields.  The change was to make the second

Article in SD Times
http://www.sdtimes.com/download/images/sdtimes179.pdf
Microsoft SQL Server is still
No. 1. According to the 2007

I'm trying to update (reQuery) a form on a tab, and can't get any tab-
related events to kick off my code to do so.
My tab is named "Other_Individuals"
Can anyone tell me why the code below won't work?

I have created a custom toolbar in my Access application. The toolbar
has a button that runs some code. When I copy this Access mdb to
another computer and run the application the toolbar does not display
the button nor does it run the code.

I am constructing an order number and a Job number based database and I want
the order numbers to automatically increment to the next number, I currently
have used a combined key to achieve this but don't know how to make both
parts of the key display on the form and don't know ...

I have 3 tables of information feeding into 4 combo boxes on my main
form (DR Form).  I have as many list boxes (acting as text boxes) as
there are fields in each one of the 3 tables.  Once selecting from the
combo box, I have all the combo boxes, using afterupdate, populating

I have a table with the following:
Name
Number
Date

Morning,
The Non-conformance file we use as part of our Corporate GMP
Manufacturing complicance has a number of check boxes that users (7)
can select when determining what category a non-conformance falls

Newbie question:
I'm looking for the easiest way to run SQL statments in Access. I'm
getting confused by th GUIs - I'm just looking forhow to run SQL on a
table- thanks