I am tryimg to import a simple, small Excel worksheet into a newly created
Access table. The table has the columns for the existing data, plus
additional columns I need.
When I try to do this it seems Access is trying to map the Excel columns in

Hi all.
I used to have a button within my application which when clicked would set
of the compact & repair procedure however, users were not using this so I
decided instead to check the box within Access settings to automatically

I am unsure how to code the following
the table I am working on is Baan
I am selecting the record using the orderNo field
but depending if the field IcyDate empty or not I will open different forms

NOTE: I also have this question posted in another section of this newsgroup
but no answers yet. I am desperate.
I was trying to load an excel spreadsheet into Access and then set the
properties of some fields on that table.

I have a database to track appointments for consultants. What I need
to do is run a report for each consultant and email their individual
reports to them. I'd like to be able to do this from one command
button on the main form. Any ideas how I would do this?

Howdy. I was wondering if anyone knew a somewhat simple way to switch between back end databases using a combo box on a main startup form. I am working with Access 2002.
Each user works from their own copy of the front end on their C: Drive. There are several back end databases ...

Is there a way to insert data to tables automatically using like
somekind of ".bat" file?
Case is this, we have several databases, structure identical, data
varys in each. All of these databases need to have a few identical new

Using Access 2000 and have created a mailing list database.  500-600 entries
have been made and all of sudden could not open reports.  Opened the main
table and have a huge number of rows that simply have an entry of "ERROR#".  
I I attempt tp delete these rows of data a small ...

I have Office 2007 standard edition. How can I purchase Access without the
full upgrade to Office Professional Edition? I see the pricing information
but can't seem to find were to get it.

I read that you can minimize tha navigation pane by selecting F11, but is
there a way when an object such as a query is opened the navigation pane auto
hides?

Trying to create a command button to check certain boxes.
Table is Addresses
Married is checkbox
PrintLabel is checkbox

Trying to create a command button to check certain boxes.
Table is Addresses
Married is checkbox
PrintLabel is checkbox

I pull a report from a query.  When I do so,  I am prompted for date
parameters (part of the query).  I would like the values that I enter for
these parameters to show up on the report.  Any suggestions?
Thanks

There were angry words on this group a couple of days ago on this topic.
I'm wondering what the consensus of other Access developers is regarding
bound forms and unbound forms.
I often use unbound forms and I create classes, like a Customer class with