I'm a new user and i have developed a database for sales orders and tracking
the development of products.  I have my data in tables however I would like
to know how to automatically fill info on forms. For example I have a table
called kit status that has a combo box titled part no. ...

Hello;
I am in desperate need of help. I offered to pay four people to help me with
this question. They want to charge $150/hr for advice. For $150/hr I want it
done. I will ask the undenyably ask the wrong question for the next six

I need to update a yes/no check box to yes/true if a field contains certain
text.
eg: if a partdescription contains "NLA" or "N.L.A" etc, update the
"discontinued" field to yes/true.

Been a while since I did this & can't remember how.
tblInvoice
InvoiceID PK
VendorID FK

I have a database that includes addresses. If i want to post to everyone
except say those in scotland how could I exclude the scotland addresses from
the query?

This has got to be easy but I'm stumped.  
I have a several combo boxes in a subform to select "Yes", "No" or "N/A"
(from a table).  The form works fine.  I want to report on the results of
each box.  What I get on the report are the row values from the Table (1, 2,

I have an order confirmation that is emailed after the order is entered. I
just added a subform to the Confirmation Report. When I try to send it I get
this message: "The save as command can't process any subforms contained in
your report". This the code I use to send the email:

My database is setup like the Northwind database with the Products,
OrderDetails, and Orders relationships. I also added another many to many
table, Refreshments, a junction table, RefreshmentsDetail, and related that
to the Orders table, OrderID.

i have 133 club members in a table called members list and i want to use a
form to select certain members an place them in a separate form or report

I would like to create an invoice that has a ship to bill to and shipped from
with each having different addresses. can some one steer me in the correct
location to find help on doing this.

At the risk of being sent to a work camp in Siberia, may I ask what's so
awful about look-up functions in tables?
The objection seems to be that they store only the unique ID of any entity,
but display it's name to the user, which makes the user's life easier. Isn't

In developing a new file I've started to normalize the main table.  But on
the form when a data entry attempt is made, the message "Cannot enter value
into blank field on 'one' side of outer join" shows up and the normalized
fields can't be updated.

Just now using Acc07 for new development for the first time and I notice two
incredibly annoying new "features" and I'd like to know if I can revert to
prior behavior.
1) No way to discard new query: Create a new query. Run it, it does what you

Someone please tell me, where did I go wrong with this code?
SQL = "Delete TBL1.A, TBL1.B, TBL1.C, TBL1.D, TBL1.E, TBL1.F, TBL1.G " & _
         "FROM TBL1"
DoCmd.RunSQL SQL

I need to design a new Database to be used on my company's network.  It is a
small network with one main server and approx. 12 frontend computer stations.
This is my first time trying this. All my databases so far have been used on
single computers.  Is there anything I should be ...