I have this sub on ms outlook.
I saves an attachement then opens access. Why MS Access open then it closes.
Public Sub import_supplypro()
On Error Resume Next

I have a table called Orders and a table called OrdersDetails. The key field
on the orders table is an auto number type. I have a form that shows data
from orders with a sub form showing each order's details. Since a lot of our
orders are the same except for the customer ...

I have two tables I want to connect and here are the questions I have.
1. Should I connect using a the primary and foreign keys only.
2. Should I connect using the primary key and the "Skill" Field that appears
in both tables.

I just got Access 2007 the other day and I'm poking about with various
functions, but, I want to do something and I can't figure out how to
do it.
I have three Option Buttons with a label next to them.

I have an excel spreadsheet I need to import into a database weekly.  I
wanted to create a button on a form to automate this process.  I created the
macro and everything works fine however if it's run twice or more it will
import the same data over and over.  I'll end up with ...

I have a report in Access 2007 with a sub report. When I try to view it, I
get the message "ODBC Call Failed". I am opening the database with the Access
Runtime. When I run the report in the full version of Access, I do not get
the error. Any help would be appreciated.

hi community
how can i set different users to use different password for access database
2000 to enter the same database?
10s community for the guidance :)

I have the following code that i cannot get to work. In escence i just
want to click on the button and go to the workshhet named in the
combobox. If i take the combobox away and just type a name into a cell
say A4 it works fine. Obviously i am not referencing the Combobox

How do you create a formula with the end results being a dollar amount when
the cell that the formula references has numbers and text? Example: 5 Boxes
at 5.99=$29.99

I am not all that familiar with writing SQL and am hoping that you'll be able
to help!
I have a table containing sales territories and 3 digit zipcodes. Because of
an overlap in the data, I am not getting a unique list of zipcodes, but

Hello, thank you in advance for your help. I have four tables, Master
Employee, Cell Phone, Position and email. These were all imported from
different spreadsheets. The issue I am having is; The Master Employee table
has all the names and the other tables don't. Some names in all ...

Greetings,
In Access 2003, I have on a report where I have 3 texts boxes side by side.
They are City, State, and Zip Code.  I don’t know enough about code to
develop it on my own, so I was wondering how I could get the fields to auto

I want to put in a formula which says if the VLOOKUP returns a value then
put it in, but if it returns #N/A then put "CLOSED" instead.
Is this possible? I'm sure I've done this before.
Thanks

I am working on designing a database that will be used to audit data through
a form.  The data we receive will come from unique sources and will have
similar, but not always similar, field names and field types.  I know I could
just design tables that are specifically designed to ...

I wwant to get started!