My client insists that the printed copy of text entered into a memo
field have EXACTLY the same layout as it appears on the screen.
I found I had to eliminate the vertical scroll bar.  Then I copied the
memo field from the form to the report.  I verified that the font and

OK, so I was able to build forms using combo boxes to select query
criteria... however, now I want to know how to save those forms and
save the criteria that was selected so I can close the form but the
query will still run w/the selected value.  Is this possible?

Why can't I write to a field name 2ndItemNumber with
rs!2ndItemNumber = st2nd.  When I type that in I get a message expected end
of statement and "ndItemNumber" is highlighted.  I know it has something to
do with the 2 but I can't figure out how to get around it.

I have a new client who has an Access 2000 database that used to run
under Windows 2000 Pro.  They have just "upgraded" to Access 2007
under Vista, and the old database stopped working - buttons on forms
did nothing.

A97 crosstab queries are limited to 255-fields.
Does any later version(s) of Access support a
greater number?

I am doing some volunteering for a local non-profit aid organization
and not very experienced with access.
I have a table which is a list of Federal Poverty Line cutoffs based
on the number of people in a household.

This is a repost from a couple of days ago.  I didn't get any
responses, and am really hitting my head on the wall with this.  Even
knowing that it is a complete impossibility would be welcome news, if
only so I can stop hitting my head. :-)

i have a table with 12 checkboxes for different type of products, so
basically user has to tick if this product applies to the entered
account. So, i have the same group of boxes in my report which i want
to modify in a way, that instead of the checkboxes i would have text

I am having some trouble with an SQL statement that I just cant seem
to get to work. I have imported some data into MS Access from another
application and have a single table with information in it.
There are a number of columns, and I am trying to do a 'summary' type

Apologies if this is not in the right area but first time for posting
here.
I know how to add up amounts on a form to create a total for a line
but the database i am working on needs the total to be unique for each

I've searched this forum and trawled the wider web and can't find any
information on how to hide or disable the A2007 Quick Access Toolbar.
The toolbar is not something that one wants available to the user in a
custom application.

I have created a database with approximately 60 tables. One table
"tblClients" needs to be linked with about 40 tables. Some are simply
look up tables. Others hold multiple records for each client, for
example children information. (One client can have many children.)

I have a table named "Services" which has a "ServicesID" field as a
key, GuestID, ServicesType and another field called "Bed".  When a
guest stays in our shelter, a record is produced in Services that
includes the GuestID, ServicesType (in this case "Men's Dorm") and a

Is there a way to get rid of that horrid 'ribbon' and go back to a
'normal' menu structure in '07?  I'd like to continue to develop and
distribute databases (preferrably with the access run time) that use
custom 'normal' menus and none of the horrid ribbons that are such a

I am new in MS Access and I was tasked to create a porject.
I have done some initial things already but need help and guidance:
- I have a text field in a form where users are allowed to enter data.
I need to ensure that the value that the user enters is unique (ensure