I have a table with some columns that have small data in them i.e.
just two characters. The Column header has something like "QTY PER".
If I don't want to crop the header text I have to have a column width
dictated by the header. Is it possible to wrap the text like in Excel?

ok, I am attempting to do this without a massive amount of queries
each doing a part of it which would be really easy but not "right" and
would result in poor performance I'm sure do to the loading time on
each query etc. What I am trying to do is filter down the results by 2

Hi all, I'm working on a database to track when mail comes into an office and
put a date stamp on it so we can track how much of each type of mail is
coming in and worked each day. I'm trying to create a function for this date
stamp where if the entry is put into the database ...

LONG STORY/QUESTION
Right now I have a few spreadsheets (separated by workshop location) which
contains various pieces of information (same type of information on each
spreadsheet). Right now I am one of two people who make updates on this Excel

I am trying to create a dynamic form.  Here is how it works: the user selects
a query, and hits submit on a menu form.  A form is then created and the
record source is assigned based on the users initial query selection.  Now
the question/problem:

How can I set Access 2007 up in order to have the windows (forms,
tables, etc.) open in separate windows, accessible from the MS Vista
taskbar? In short, I would like to have Access 2007 behaving likewise
Access 2003, regarding opening windows.

I there a property or some way to make the record-counting number at the
bottom of a form not show?
Robert

I did an append query. Table A doesn't show any of the added records from
Table B, but the auto numbers jump from 1808 to 3038. Can I get rid of those
unseen records from 1809 to 3037.  My Table B is still the original one and
hasn't changed.  Is it possible to recover Table A ...

I am trying to run a setvalue macro with the press of a button on a parent
for which will cause toggle the values of a field in the subform between
positive and negative numbers. When I simply run a set value on that field,
it toggles the first record but no others.

is it possible to get smart tags to appear on forms?

I would like to know how I can count how many records have the same letter.
For example, how many records start with the letter A, how many for letter
B, etc.
Seems simple enough, but I can't figure out how to work this.

I am trying to do a conditional avg in my report footing.  I would
like to avg values that are on the same row as an item between 7000
and 9000.  for instance
6000            2

I don't even know if this is possible but ok here it goes I am making
a database and I would like to make a report that shows the data I
have on a form for new records that i would type in but NOT save the
records into my table so I can print the data out if need be but maybe

Can I pursuade Access to show me decimal places on data I have already
entered.  At the moment everything gets rounded up or down.  I've done what
is needed to change for future inputing but old data is still not showing
what I want.

I have a form that is used as an input sheet to update a table.  i want to
use a combo box on the form used to input data onto the table to eleminate
error. For example, one of the input fields is "Supervisor"- I have created a
table with just the supervisors names and added a ...