Hello all -
I have a table with 6 fields and 1100 records.  I use a crosstab query to
view the data in the format I need.  That works great.  When I try to export
it to Excel, however, I get an error of too many fields defined.  Using the

Hello, I was wondering If I could email a copy of my database to anyone. I'm
trying to subtract 2 fields to get a balance. I'm not familiar with all the
access terms to tell what I need. I don't know if my table is correct also..I
need a lot of help!!! I think I could explain  if ...

hi how r u doing

Hi, I am quite new to Access and I have no idea how to solve this. I have
three fields, the first field's content is say, "You". The second field's
content is "Win". After I input these two fields, is there a way to let the
third field automatically fill in "You Win"?

It should allow me to link staff to those policies and procedures that apply
to their positions in the organisation.  Ultimately we hope to create one
large dB to hold all standardised information that all staff can access based
on their positions.

I have my references set to Outlook 2007 within Access 2007.
When I try to send mail from Access 2007 it bombs on the statement
  With .Recipients.Add(Me!txtTo)
The error number is 287.

I have a customer service database.  I have designed a form with the usual
information on my customers and in the corner I have a Web browser object
that shows their location in Google Maps (.  This works perfectly and I have
a button which when clicked will print the Web browser ...

Can someone tell me how to delete or overwrite an attachment file which is
created in the process of e-mailing a message with the attachemnt from ACCESS?
I create a report  which I want to attach to an MS Outlook e-mail message.
In looping through the recipients I get a warning ...

For years my office has been exporting data from a SQL BE via Access to a
spreadsheet. It takes 1 person 10 hours to change the data based on a bunch
of different conditions. Then they run reports from the manipulated
spreadsheets, because they are not permitted to change the ...

I am experimenting with making my databases into a ACCDE but the first try
resulted in VB code not working in the forms after conversion. Am I missing
something when creating the ACCDE?

Help! I need to relate the content of two different forms in access 2007
using an element (id or control number) of a common table.  How can I do
that?  Thanks!

The crosstab query below works. However, I would like to add the following
condition to the query:
TotInv: IIf([InvType]="Cost
Invoice",[TotNonUCRClaim],([ServCodeRate]*[UnitsUsed]))

I would like for a field (Total Visits) to be populated from the addition of
Hospital_1 + Hospital_2 + Hospital_3.
Would I be able to use a macro or query so that this occurs automatically?
Thanks in Advance!

Access 2003. vista.
I have an application with 5 users.
This application is splitted, 1 file is the application, the other is the
data, and the application is linked to the data (Tables) file.

I Have a table containing 2 fields "IDName" and "CustomerName"
The table contains 5 records and it is like this
1     Paul
2     Mike