Using A2003 I am working on a Sales and Purchasing db for my company. Sales
are reasonably straight forward as I've adapted some of the Northwind objects
to suit. Purchases, however are a different matter.
I've created the Orders and OrderDetails tables with appropriate fields.

Using Access with Sql Express?
Can you do this?
Is it worth doing?
Here's the situation:

I have a form with a look up field to select values. How do I make it work so
that I can add a new value if not in table and have that display on drop down
for subsequent records?
Thank you

I have an Access datatable with millions of futures trades.  I can create an
Excel pivot table but it only allows me to view grouping of trades by
product, or account.  I cannot view individual trades becuase the unique
field "ID" has to many unique values.  So one idea I had is ...

I run a multitude of reports in MS Access and convert them to the Snapshot
Viewer format for distribution a group of interested parties on a daily
basis.  Most reports are in the landscape orientation.
For one of the recipients, when he prints the Snapshot Viewer format reports

I have a table that I need to selectively update a given row.  I have written
a query that will prompt for the key for the row I want.  I now want it to
prompt me for the data to update "fieldx" on that row, update it and then
prompt me for the next key.  When I am finished, I ...

I have a list box with a value list and i'm able to select more than one
value, however when I select it on one record it changes all of the records -
i need it to be different for each record. if anyone could help me?

Does MS Access support index clustering?

WinXP and Access2K2
I have two tables with a one-to-many relationship. The first table contains
"Operator" data. The second table contains "Operation Location Data". So an
Operator may be operating at more than one location, but his main location

During creating Databse an error occured 'The application is disabled, and
databases may not be created'.  And all menus,tool bar are also disabled.

I am trying to create a table to include fields that are date/time specific
and each time the date is changed to a month that may be within the next
quarter I want the date to automatically go to that quarter and an
explanation to be required for the change. For example, I have a ...

I don't really know if this the right form or how to describe what
information I'm looking for... but I'll try this first:
I have a tables for the folowing items: product types, product layers,
application methods, manufacturer names, a table named after each

I have limited knowledge of Access. I understand macros and have built
several databases. However, I've been asked to develop a way that someone
could complete a form on the internet and then have this information feed
into an Access table.  Is that possible, if yes, what's my ...

In his book "Access VBA Programming for Dummies", page 299, author Alan
Simpson discusses splitting a database into a front end and a back end to
enable simultaneous use. The front end is then distributed to each user "up
to a maximum of five simultaneous users". This seems a ...

I have letters to be sent to a list of people through email. The email list
can change from week to week. Is there a way to automatically assign the list
to the letter. I tried the Send to in the macro but couldn't get it to work
without entering the email addresses. Thanks for ...