I am trying to import an excel spread sheet into access,
which I have done 100s of times.  The spreadsheet is just
200 or so cells that will be my column headings. At first
it seems to have worked but when I try to edit the design

Help,
I have been unable to convert imported fractions in the
format 4 5/8, 4 11/16, 11 13/16 etc. to a decimal.
Any ideas?

Hi I am putting the finishing touches on a database and
can't figure out how to have my query look up forms. I am
new to this. What we would like the database to do is
when I type in the address to search for to have the  

I am getting dizzy from going 'round & 'round with this.  
Perhaps someone taking a fresh look from the outside can
see it more clearly...???
I have numerous individuals who are not familiar with

I have a problem and need some suggestions how to handle
this.  I have developed a database that workers use as an
assessment.  I have normalized the data as much as
possible.  The problem is that I have a huge amount of

Windows XP
Office XP
Total access newbie here, so I hope I phrase this question correctly.
I import data into a table as a text file and once imported, one of the

I've searched my help menu and manuals high and low and
can't find a way to switch the text justification in one
of my data table's fields. It's currently stuck on right
justify, and I'd like it to be left.

I have built a database for keeping history of maintenance
of machine on our plant. It includes all data about the
specific machines (Identified by PM Numbers) Daily
Maintenance records are not a prob..just enter date

two or more one to many relationships.
Is it possible to have two or more "one to many" relationships of my table.
Thanks,
Marc

Using Access 2K2
Exp. level: Beginner
Background:  We are a non-profit engaged in avian (bird) research.  We have
a list of about 1900 points of contact in an Excel file that had categories

Can you please tell me the operational model of
relationships in Microsoft Access? What does it really
do? Does it create a separate table where it holds the
relationships or something?

I'm modifying an old system that uses custom toolbar icons. Since many of these functions no longer exist, I'd like to get rid of this toolbar altogether
Its the toolbar underneath the 'File View etc. command bar
What is this called and how do I manipulate it?

I have a VBA roiutine that adds records to a table. This table has an autonumber key
There are a series of numbers that are reserved and I need to skip allocationg those autonumbers. How is this done?
Essentially I need to run my routine until I come to the first reserved ...

Hi Group,
Anybody know if its possible from Access 2000 to print of a list of each
table and whats its propertys is? Eg feild size, field type ect etc?
Ta

I would like to hear your suggestions on Access table design for the
following situation:
A shipping company has a costs sheet for each of their customers
containing the shipment cost of goods to several destinations.