When I try to import an Excel Spreadsheet into Access I receive the following
error message:
"The Wizard is unable to access the information in the #fileName#.  Please
check that the file exists and is in the correct format."

Maybe a daft question but how can I make table alterations after I have
split the database?

Okay.  This DB will be the death of me!!!
I am attempting to manage equipment maintenance in a military unit.  I have
5 guys who enter data, and I need a LOT of reports.  The one I'm working on
right now has been built fairly well...I thought!

Pretty New To Access - Apologies if this is striaght forward!
I have a form which i would like the user to be able to select a company
from a combo box.  once they have made the selection i would like the
companies details to be populated in the text boxes below, from where the

As someone who's never really used MS Access I need some help
please :)
We have a requirement to retrieve data from an MS Access database
running on a Windows 2000 server from a J2EE application server

Is it possible to open the query design window directly to the SQL
View in existing queries or in creating new queries?  Presently it is
two or three clicks to get there.

I have a query with 2 fields in (Unit 1) and (unit 2)  I have added a 3rd
field which is called results
I want expression in results field that states full award if unit 1 and Unit
2 both state "Pass" otherwise leave blank

HI,
I have three subreports on a report, but I would like the totals from two of
the subreports to be totalled into one final total on the main report. But I
can't seem to get anywhere with this  I keep getting error messages, any

I am trying to print address labels on an Avery sheet (3 columns by 7 rows),
but all I can get is 1 label per A4 page. Can anyone suggest a solution
please?
Robert

I have been trying to hide access and just display the form to the user, I
found a thread on this site and used the following function code:
Option Compare Database
Global Const SW_HIDE = 0

How do you delete a hyperlink in a current opened database and create a new
link to another table in another database using VBA?
TableName linked to DatabaseName.mdb which is "C:\Folder\DatabaseName.mdb"
Change to:

I haven't got used to using the new windows mail. Do  I need other mail
account. What type of account do I need?

I am trying to open the BE and have the FE CLOSE from a
button. But I can't find code to do it. I have tried different options
and none work.
I want to be able to sync a replicated BE but I want end users

Has anyone got a database OR know of an access one that can handle data
tracking for animals (farm) such as cattle and sheep.
It must include things such as date of birth; weight, bought and sold dates
to and from whom; sex; breed; mother and father details and ability to

i have a database of about 5000 records.  how do i take out the old ones and
store them so they are retreivable, but not in the same database as currently
being used, as it is slowing the database down.